{"id":810,"date":"2010-10-15T08:11:10","date_gmt":"2010-10-15T02:11:10","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=810"},"modified":"2016-01-07T11:31:08","modified_gmt":"2016-01-07T05:31:08","slug":"encounter-of-db2-and-oracle","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=810","title":{"rendered":"Encounter of DB2 and Oracle !"},"content":{"rendered":"

On a journey to capture more of Oracle’s market and to meet the latest feature demands IBM decided to introduce another feature rich edition : The DB2 Advanced Enterprise Edition<\/a> . This latest flagship edition brings lot of features you previously had to license individually, \u00c2\u00a0IBM has priced it aggressively making it cheaper than buying them individually. \u00c2\u00a0DB2 AES compared with Oracle makes the price comparison look like a Ford vs Cadillac. DB2 and Oracle are on the same league for performance and features and now the price for DB2 AES being cheaper gives an upper hand for IBM to market its favorite database engine. No offense IDS fans !
\nLets dive a little deeper to see whats in DB2 AES. \u00c2\u00a0DB2 Advanced Enterprise Edition is nothing more than DB2 Enterprise Edition with \u00c2\u00a0bunch more features like :<\/p>\n

DB2 Storage Optimization feature
\nDB2 Advanced Access Control feature
\nDB2 Workload Management feature
\nOptim Performance ManagerData Studio 2.2.1
\nOptim Development Studio 2.2.1
\nOptim Database Administrator 2.2.3
\nHomogeneous Replication feature
\nInfoSphere Federation Server between DB2 and Oracle data sources<\/p>\n

The Storage Optimization feature delivers superior compression of data within tables, indexes, temporary tables, XML data, logs and backups. This greatly reduced the overall cost of the infrastructure that is required. \u00c2\u00a0IBM claims around 83% compression rate on lab. \u00c2\u00a0While doing a PoC, I have noticed 74% compression rate on the databases I run. This feature alone might justify the cost to upgrade from ESE to AESE . \u00c2\u00a0The advanced security feature lets you to have label based access control against individual rows and columns on your tables. \u00c2\u00a0In other words enable you to do fine grain security against your data. \u00c2\u00a0The workload manager helps you to set the priority level of the database workload against your database on the server enabling to meet your SLAs. No more runaway query or poor adhoc report queries eating away cycles. \u00c2\u00a0The product page<\/a> contains a little more details on these features.<\/p>\n

Currently, the package is available on DB2 V9.7 version, but IBM may let you convert your DB2 V9.5 or DB2 V9.1 to AES if you are under passport agreement with a step -up upgrade fee. \u00c2\u00a0How does DB2 Advanced Enterprise Server Edition price against Oracle Enterprise ?<\/p>\n

The follow table is based on a single process that amounts to 100 PVU:<\/p>\n

\"\"<\/a><\/p>\n

* The cost comparison is based on the general pricing list from Oracle<\/a> and IBM<\/a> . For consistency, I have included 12 months of support.<\/p>\n

One of my IBM representative send me the new\u00c2\u00a0db2 edition comparision<\/a> in a pdf file<\/p>\n

\"\"<\/a>I believe IBM has woken up and realized they were lacking features that their competitions where offering. \u00c2\u00a0I wish just include database encryption just like SQL Server Enterprise edition offers. \u00c2\u00a0Now that will be awesome.<\/p>\n","protected":false},"excerpt":{"rendered":"

On a journey to capture more of Oracle’s market and to meet the latest feature demands IBM decided to introduce another feature rich edition : The DB2 Advanced Enterprise Edition . This latest flagship edition brings lot of features you previously had to license individually, \u00c2\u00a0IBM has priced it aggressively making it cheaper than buying […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[303,3,364],"tags":[419,423,413,416,232,424,421,418,415,420,953,414,422,417],"class_list":["post-810","post","type-post","status-publish","format-standard","hentry","category-database","category-db2","category-oracle","tag-advanced-security","tag-data-studio","tag-db2-advanced-enterprise-edition","tag-db2-aes","tag-db2-v97","tag-db2-vs-oracle","tag-encryption","tag-lbac","tag-new-db2-edition","tag-optim","tag-oracle","tag-oracle-enterprise-edition","tag-sql-server-enterprise-edition","tag-storage-optimization"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=810"}],"version-history":[{"count":8,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions"}],"predecessor-version":[{"id":822,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/810\/revisions\/822"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=810"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}