Skip to main content

DB2 9 for z/OS: Using the Utilities Suite

An IBM Redbooks publication

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


Published on 19 February 2010, updated 28 April 2010

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

Google Play Books

Share this page:   

ISBN-10: 0738434051
ISBN-13: 9780738434056
IBM Form #: SG24-6289-01

Authors: Paolo Bruni, Marcelo Antonelli, Davy Goethals, Armin Kompalka and Mary Petras

    menu icon


    IBM® continues to enhance the functionality, performance, availability, and ease of use of IBM DB2® utilities.

    This IBM Redbooks® publication is the result of a project dedicated to the current DB2 Version 9 Utilities Suite product. It provides information about introducing the functions that help set up and invoke the utilities in operational scenarios, shows how to optimize concurrent execution of utilities and collect information for triggering utilities execution, and provides considerations about partitioning.

    It also describes the new functions provided by several utilities for SHARE LEVEL CHANGE execution, which maximize availability and the exploitation of DFSMS constructs by the BACKUP and RESTORE SYSTEM utilities.

    This book concentrates on the enhancements provided by DB2 UDB for z/OS Version 8 and DB2 for z/OS Version 9. It implicitly assumes a basic level of familiarity with the utilities provided by DB2 for z/OS and OS/390® Version 7.

    Table of Contents

    Part 1. Introduction

    Chapter 1. Introduction

    Part 2. Planning for DB2 utilities

    Chapter 2. Managing partitions

    Chapter 3. Simplifying utilities with wildcarding and templates

    Chapter 4. Performance via parallelism of executions

    Chapter 5. Invoking and controlling executions

    Chapter 6. Sort processing

    Part 3. Executing DB2 utilities

    Chapter 7. Loading and unloading data

    Chapter 8. Reorganizing data

    Chapter 9. Copying data

    Chapter 10. Recovering data

    Chapter 11. Gathering statistics

    Chapter 12. Verifying data consistency

    Chapter 13. BACKUP and RESTORE SYSTEM utilities

    Chapter 14. Operational considerations

    Appendix A. DB2 Tools

    Appendix B. Utilities related maintenance


    Others who read this also read