IBM DB2 Version 10.5 for Linux, UNIX, and Windows offers accelerated analytic processing by introducing a new processing paradigm and data format within the DB2 database product. Advantages include significant reductions in time-to-value and increased consumability, which can be achieved through minimal DBA design requirements and reduced query tuning and debugging efforts. Industry-leading compression, large performance gains for analytic queries, and large reductions in performance variation round out the benefits of deploying this technology.
DB2 Version 10.5 fix packs deliver additional enhancements and product changes.
DB2 column-organized tables
DB2 Version 10.5 introduces compressed column-organized tables for DB2 databases. The release also includes broad support for data mart (analytic) workloads with complex queries that are commonly characterized by multi-table joins, grouping and aggregation, and table scans over a star schema.
IBM DB2 pureScale Feature enhancements:
The DB2 pureScale Feature provides extreme capacity and application transparency which exceed even the strictest industry standard. Continued improvements in continuous availability and high availability, the DB2 pureScale Feature tolerates both planned maintenance and component failure with ease. The DB2 Version 10.5 release provides:
Support for high availability disaster recovery (HADR) Increased availability Improved workload balancing Restore mobility between DB2 pureScale Feature and DB2 Enterprise Server Edition
Continuing to build on prior release performance improvements, V10.5 performance improvements focus on explain information for column-organized tables and extension to the CREATE INDEX statement to create an index containing an expression-based key.
If you work with relational database products other than DB2 products,V10.5 builds on existing functionality, interfaces, and compatibility features to provide additional enhancements that make DB2 products more familiar to you. These enhancements reduce the time and complexity of enabling applications that are written for other relational database products to run quickly in a DB2 environment.
Product packaging simplified:
Changes to product packaging results in fewer packages, and greater value through more function and features that are included in the base DB2 editions such as warehouse functionality.