IBM IMS Solutions for Automating Database Management

IBM IMS Solutions for Automating Database Management

by Paolo Bruni, Rafael Henrique Vedovatto Bindillati, James Kelly, Rick Long, Acacio Ricardo Gomes Pessoa
Released December 2014
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

Over the last few years, IBM® IMS™ and IMS tools have been modernizing the interfaces to IMS and the IMS tools to bring them more in line with the current interface designs. As the mainframe software products are becoming more integrated with the Windows and mobile environments, a common approach to interfaces is becoming more relevant. The traditional 3270 interface with ISPF as the main interface is no longer the only way to do some of these processes. There is also a need to provide more of a common looking interface so the tools do not have a product-specific interface. This allows more cross product integration.

Eclipse and web-based interfaces being used in a development environment, tooling using those environments provides productivity improvements in that the interfaces are common and familiar. IMS and IMS tools developers are making use of those environments to provide tooling that will perform some of the standard DBA functions. This book will take some selected processes and show how this new tooling can be used. This will provide some productivity improvements and also provide a more familiar environment for new generations DBAs. Some of the functions normally done by DBA or console operators can now be done in this eclipse-based environment by the application developers. This means that the need to request these services from others can be eliminated.

This IBM Redbooks® publication examines specific IMS DBA processes and highlights the new IMS and IMS tools features, which show an alternative way to accomplish those processes. Each chapter highlights a different area of the DBA processes like:

  • PSB creation

  • Starting/stopping a database in an IMS system

  • Recovering a database

  • Cloning a set of databases

    •

    Table of contents

    1. Front cover
    2. Figures
    3. Examples
    4. Notices
      1. Trademarks
    5. IBM Redbooks promotions
    6. Preface
      1. Authors
      2. Now you can become a published author, too!
      3. Comments welcome
      4. Stay connected to IBM Redbooks
    7. Chapter 1. IMS modernization and tools for autonomics
      1. 1.1 Architecture changes
      2. 1.2 Tools for IMS developers
      3. 1.3 Tools for IMS system programmers
      4. 1.4 Tools for IMS database administration
    8. Chapter 2. Defining a PSB
      1. 2.1 PSB creation using IMS Enterprise Suite Explorer for Development
      2. 2.2 PSBGEN
      3. 2.3 Combined ACBGEN utility and Catalog Populate utility
      4. 2.4 Online Change Copy utility and Batch Single Point of Contact utility
      5. 2.5 Define a BMP to the IMS system
        1. 2.5.1 Taking advantage of dynamic resource definition to define BMP to IMS System
        2. 2.5.2 Starting your BMP using SPOC
        3. 2.5.3 Executing your BMP
      6. 2.6 Listing IMS catalog DBDs and PSBs using SQL Query Builder Function of IMS Suite Enterprise Explorer for Development
    9. Chapter 3. Setting up recovery
      1. 3.1 IMS recovery overview
        1. 3.1.1 Brief overview of logging
        2. 3.1.2 DBRC at a glance
        3. 3.1.3 Application update processing
        4. 3.1.4 Recovery processing
      2. 3.2 Performing an IMS database recovery
        1. 3.2.1 ALLOC record timestamps
        2. 3.2.2 Image copy timestamps
        3. 3.2.3 GENJCL.RECOV DBRC command
      3. 3.3 DB recovery to last image copy
        1. 3.3.1 DBRC GENJCL.RECOV example
        2. 3.3.2 IMS Recovery Expert example: recovery to last image copy
      4. 3.4 Creating a DBRC recovery point
        1. 3.4.1 Recovery Expert example: recovery to a point in time
      5. 3.5 Finding a quiet point in a log
        1. 3.5.1 Finding a quiet time
      6. 3.6 Point in time recovery
        1. 3.6.1 Using Database Recovery Facility to a quiet time
        2. 3.6.2 Recovery Expert example: create recovery to quiet time
        3. 3.6.3 Example using DRF PITR outside a quiet time
    10. Chapter 4. Configuring IMS
      1. 4.1 Setting up IMS and Plex using IMS Configuration Manager
      2. 4.2 Managing IMS resources
        1. 4.2.1 Creating resource groups
        2. 4.2.2 Creating change packages
      3. 4.3 Updating resources groups
      4. 4.4 Deleting resource groups
      5. 4.5 Promoting application definitions from development to test or test to production
    11. Chapter 5. Cloning IMS databases
      1. 5.1 Cloning using traditional techniques
      2. 5.2 Copying databases to another IMS region with IMS Cloning Tool
        1. 5.2.1 Job control language when copying to another IMS region
        2. 5.2.2 IMS Cloning Tool control cards when copying to another IMS region
        3. 5.2.3 Job output when copying to another IMS region
      3. 5.3 Creating copies of production databases with IMS Cloning Tool
        1. 5.3.1 JCL to create a production copy
        2. 5.3.2 Cloning a single HIDAM database
        3. 5.3.3 Cloning multiple databases in a single step
      4. 5.4 Using the IMS Database Recovery Facility to clone databases
        1. 5.4.1 JCL to clone multiple databases using the Database Recovery Facility
        2. 5.4.2 Output from DRF cloning job
      5. 5.5 Disaster recovery
    12. Chapter 6. Managing a database
      1. 6.1 Autonomics for database reorganization
        1. 6.1.1 Reorganizing databases using traditional methods
        2. 6.1.2 Reorganizing databases using IMS Database Reorganization Expert
        3. 6.1.3 Conditional reorg using IMS Database Reorganization Expert
      2. 6.2 Managing fragmentation
    13. Chapter 7. Health management for IMSplex
      1. 7.1 Using IBM Management Console for IMS and DB2 for z/OS to understand the health of databases
      2. 7.2 Database troubleshooting sample: Limited availability of data set extents
        1. 7.2.1 Checking an Exception Message
        2. 7.2.2 Resolving limited availability of data set extents
      3. 7.3 Using IBM Management Console for IMS and DB2 for z/OS to manage transaction or program status
    14. Appendix A. Referenced IMS tools
      1. A.1 IBM IMS Enterprise Suite Explorer for Development
      2. A.2 IBM IMS Recovery Expert
      3. A.3 IBM IMS Database Recovery Facility for z/OS
      4. A.4 IBM IMS Configuration Manager for z/OS
      5. A.5 IBM IMS Cloning Tool for z/OS
      6. A.6 IBM Management Console for IMS and DB2 for z/OS V1.1
      7. A.7 IMS Database Solution Pack
    15. Related publications
      1. IBM Redbooks
      2. Other publications
      3. Online resources
      4. Help from IBM
    16. Back cover
    17. IBM System x Reference Architecture for Hadoop: IBM InfoSphere BigInsights Reference Architecture
      1. Introduction
      2. Business problem and business value
      3. Reference architecture use
      4. Requirements
      5. InfoSphere BigInsights predefined configuration
      6. InfoSphere BigInsights HBase predefined configuration
      7. Deployment considerations
      8. Customizing the predefined configurations
      9. Predefined configuration bill of materials
      10. References
      11. The team who wrote this paper
      12. Now you can become a published author, too!
      13. Stay connected to IBM Redbooks
    18. Notices
      1. Trademarks

    Product information

    • Title: IBM IMS Solutions for Automating Database Management
    • Author(s): Paolo Bruni, Rafael Henrique Vedovatto Bindillati, James Kelly, Rick Long, Acacio Ricardo Gomes Pessoa
    • Release date: December 2014
    • Publisher(s): IBM Redbooks
    • ISBN: None