DB2 9 for z/OS: Using the Utilities Suite

An IBM Redbooks publication

Published 19 February 2010, updated 27 April 2010

cover image

ISBN-10: 0738434051
ISBN-13: 9780738434056
IBM Form #: SG24-6289-01
(514 pages)

More options

Rate and comment

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


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

Follow IBM Redbooks

Follow IBM Redbooks