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.

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