Note: A new draft version of this publication is now available
IBM® DB2® Tools for z/OS® support and use 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 more 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 that grow exponentially, the effect of managing utility jobs, meeting service level agreements, and ensuring recoverability can be overwhelming. IBM offers DB2 Tools that help the DB2 utilities management process.
DB2 Tools can help you achieve higher availability and better performance while enhancing the productivity of both database administrators and system programmers. These benefits can be achieved whether the suite is optimizing utilities performance and resource utilization with DB2 Sort and DB2 High Performance Unload, or building intelligence into utilities execution with DB2 Automation Tool. Or, the benefits can be achieved by implementing shop standards and DB2 best practices with DB2 Utilities Enhancement Tool, or using technology to streamline operations with DB2 Recovery Expert and DB2 Cloning Tool.
The objective of this IBM Redbooks® publication is to document the added value in terms of productivity and performance when DB2 database administrators use the DB2 tools solution package.
The following functions are shown in real life scenarios and best practices are also described:
- Automating backup scheduling
- Recovering and rebuilding
- Optimizing the maintenance window
- Cloning scenarios
- Automating utilities executions
Table of contents
Chapter 1. Introduction
Chapter 2. Automating backup scheduling
Chapter 3. Recovering and rebuilding
Chapter 4. Optimizing the maintenance window
Chapter 5. Cloning scenarios
Chapter 6. Automating utilities executions
Appendix A. Test configuration
Appendix B. IBM DB2 administrative task scheduler
Appendix C. Introducing the IBM Tools Customizer
Appendix D. IBM DB2 Sort installation and evaluation
Appendix E. Additional material