Db2 version 10 new features

How to check db2 version on zos using only sql commands. For this release, you can migrate a db2 version 8 subsystem or data sharing group in newfunction mode to db2 10. Ibm support for db2 version 8 ended this year and support for version 9 will end in june 2014. In with the new db2 luw version 11 and out with the old db2 versions. Db2 advanced enterprise server edition aese version 10. Next, with every new version of db2 there are old versions that go out of support. Ca expedites required db2 10 upgrades for zos network world. New performance perks db2 v10 is supposed to be a performance release, and ibm boldly claims some customers see 5% to 10 % cpu improvements out of the box for traditional workloads and 20% for nontraditional. To get more information about a feature, click the link or hover the mouse pointer over the text. Ibm releases db2 version 10, the first big upgrade in four years. New application features db2 11 provides expanded support for sql, xml, and temporal tables, which results in improved application performance. Db2 10 uses a new set of stored procedures and catalog tables to. This table outlines which features were added in which version.

One index gives you uniqueness and indexonly access. Db2 10 will let you include additional columns in the index that are not included in the key to enforce uniqueness. New db2 v10 features and performance searchdatacenter. Many new features that were introduced with db2 10 for zos are not yet. Thinking about upgrading to a new version of db2 brings us to the thorny. Db2 version 10 is the first major update for the database system. Being aware of these changes facilitates your current application development and plans to upgrade to version 11. As with the past features articles, this is a summary of the new features in v11. Learn about new db2 v10 features that can help optimize performance, including temporal tables and subgroups. Ibm aims to meld db2 with machine learning, data science workflows. Db2 10 substantially increases the amount of virtual storage that can be addressed by moving most db2 working memory from 32bit to 64bit continuous availability enhancements. Ibm announced end of support for db2 10 was effective september 30, 2017 and end of. If you are using db2 10, be aware that db2 11 will be removed from. Online schema enhancements allow you to make changes to database objects indexes and table spaces while maximizing the.

Review the following topic to determine whether you need to manage the effect of these changes. Ca database management solutions for db2 for zos 20 pdf. Part of the savings come from db2 exploiting the z9 instruction set, which is currently the lowest supported ibm processor. There is a fairly intense push to get people to version 10, combs said. Ibm releases db2 version 10, the first big upgrade in four. The good news is, as usual, that ibm is not rushing us to get off old versions. Whats changed includes information about changes in existing functionality from version 10.

Migration as with each version of db2 for zos, db2 11 continues to provide substantial improvements that make migration easier and faster. Sap on db2 for linux, unix, and windows db2 for luw. Ibm is giving us all until the fall of 2017 to upgrade any older db2 luw 9. Its tests with the new db2 have shown it could increase data compression by 20 percent, on top of the alreadysubstantial. Ibm aims to meld db2 with machine learning, data science. Being aware of these changes facilitates your current. Both hash access and index include wont be available until the release of db2 10 new function mode nfm. For information about changes to db2 database products and features, see functionality in db2 product editions and db2 offerings.