{"id":1304,"date":"2012-04-09T17:36:43","date_gmt":"2012-04-09T11:36:43","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=1304"},"modified":"2016-01-07T11:31:04","modified_gmt":"2016-01-07T05:31:04","slug":"db2-10-arrives","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=1304","title":{"rendered":"DB2 10 arrives !"},"content":{"rendered":"<p>IBM <a href=\"http:\/\/www-01.ibm.com\/software\/data\/db2-warehouse-10\/\" target=\"_blank\">announces<\/a> DB2 10 for Linux Unix and Windows ! \u00c2\u00a0Code named Galileo, DB2 10 arrives with some neat features. We all know DB2 V9.7 was loaded with features, especially with Oracle compatibility. IBM has improved upon the Oracle compatibility mode making it almost 98%.<br \/>\n<a href=\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2012\/04\/MovetoDB2530x150.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-medium wp-image-1307\" title=\"MovetoDB2530x150\" src=\"https:\/\/techsatwork.com\/blog\/wp-content\/uploads\/2012\/04\/MovetoDB2530x150-300x84.jpg\" alt=\"\" width=\"300\" height=\"84\" srcset=\"https:\/\/techsatwork.com\/wp-content\/uploads\/2012\/04\/MovetoDB2530x150-300x84.jpg 300w, https:\/\/techsatwork.com\/wp-content\/uploads\/2012\/04\/MovetoDB2530x150.jpg 530w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/a>DB2 10 for LUW should be available for general electronic download on April 30, 2012 and for media order on June 11, 2012.<br \/>\nAs usual the new DB2 is feature rich. IBM has packed some neat features on DB2 10. Among them some key ones are:<\/p>\n<ul>\n<li>Adaptive Compression<\/li>\n<li>Time Travel Query<\/li>\n<li>Enhanced security<\/li>\n<li>High performance warehouse features (Zigzag join)<\/li>\n<li>Multi Temperature data management<\/li>\n<li>Enhanced\u00c2\u00a0Workload Tuner<\/li>\n<li>Continuous data ingestion<\/li>\n<li>DB2 pureScale(enhancements)<\/li>\n<\/ul>\n<p><span class=\"Apple-style-span\" style=\"font-size: 16px; color: #444444; font-family: Georgia, 'Bitstream Charter', serif; line-height: 24px;\">IBM has also made changes to features available on DB2 editions.<\/span><\/p>\n<p><strong>Summary of DB2 10.1 edition changes:<\/strong><\/p>\n<p>Resource limits for each edition, where applicable, are also listed below.<\/p>\n<p><strong>DB2 Express-C:<\/strong><\/p>\n<ul>\n<li>Time Travel Query.<\/li>\n<li>IBM Data Studio.<\/li>\n<li>Memory limit has been increased to 4 GB. Processor core limit has been increased to two. Both limits are per physical server, or where partitioned, virtual server.<\/li>\n<\/ul>\n<p><strong>DB2 Express Edition:<\/strong><\/p>\n<ul>\n<li>Row and Column Access Control.<\/li>\n<li>Label Based Access Control<\/li>\n<li>Time Travel Query.<\/li>\n<li>High Availability Disaster Recover (HADR).<\/li>\n<li>IBM Data Studio.<\/li>\n<li>Memory limit has been increased to 8 GB. Processor core limit remains at four. Both limits are per physical server, or where partitioned, virtual server.<\/li>\n<\/ul>\n<p><strong>DB2 Workgroup Server Edition:<\/strong><\/p>\n<ul>\n<li>Row and Column Access Control.<\/li>\n<li>Label Based Access Control.<\/li>\n<li>Time Travel Query.<\/li>\n<li>IBM Data Studio.<\/li>\n<li>Memory limit remains at 64 GB. Processor core limit remains at 16. Both limits are per physical server, or where partitioned, virtual server.<\/li>\n<\/ul>\n<p><strong>DB2 Enterprise Server Edition:<\/strong><\/p>\n<ul>\n<li>Row and Column Access Control<\/li>\n<li>Label Based Access Control<\/li>\n<li>Time Travel Query<\/li>\n<li>Multi-Temperature Data Management<\/li>\n<li>IBM Data Studio<\/li>\n<\/ul>\n<p><strong>DB2 Advanced Enterprise Server Edition:<\/strong><\/p>\n<ul>\n<li>Row and Column Access Control<\/li>\n<li>Label Based Access Control<\/li>\n<li>Time Travel Query<\/li>\n<li>Multi-Temperature Data Management<\/li>\n<li>Storage Optimization Feature, including Adaptive Compression<\/li>\n<li>Continuous Data Ingest<\/li>\n<li>IBM Data Studio<\/li>\n<li>InfoSphere Data Architect (10 users)<\/li>\n<li>InfoSphere Optim Configuration Manager<\/li>\n<li>InfoSphere Optim Performance Manager Extended Edition<\/li>\n<li>InfoSphere Optim Query Workload Tuner<\/li>\n<li>InfoSphere Optim pureQuery Runtime for LUW<\/li>\n<\/ul>\n<p><strong>IBM Database Enterprise Developer Edition:<\/strong><\/p>\n<ul>\n<li>Row and Column Access Control<\/li>\n<li>Label Based Access Control<\/li>\n<li>Time Travel Query<\/li>\n<li>Multi-Temperature Data Management<\/li>\n<li>Storage Optimization Feature, including Adaptive Compression<\/li>\n<li>Continuous Data Ingest<\/li>\n<li>IBM Data Studio<\/li>\n<li>InfoSphere Data Architect<\/li>\n<li>InfoSphere Optim Configuration Manager<\/li>\n<li>InfoSphere Optim Performance Manager Extended Edition<\/li>\n<li>InfoSphere Optim Query Workload Tuner<\/li>\n<li>InfoSphere Optim pureQuery Runtime for LUW<\/li>\n<\/ul>\n<p><span style=\"font-size: small;\">Here is a <a href=\"http:\/\/www-01.ibm.com\/common\/ssi\/cgi-bin\/ssialias?subtype=ca&amp;infotype=an&amp;appname=iSource&amp;supplier=897&amp;letternum=ENUS212-074\" target=\"_blank\">link<\/a> that gives you a more in-depth look at the features<\/span><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>IBM announces DB2 10 for Linux Unix and Windows ! \u00c2\u00a0Code named Galileo, DB2 10 arrives with some neat features. We all know DB2 V9.7 was loaded with features, especially with Oracle compatibility. IBM has improved upon the Oracle compatibility mode making it almost 98%. DB2 10 for LUW should be available for general electronic [&hellip;]<\/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],"tags":[778,780,775,776,785,784,774,782,783,781,777,779],"class_list":["post-1304","post","type-post","status-publish","format-standard","hentry","category-database","category-db2","tag-adaptive-compression","tag-continuous-data-ingest","tag-db2-10","tag-db2-galileo","tag-db2-oracle-compatiblity","tag-db2-udb-v10","tag-db2-v10","tag-db2-v10-features","tag-db2-v10-luw","tag-new-db2-features","tag-time-travel-query","tag-zigzag-join"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1304","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=1304"}],"version-history":[{"count":5,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1304\/revisions"}],"predecessor-version":[{"id":1492,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/1304\/revisions\/1492"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1304"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1304"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1304"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}