DB2 V10 New Features to Read now

DB2 V10 new features to read now

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 tablespaces) while maximizing the availability of the altered objects.
  • ALTER statement enhancements let you change indexes and tablespaces 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 WHERE clauses with the various timestamps and join conditions.
  • For inserts, DB2 generates the appropriate values for system and transaction start times without having to reference them in the statement. 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)

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.