DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration

DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration

by Paolo Bruni, Tom Crocker, Elaine Morelli, Richard Schaufuss
Released August 2013
Publisher(s): IBM Redbooks
ISBN: None

Read it now on the O’Reilly learning platform with a 10-day free trial.

O’Reilly members get unlimited access to books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial

Book description

IBM® DB2® tools for z/OS® support and exploit 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.

DB2 Administration Solution Pack for z/OS V1.1 (5697-DAM) offers features, functions, and processes that database administrators (DBAs) can use to more effectively and efficiently manage DB2 environments.

DB2 Administration Solution Pack for z/OS is composed of the following tools:

  • IBM DB2 Administration Tool for z/OS

  • IBM DB2 Object Comparison Tool for z/OS

  • IBM InfoSphere® Optim™ Configuration Manager for DB2 for z/OS

  • IBM DB2 Table Editor for z/OS


    • This IBM Redbooks® publication shows how the delivered capabilities can help DBAs to more easily complete tasks associated with object management, change management, application management, and configuration management.

    Table of contents

    1. Front cover
    2. Figures
    3. Tables
    4. Examples
    5. Notices
      1. Trademarks
    6. Preface
      1. Authors
      2. Now you can become a published author, too!
      3. Comments welcome
      4. Stay connected to IBM Redbooks
    7. Part 1 DB2 Tools Solution Packs
      1. Chapter 1. The DB2 Tools Solution Packs
        1. 1.1 DB2 Tools Solution Packs
        2. 1.2 Overview of the IBM Tools Customizer
          1. 1.2.1 Installing the base for solution packs
      2. Chapter 2. The Tools Customizer
        1. 2.1 Component selection
        2. 2.2 Installation discovery
        3. 2.3 DB2 entries and association
        4. 2.4 Component customization
        5. 2.5 Generation of customization jobs
    8. Part 2 Solution pack components
      1. Chapter 3. Installing the DB2 Administration Solution Pack
        1. 3.1 The DB2 Administration Solution Pack
        2. 3.2 DB2 Administration for z/OS component customization
        3. 3.3 DB2 Object Comparison for z/OS component customization
        4. 3.4 DB2 Table Editor for z/OS component customization
        5. 3.5 InfoSphere Optim Configuration Manager for DB2 for z/OS customization
      2. Chapter 4. DB2 Administration Tool for z/OS
        1. 4.1 Overview of DB2 Administration Tool for z/OS
          1. 4.1.1 Object management
          2. 4.1.2 Security management
          3. 4.1.3 Performance management
          4. 4.1.4 Change management
          5. 4.1.5 System management
          6. 4.1.6 Application management
        2. 4.2 New features in DB2 Administration Tool for z/OS
          1. 4.2.1 ALL primary command
          2. 4.2.2 Catalog navigation shortcut
          3. 4.2.3 DET line command
          4. 4.2.4 CP line command: Copy Privileges
          5. 4.2.5 Enhancements to UTIL
      3. Chapter 5. DB2 Object Comparison Tool for z/OS
        1. 5.1 Overview of DB2 Object Comparison Tool for z/OS
          1. 5.1.1 DB2 Object Comparison Tool general concepts
          2. 5.1.2 DB2 Object Comparison Tool process flow
        2. 5.2 Integration of DB2 Object Comparison Tool with DB2 Administration Tool for z/OS
      4. Chapter 6. DB2 Table Editor for z/OS
        1. 6.1 Overview of DB2 Table Editor for z/OS
          1. 6.1.1 DB2 Table Editor elements
          2. 6.1.2 DB2 Table Editor components
        2. 6.2 Integration of DB2 Table Editor for z/OS with DB2 Administration Tool for z/OS
      5. Chapter 7. InfoSphere Optim Configuration Manager
        1. 7.1 Optim Configuration Manager overview
        2. 7.2 Optim Configuration Manager architecture
          1. 7.2.1 Optim Configuration Manager server
          2. 7.2.2 Optim Configuration Manager web interface
          3. 7.2.3 Optim Configuration Manager clients
          4. 7.2.4 Optim Configuration Managed Servers
          5. 7.2.5 Optim Configuration Manager DB2 repository
        3. 7.3 Features and functions of Optim Configuration Manager
          1. 7.3.1 Client and server properties
          2. 7.3.2 Assist migrations
          3. 7.3.3 Application controls
      6. Chapter 8. Solution pack product integration
        1. 8.1 Integration between DB2 Administration Tool and DB2 Object Comparison Tool
        2. 8.2 Integration between DB2 Administration Tool and DB2 Table Editor
        3. 8.3 Integration between DB2 Administration Tool, DB2 Object Comparison Tool, and Optim Configuration Manager
    9. Part 3 Use cases
      1. Chapter 9. Change management
        1. 9.1 IBM change management vocabulary
        2. 9.2 Options for defining a change
        3. 9.3 Options for propagating a change
      2. Chapter 10. The environment for the change management scenario
        1. 10.1 Database environment
      3. Chapter 11. Using DB2 Administration Tool and DB2 Object Comparison Tool
        1. 11.1 Sample change request
        2. 11.2 Change scenario 1: Alter BC_PROJ Table
          1. 11.2.1 Alter (AL or ALT) the BC_PROJ table
          2. 11.2.2 Propagate the change
        3. 11.3 Change scenario 2: ALT Tables and change propagation delta change
          1. 11.3.1 Alter (ALT) the BC_EMPLOYEE and BC_DEPARTMENT tables
          2. 11.3.2 Propagate the change by generating or importing a delta change file
        4. 11.4 Change Scenario 3: Recover a change
      4. Chapter 12. Using Optim Configuration Manager
        1. 12.1 Usage cases
        2. 12.2 Defining location alias
        3. 12.3 Server configuration changes
          1. 12.3.1 Making changes
          2. 12.3.2 Identifying changes
        4. 12.4 Client configuration information and changes
          1. 12.4.1 Displaying client information
          2. 12.4.2 Identifying client changes
          3. 12.4.3 Automatically scheduling client comparisons
          4. 12.4.4 Managed Clients and WebSphere Application Server
        5. 12.5 Managing applications
          1. 12.5.1 Configuring Application Properties
          2. 12.5.2 Configuring Driver Properties
          3. 12.5.3 Configuring WebSphere connection pool
          4. 12.5.4 Redirecting Managed Clients
          5. 12.5.5 Activating the rule set
        6. 12.6 Monitoring changes from the DB2 Administration Tool and the DB2 Object Comparison Tool
    10. Appendix A. Optim Configuration Manager Comparison reports
      1. A.1 Data source properties
      2. A.2 Driver properties
      3. A.3 General properties
    11. Related publications
      1. IBM Redbooks
      2. Other publications
      3. Online resources
      4. Help from IBM
    12. Back cover

    Product information

    • Title: DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration
    • Author(s): Paolo Bruni, Tom Crocker, Elaine Morelli, Richard Schaufuss
    • Release date: August 2013
    • Publisher(s): IBM Redbooks
    • ISBN: None