On Wednesday October, 3 IBM announced “IBM DB2 11 for z/OS Early Support Program”. IBM intends to make DB2 11 for z/OS (DB2 11) available to a select group of clients in a closed Early Support Program (ESP) on March 8, 2013. The codename for DB2 11 is Sequoia, after the famous large trees in California (if you can pay them a visit please do so, they are fantastic!). You can speculate about the GA date which depends on the results of the ESP of course, but is generally between 6 to 12 months after the ESP starts. This makes sense with the earlier announced the end of service for DB2 9, being June 27, 2014. The period that IBM support three release is normally small like 6 to 12 months. One of the fun things about an ESP announcement is that IBM publicly speaks about the new features of the product announced which is also true for this announcement. Here is a clipping from the announcement letter on the new features of DB2 11:
Save money, save time, reduce cost
- Compared to use of DB2 10, you may achieve up to 5% out-of-the-box CPU savings for many traditional OLTP, heavy INSERT, and SAP workloads.
- Compared to use of DB2 10, you may also achieve up to 20 to 30% out-of-the-box CPU savings for select query workloads. These performance improvements along with use of IBM DB2 Analytics Accelerator for z/OS , can further enable significant query acceleration and potential cost savings.
- New SQL PL ARRAY support may bring up to an additional 10% CPU savings for OLTP workloads with higher read-to-write ratios
- DB2 Utilities now offer more zIIP eligible workload for RUNSTATS and LOAD and faster LOAD processing for improved performance and CPU savings. Additional REORG enhancements minimize DBA workload with automated mapping tables and improved PBG handling.
- Data sharing clients may see performance improvements from a 2x to 5x more efficient index structure modification and from full LRSN spin avoidance.
- You may see additional performance and CPU savings by taking advantage of additional enhancements, including DPSI performance improvements and suppress null indexes.
- Inline statistics gathering enhancements greatly reduces the need for RUNSTATS which can reduce resource consumption.
- Additional optimizer enhancements for distinct, group by, and sparse index support bring performance improvements across a wide variety of queries.
- Deep integration with IBM zEnterprise EC12 (zEC12) brings additional performance improvements in two ways:
- Using pageable large (1 MB) pages and Flash Express
- Enabling support of 2 GB pages
- Cost effective archiving of warm and cold data with easy access to both within a single query
Unmatched resiliency, availability, scalability, and security for business-critical information
- The need for planned outages is significantly reduced with online data repartitioning capabilities, including support for REORG, REBALANCE, SHRLEVEL, CHANGE, and online ALTER LIMITKEY.
- SWITCH phase reduction and improved drain processing in online REORG deliver additional availability improvements.
- Improve productivity and performance through REORG avoidance and auto index pseudo delete cleanup.
- With extended relative byte address (RBA) and log record sequence number (LRSN) addressing support you can avoid many manual recovery actions that can potentially cause extended outages
- Improved backup manageability enables even faster recovery.
- Improved cloning capabilities support automatic VCAT name translation for system-level backup.
Enhanced analytics for business growth
- Deploy real-time scoring directly within the transaction when used in conjunction with IBM SPSS offering.
- Together with IBM DB2 Analytics Accelerator for z/OS and System z , you can efficiently colocate OLTP and data warehouse as one integrated workload in real time with great cost effectiveness.
- DB2 QMF , a separately priced feature of DB2 for z/OS , has also been enhanced to include improved analysis, forecasting, reporting, and presentation capabilities, as well as better storage management, supporting greater analytics on your core business data.
- Improvements in XML, temporal support, and SQL PL deliver even more capabilities for application developers.
- Various SQL enhancements including support for array data types and global variables, make it easier for application developers
Simpler, faster migration for faster ROI
- With the new application compatibility feature, migration plans no longer have to wait for applications to make SQL or XML changes before leveraging new DB2 features.
- Simpler catalog migration helps your business get the value of DB2 11 faster.