Skip to main content

DB2 9 for z/OS Technical Overview

An IBM Redbooks publication

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


Published on 28 June 2007, updated 31 March 2010

  1. .PDF (7.7 MB)

Share this page:   

ISBN-10: 0738489131
ISBN-13: 9780738489131
IBM Form #: SG24-7330-00

Authors: Paolo Bruni, Roy Cornford, Rafael Garcia, Sabine Kaschta and Ravi Kumar

    menu icon


    IBM DATABASE 2 Version 9.1 for z/OS (DB2 9 for z/OS throughout this publication) is the thirteenth release of DB2 for MVS.

    It brings improved synergy with the zSeries hardware and more opportunities to drive business value in the following areas:

    -- Business insight innovations

    - Rich hybrid support for relational and pure XML data.

    - Enhanced support for key business partners that allow you to get more from your data in critical business disciplines like ERP.

    - A brand new user interface for the Query Management Facility to view and analyze data from either a workstation client or an ordinary Web browser.

    -- Cost savings through optimized innovations

    - Streamlined security and regulatory compliance through the implementation of roles, network-trusted contexts, and enhanced auditing.

    - Performance-boosting innovations such as load and reorg CPU reductions, improved varying length data, logging, and insert performance.

    - Query management enhancements to make accessing data even faster and more accurate with indexing improvements.

    -- Business resiliency innovations

    - Database on demand capabilities to ensure that information design can be changed dynamically, often without database outages.

    - DB2 restart improvements enhancing performance usability and availability in data sharing environment.

    This book introduces the enhancements made available with DB2 9 for z/OS. It helps you understand the new functions, justify investment in migrating, and plan for exploiting the key new capabilities.

    Table of Contents

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

    Part 1. Subsystem functions

    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. e-business and connectivity

    Part 3. Operations and performance

    Chapter 10. Security

    Chapter 11. Utilities

    Chapter 12. Installation and migration

    Chapter 13. Performance

    Appendix A. DB2 Tools for z/OS


    Others who read this also read