What’s new in DB2 11?
IBM made DB2 11 for z/OS ( DB2 11) generally available on October 25, 2013. The new release of DB2 for z/OS contains a great mix of performance, availability and productivity features. Below you can find an overview of the DB2 11 features.
- Mobile Devices
DB2 11 provides secure connections to mobile devices, allowing applications like QMF to confidently provide users access to queries, reports, or dashboards through an ordinary web browser or mobile devices.
- Big Data
DB2 11 easily connects to IBM’s Hadoop based BigInsights big data platform using SQL, providing you a simple way to integrate your traditional applications on DB2 for z/OS with big data analytics.
- Integration with SAP
SAP has announced their successful validation and support of DB2 11.
- Application CPU savings
DB2 11 follows up with additional CPU savings and improved performance. IBM’s internal testing and Early Support Program results show that, depending on the specific workload, you may achieve “out-of-the-box” DB2 CPU savings of up to 10% for complex online transaction processing (OLTP) and up to 10% for update-intensive batch workloads. Complex reporting queries can see up to 25% for uncompressed tables and up to 40% CPU savings when running queries against compressed tables.
- Data sharing performance
For the DB2 11 release, a comprehensive set of performance tweaks is introduced to improve buffer pool management, lock management and restart/recovery, and to reduce CPU overhead due to log record sequence number (LRSN) spin.
- Transparent data archiving
New features in DB2 11 build on the temporal data support introduced in DB2 10 give developers an efficient and transparent way to access both current and archived data within a single SQL statement.
- Utility enhancements
The RUNSTATs and LOAD utilities have been enhanced to make greater use of any available zIIP Specialty Engines, potentially improving performance and reducing CPU consumption. Online REORG has had a major overhaul, with improved availability, support for automatic mapping tables and the ability to handle partition rebalancing. At the same time, the requirement to run REORG at all has been reduced by enabling DB2 to automatically clean up pseudo-deleted index entries. While many utility enhancements were available in Conversion Mode (CM) in previous releases, the majority of the DB2 11 enhancements are not accessible until you have entered New Function Mode (NFM).
- Log scalability
DB2 11 expands RBA/LRSN values to 10 bytes, increasing the addressable range to a mind-boggling 1 yottabyte (280). This helps IBM customers who are approaching (or have already hit) the maximum log relative byte address (RBA) range possible using the existing 6-byte format.
- Online schema change
IBM is steadily working through the list of most-requested features to allow database objects to be changed while maintaining availability. New in DB2 11 is the capability to DROP columns from a table, and alter partitioning limit keys. Point-in-time recovery is also now supported where there are deferred schema changes.
- Application compatibility
A new application compatibility feature in DB2 11 allows existing applications to continue to run under the new release until those changes can be implemented, removing them as an upgrade dependency.
- zEC12 hardware
The latest generation of IBM zEnterprise® EC12 servers—announced in August 2012—include a new feature known as Flash Express. This is a special solid-state disk (SSD) array that acts as a new memory tier between the redundant array of independent memory (RAIM) and disk. DB2 11 will be able to use this as a better alternative to auxiliary/disk if there is insufficient real storage available (although the best advice is still to not over-commit your real storage). Customers will also be able to use 1 MB page frames without having to page-fix their buffer pools (DB2 10 mandated page-fixing if large pages were used) and page frames of up to 2GB will be supported.