Skip to main content

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

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 09 January 2006

  1. .PDF (6.4 MB)

Share this page:   

ISBN-10: 0738494216
ISBN-13: 9780738494210
IBM Form #: SG24-7134-00

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

    menu icon


    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


    Others who read this also read