Monday, September 3, 2007

Redbook DB2 9 for z/OS Performance Topics

Hi DB2 User,

IBM published a new Redbook, "DB2 9 for z/OS Performance Topics, SG24-7473-00" :

IBM® DB2® 9 for z/OS® is an exciting new version, with many improvements in performance and very little regression. DB2 V9 improves availability, security and adds greatly to SQL and XML function.

Optimization improvements include more SQL function to optimize, improved statistics for the optimizer, better optimization techniques and a new approach to providing information for tuning. V8 SQL procedures were not eligible to run on the zIIP, but changing to use the native SQL Procedure Language on DB2 V9 makes the work eligible for zIIP processing. Varying length data can improve substantially if there are large numbers of varying length columns. Several improvements in disk access can reduce the time for sequential disk access and improve data rates.

The key DB2 9 for z/OS performance improvements are reduced CPU time in many utilities, deep synergy with System z™ hardware and z/OS software, improved performance and scalability for inserts and LOBs, improved SQL optimization, zIIP processing for remote native SQL procedures, index compression, reduced CPU time for data with varying lengths and better sequential access. Virtual storage use below the 2 GB bar is also improved.

This IBM® Redbooks® publication provides an overview of the performance impact of DB2 9 for z/OS, especially performance scalability for transactions, CPU and elapsed time for queries and utilities. We assume you are somewhat familiar with DB2 V9, see DB2 9 for z/OS Technical Overview, SG24-7330 for an introduction to new functions. We discuss the overall performance and possible impacts when moving from version to version. We include performance measurements made in the laboratory and some estimates, but your results are likely to vary, as the conditions and work will differ.

Table of Contents

Chapter 1. DB2 9 for z/OS at a glance
Chapter 1. Overview
Chapter 2. SQL performance
Chapter 3. XML
Chapter 4. DB2 subsystem performance
Chapter 5. Availability and capacity enhancements
Chapter 6. Utilities
Chapter 7. Networking and e-business
Chapter 8. Data sharing enhancements
Chapter 9. Installation and migration
Chapter 10. Performance tools
Appendix A. Summary of performance maintenance
Appendix B. Statistics report
Appendix C. EXPLAIN tables
Appendix D. INSTEAD OF triggers test case
Appendix E. XML documents

More information

- Redbook DB2 9 for z/OS Technical Overview

- Several IBM presentations about DB2 9 for z/OS are available on IBM's website



Labels: ,