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

A draft IBM Redbooks publication


Abstract

IBM Tools for z/OS support and takee advantage of the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and 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, the effect of managing utility jobs, meeting service level agreements, 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 data base 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

Disclaimer

These pages are Web versions of IBM Redbooks- and Redpapers-in-progress. They are published here for those who need the information now and may contain spelling, layout and grammatical errors.

This material has not been submitted to any formal IBM test and is published AS IS. It has not been the subject of rigorous review. Your feedback is welcomed to improve the usefulness of the material to others.

IBM assumes no responsibility for its accuracy or completeness. The use of this information or the implementation of any of these techniques is a customer responsibility and depends upon the customer's ability to evaluate and integrate them into the customer's operational environment.


Profile

Last Update
21 May 2013

Planned Publish Date
14 June 2013


Rating: Not yet rated


Author(s)

IBM Form Number
SG24-8046-01

Feedback