DB2 11 for z/OS Performance Topics

A draft IBM Redbooks publication

Abstract

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. Introduction
Chapter 2. Subsystem
Chapter 3. Synergy with z platform
Chapter 4. Availability
Chapter 5. Analytics Accelerator
Chapter 6. Data sharing
Chapter 7. SQL
Chapter 8. Application enablement
Chapter 9. Distributed environment
Chapter 10. Utilities
Chapter 11. Installation and migration
Chapter 12. Monitoring
Appendix A. Recent maintenance
Appendix B. The IBM DB2 workloads
Appendix C. To REBIND or not to REBIND


Disclaimer

These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.

IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.


Profile

Last Update
15 May 2014

Planned Publish Date
29 August 2014


Rating:
(based on 2 reviews)


Author(s)

ISBN-10
0738439673

ISBN-13
9780738439679

IBM Form Number
SG24-8222-00

Number of pages
348

Feedback