Skip to main content

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

An IBM Redbooks publication

thumbnail 

Published on 16 July 2013

  1. .EPUB (4.1 MB)
  2. .PDF (4.4 MB)

Apple BooksGoogle Play Books

Share this page:   

ISBN-10: 0738438472
ISBN-13: 9780738438474
IBM Form #: SG24-8046-01


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

    menu icon

    Abstract

    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

     

    Others who read this also read