DB2 V10 is released by IBM. Here are some new and improved features:
Automation:
Self tuning memory, Automatic Maintenance, Health Monitoring features, Automatic storage management, and Self-Configuration features.
Storage optimization:
DB2 can dramatically reduce that cost with industry leading data compression technologies that compress tables, indexes, archive logs, temporary space, LOBs, XML, and back-up data. Adaptive data compression applies multiple compression techniques, including both table-wide and page-level compression, for maximum impact.
Performance:
DB2 Workload Manager is now integrated with DB2 pureScale and includes a powerful time-based control mechanism that can be quickly configured and deployed to automatically throttle low priority workloads.
Security:
DB2 offers a comprehensive suite of security features including authentication, authorization, trusted contexts, auditing, row and column access control, label-based access control, and encryption.
SQL Compatibility:
The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, and more.
Time Travel Query:
Time Travel Query helps you to make your existing DB2 tables time-aware easily and provides a cost-effective means to resolve auditing and compliance issues.
You can achieve full traceability of backdated corrections through the use of bitemporal tables and allowing DBAs to use an existing SQL application and run it
across different time periods.