Willie Favero is currently an IBM Senior Certified IT Software Specialist and the DB2 for z/OS SME for the Data Warehouse on System z Swat Team at IBM's Silicon Valley Lab. He is also a member of IBM's zChampion team, a representative for System z with IBM's Academic Initiative , an IBM Certified DBA for DB2 10 for z/OS, DB2 9 for zOS, and DB2 for z/OS Version 8, an IBM Certified DB2 9 and DB2 10 System Administrator for z/OS , and certified on DB2 UDB and DB2 for OS/390 Version 7.
It’s time to make a little trip over to the IBM Redbooks website. The Redbooks publication many of the DB2 folk are waiting for, the one everyone is anticipating, the one that gives you all the what goes faster and uses less CPU information is finally available as a draft. This is the Redbooks publication with all the good stuff.
Sure, the DB2 11 for z/OS Technical Overview Redbooks publication ( SG24-8180) has a very nice overview of almost all of the new features in DB2 11, but it’s the Performance book that has the good stuff. Of course, the Performance Redbooks publication is still only available as a draft. However, in the past nothing really major tends to change before the final is available. On the off chance that something significant or juicy does change, it will give you the perfect reasons to re-read it... and I will let you know.
I must admit, I haven’t read the entire book yet. However, I have read a good chunk of it, and what I have read is excellent.
BTW, the list of primary authors on the DB2 11 Performance IBM Redbooks publication is very impressive. Download it now, don’t wait. I’ll let you know when the final version is available so you can download that also... (smile)....
The DB2 11 Performance Topics Redbook is ONLY available as a PDF download because it is still a draft. The other formats should be available once the final version is available.There is also a DB2 11 for z/OS Buffer Pool Monitoring and Tuning Redbooks publication ( REDP-5092) that is available for download in PDF format as a draft.
The next bit of information, the abstract and table of contents, is copied directly from the Redbooks website... no originality from me necessary...
To compete in a 24x7 global economy, enterprises need to be able to bring the applications that drive their business to the market faster and integrated with big data analytics. These applications must be able to handle larger numbers of concurrent users with performance, reliability and efficiency.
IBM DB2® 11 for z/OS may reduce the total DB2 CPU demand from 5-40% when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities like rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings depending on the application mix and transaction types. Increase in zIIP eligibility also can contribute to cost reduction.
Improvements in optimization reduce costs by processing SQL automatically with more efficient data access paths and special handling of compressed data provide more efficiency without changes to applications. Update intensive batches run with less CPU cost due to more efficient log processing. These enhancements can reduce total CPU enterprise costs because of improved efficiency in the DB2 11 for z/OS®. Increase in zIIP eligibility also can contribute to cost reduction: additional utilities processing in RUNSTATS, REORG, and LOAD now run under an enclave SRB and are therefore eligible for zIIP processing.
Utility performance capabilities can deliver up to 70% LOAD, up to 40% RECOVER, and up to 20% in REORG elapsed time improvements
With performance improvements in DB2 11, you may see 5% to 10% CPU reduction with large results returning from the separately available IBM DB2 Analytics Accelerator compared to DB2 10.
This IBM® Redbooks® publication provides an overview of the performance of DB2 11 for z/OS discussing the performance and possible impacts of the most important functions when moving from DB2 10. We include performance measurements that were made in the laboratory and provide some estimates. Keep in mind that your results are likely to vary, as the conditions and work will differ.
In this book, we assume that you are somewhat familiar with DB2 11 for z/OS. See DB2 11 for z/OS Technical Overview, SG24-8180-00, for an introduction to the new functions.
Table of contents
Chapter 1. DB2 11 at a glance and general performance expectation
Chapter 2. Subsystem
Chapter 3. Synergy with z platform
Chapter 4. Analytics Accelerator
Chapter 5. Data sharing
Chapter 6. SQL
Chapter 7. Application enablement
Chapter 8. Distributed environment
Chapter 9. Utilities
Chapter 10. Security
Chapter 11. Installation and migration
Chapter 12. Monitoring and Tools