The following features are added in DB2V10:
- Improved scalability: DB2 10 substantially increases the amount of virtual storage that can be addressed by moving most DB2 working memory from 32-bit to 64-bit
- Continuous availability enhancements: Online schema enhancements allow you to make changes to database objects (indexes and table spaces) while maximizing the availability of the altered objects.
ALTERstatement enhancements let you change indexes and table spaces without needing to unload the data, drop and re-create the objects, regenerate all of the security authorizations, re-create the views, and reload the data
Temporal tables and versioning: One of the most exciting is built-in support for temporal data.
Using system time and business time: Defining a table with a system time period instructs DB2 10 to automatically capture changes made to the state of the table and to save the “old” rows in a history table.
Simple SQL queries that reference the current table but also need data in the history table will cause DB2 to transparently access the history table as needed, providing easy access to historical data without complex
WHEREclauses with various timestamp and join conditions.
For inserts, DB2 generates the appropriate values for system and transaction start times without having to reference them in the
INSERTstatement. When updating current data, DB2 automatically maintains old versions of the data in the appropriate history table—transparently.
DB2 and System z: A perfect match: DB2 10 delivers significant, out-of-the-box CPU savings for many workloads, and customers can see the benefits by simply migrating and rebinding. Application development has never been easier for DB2 for z/OS. With DB2 10’s temporal data features, application developers and system administrators can support time-based data more easily than ever before. (Ref: IBM)