Skip to main content

DB2 10 for z/OS Technical Overview

An IBM Redbooks publication

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


Published on 31 December 2010, updated 16 July 2014

  1. .EPUB (6.4 MB)
  2. .PDF (9.3 MB)

Google Play Books

Share this page:   

ISBN-10: 0738435112
ISBN-13: 9780738435114
IBM Form #: SG24-7892-00

Authors: Paolo Bruni, Rafael Garcia, Sabine Kaschta, Josef Klitsch, Ravi Kumar, Andrei Lurie, Michael Parbs and Rajesh Ramachandran

    menu icon


    IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVS™. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas:

    • Cost savings and compliance through optimized innovations
      • DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components reduces CPU use by taking advantage of the latest processor improvements and z/OS enhancements.
      • Streamline security and regulatory compliance through the separation of roles between security and data administrators, column level security access, and added auditing capabilities.

    • Business insight innovations
      • Productivity improvements are provided by new functions available for pureXML®, data warehousing, and traditional online TP applications
      • Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP Bitemporal support for applications that need to correlate the validity of data with time.

    • Business resiliency innovations
      • Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages
      • DB2 operations and utility improvements enhancing performance, usability, and availability by exploiting disk storage technology.

    The DB2 10 environment is available either for brand new installations of DB2, or for migrations from DB2 9 for z/OS or from DB2 UDB for z/OS Version 8 subsystems.

    This IBM Redbooks® publication introduces the enhancements made available with DB2 10 for z/OS. The contents help you understand the new functions and performance enhancements, start planning for exploiting the key new capabilities, and justify the investment in installing or migrating or skip migrating to DB2 10.

    Table of Contents

    Chapter 1. DB2 10 for z/OS at a glance

    Part 1. Subsystem

    Chapter 2. Synergy with System z

    Chapter 3. Scalability

    Chapter 4. Availability

    Chapter 5. Data sharing

    Part 2. Application functions

    Chapter 6. SQL

    Chapter 7. Application enablement

    Chapter 8. XML

    Chapter 9. Connectivity and administration routines

    Part 3. Operation and performance

    Chapter 10. Security

    Chapter 11. Utilities

    Chapter 12. Installation and migration

    Chapter 13. Performance

    Part 4. Appendixes

    Appendix A. Information about IFCID changes


    Others who read this also read