Skip to main content

DB2 for z/OS Administration Tools for Enhanced Change Management

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 25 June 2007

  1. .PDF (5.0 MB)

Share this page:   

ISBN-10: 0738489360
ISBN-13: 9780738489360
IBM Form #: SG24-7441-00

Authors: Paolo Bruni, Lucy Krantz, Frank Nikodem, Guenter Pfann and Marc White

    menu icon


    A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes.

    When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, function test, acceptance test, volume test, and production systems. Often changes have to be implemented across multiple DB2 subsystems.

    The two IBM DB2 for z/OS tools that help database administrators to implement database changes are the DB2 Administration Tool and the DB2 Object Comparison Tool.

    In this IBM Redbooks publication we show how, with Version 7.2, the two tools offer an enhanced Change Management function to manage and track the changes of your DB2 objects. We show how the tools help you define changes, resolve conflicts, register the changes, analyze the changes to generate a work statement list that applies the changes, and then run the changes in the correct order. The Change Management functions also allow you to back out completed changes and facilitate the management of a convenient audit trail.

    This book contains a major update to the Change Management functions described in DB2 for z/OS Tools for Database Administration and Change Management, SG24-6420-01.

    Table of Contents

    Part 1. Introduction

    Chapter 1. Tools overview

    Part 2. Getting started with change management

    Chapter 2. Customization

    Chapter 3. First steps with DB2 Admin

    Chapter 4. Working with the Change Management functions

    Part 3. Change Management scenario

    Chapter 5. Implementing an initial design (V0)

    Chapter 6. Implementing changes to a design (Vn)

    Chapter 7. Rolling out new versions of a database design

    Chapter 8. Recovery of changes

    Chapter 9. Additional considerations


    Others who read this also read