DB2 UDB for z/OS: Design Guidelines for High Performance and Availability

An IBM Redbooks publication

Published 09 January 2006

cover image

ISBN-10: 0738494216
ISBN-13: 9780738494210
IBM Form #: SG24-7134-00
(490 pages)

More options


Authors: Paolo Bruni, Patric Becker, Jan Henderyckx, Joseph Link, Bart Steegmans


Conducting business via the Web and remaining open for business 24 hours a day, seven days a week is now commonplace. Customers come in with unexpected workloads through the Web and operate in a self-service fashion with mostly context-sensitive metadata to guide them. The strong requirement is availability. However, even with new Web applications, most of the core business systems considerations still apply, and performance is critical.

Technology has been accelerating for mainframe systems. They had become adept at providing business resiliency accommodating strategic software that has been around for the last several decades such as IMS™ , DB2® , and CICS® , and they have also become a host for developing and running Web applications built in Java™ accommodating the latest business requirements. Businesses need to leverage, extend and integrate the strategic assets which represent multi-year investments to support leading edge technology.

DB2 for z/OS® has come a long way and provides facilities to exploit the latest hardware and software technologies, accommodating a majority of user requirements. However, special considerations are required to build high performance applications. If you want to achieve high performance or high availability, you must use the design, programming, and operational techniques applicable to DB2.
In this IBM Redbooks publication we discuss many of these techniques and provide guidelines for database and application design. We expect the best practices described in this book will help DB2 professionals design high-performance and high-availability applications.

Table of contents

Part 1. Database Design
Chapter 1. Table design
Chapter 2. Index design
Chapter 3. Model validation
Part 2. Application Enabling Components
Chapter 4. Constraints
Chapter 5. Techniques to generate numbers
Chapter 6. Database side programming
Chapter 7. XML support
Part 3. Embedding SQL in the Application
Chapter 8. SQL fundamentals
Chapter 9. Programming templates
Chapter 10. Advanced programming techniques
Chapter 11. Infrastructure topics
Part 4. Designing for availability and performance
Chapter 12. What you need to know about locking
Chapter 13. Achieving 24x7
Chapter 14. Determining the application quality
Part 5. Data Sharing
Chapter 15. Data sharing specifics
Appendix A. DB2's access techniques
Appendix B. Detailed performance reports
Appendix C. Additional material

Follow IBM Redbooks

Follow IBM Redbooks