Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs

An IBM Redbooks publication

Published 16 July 2013

cover image

ISBN-10: 0738438472
ISBN-13: 9780738438474
IBM Form #: SG24-8046-01
(582 pages)

More options

Rate and comment

Authors: Paolo Bruni, Carlos Alberto Gomes da Silva Junior, Craig McKellar, Adilet Sabyrbaev, Tim Willging


IBM® DB2® Tools for z/OS® support and take advantage of the latest versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and for optimization of data performance. In addition, the IBM portfolio addresses additional client requirements in the areas of data governance and version upgrade acceleration.

Underlying the operation of any database management system are the utilities. With the number of database objects growing exponentially, managing utility jobs, meeting service level agreements (SLAs), and ensuring recoverability can be overwhelming. IBM offers DB2 Tools solution packs that assist in the DB2 utilities management process. Solution packs combine several products into a single consolidated solution providing everything necessary to ensure the execution of a set of database administration functions. The goals are to reduce the operational complexity and reduce cost.

The objective of this IBM Redbooks® publication is to document the added value in terms of productivity and performance for database administrators when using the IBM DB2 Utilities Solution Pack and the IBM DB2 Fast Copy Solution Pack. We show the functions of the tools provided by the solution packs as used in real-life scenarios and adopting utilities best practices.

Table of contents

Part 1. Overview and background information
Chapter 1. DB2 Tools solution packs
Chapter 2. FlashCopy technology
Chapter 3. Backup and recovery concepts and functions
Part 2. IBM DB2 Utilities Solution Pack
Chapter 4. IBM DB2 High Performance Unload for z/OS
Chapter 5. IBM DB2 Sort for z/OS
Chapter 6. IBM DB2 Automation Tool for z/OS
Chapter 7. IBM DB2 Utilities Enhancement Tool for z/OS
Part 3. IBM DB2 Fast Copy Solution Pack
Chapter 8. IBM DB2 Recovery Expert for z/OS
Chapter 9. IBM DB2 Cloning Tool for z/OS
Appendix A. Test environment
Appendix B. DSNZPARMs and general settings
Appendix C. Additional material

Follow IBM Redbooks

Follow IBM Redbooks