BMC AMI Online Reorg for IMS solution


BMC AMI Online Reorg for IMS is the total solution for database reorganization.

The solution includes all the necessary functionality required to perform online and near-online reorganizations for performance improvement.

 

BMC AMI Online Reorg for IMS includes the following functions:

Function

Description

Online Reorg function

The Online Reorg function:

  • Provides a near online reorganization for full-function databases.
  • Lets you reorganize an online database and retain full access.
  • Enables you to update the database while it is being reorganized.
  • Manages the reorganization. While the database is being reorganized, the Online Reorg function captures the updates and applies the changes to the reorganized database when the reorganization is complete. The Image Copy function is invoked to take an image copy of the database as it is being reorganized. The database must be offline for a short time at the beginning and the end of the reorganization.

Reorg function

The Reorg function:

  • Provides the ability to invoke the Image Copy function to take an image copy of the database as it is being reorganized.
  • Lets you reorganize a database and have read access to the database while it is being reorganized.
  • Invokes the other functions to reorganize the database. The database must be off-line for a short time (usually less than one minute) to swap data set names. The Prefix Resolution and Update function in the Reorg function manages logical relationships.

Unload function

The Unload function replaces the IMS HD Reorganization Unload utility, the IMS Database Scan utility, and HSSR.

Reload function

The Reload function replaces the IMS HD Reorganization Reload utility.

Index Build function

The Index Build function replaces the six IMS utilities that are required to build secondary indexes. The Index Build function provides the ability to build primary and secondary indexes in the same job step, with one command and one pass of the database.

The Index Build function performs the following functions:

  • Creates a new secondary index for an existing database
  • Maintains or rebuilds an existing secondary index
  • Rebuilds a primary index for a HIDAM or PHIDAM database

For more information, see Index Build function—features and benefits

Copy function

You can perform the following operations with the COPY command:

  • Create a copy of a production database, both full function and HALDB (the whole database or one or more partitions, including the ILDS)
  • Reorganize indexes and remove CI/CA splits
  • Move data sets to new volumes
  • Heal HALDB pointers in secondary indexes and logical relationships
  • Copy a subset of partitions of HALDB databases and indexes
  • Copy HALDB ILDS and/or primary index
  • Create a no-outage, batch image copy

For more information, see Overview of the Copy function .

Image Copy function

The Image Copy function takes an image copy of the database as it is being reorganized.

Prefix Resolution and Update function

The Prefix Resolution and Update function is invoked by the Online Reorg function (via the Reorg function). The Prefix Resolution and Update function also invokes the Image Copy function. The Prefix Resolution and Update function replaces the IMS Prefix Resolution and Prefix Update utilities and includes several optional functions.

Online/Defrag function

The Online/Defrag feature is innovative technology that offers customized analyses so that you can identify and reorganize only those areas of a database that need to be reorganized. The Online/Defrag feature is also the only function that keeps your database online—all day, every day. Online/Defrag does not replace traditional reorganizations. You must still perform regular reorganizations. Online/Defrag is a supplemental function that provides targeted online reorganizations.

DBA Toolkit

The DBA Toolkit offers JCL generation and historical analysis features. The JCL generator lets you automatically generate and submit optimized JCL to perform reorganization tasks for full-function IMS databases. The historical analysis feature displays historical data about your IMS database data sets and segments so that you can identify and predict database trends.

Non-disruptive maintenance

Using this function, you can update the CHANGE RECORDING FACILITY (CRF) and Online Defrag (OLR) components that execute in the IMS control region without requiring that the IMS control region be recycled.

For information about implementing this function, see the Installation System documentation.

The following figure shows how the standard functions work together.

BMC AMI Online Reorg for IMS overview

GUID-342C0E1E-D02B-4EFA-B2CD-44E076925440-low.png

BMC took the first step toward an online reorganization with the introduction of the Reorg function. The Reorg function creates a 'shadow'' of a database during reorganization and allows read capabilities during almost the entire reorganization. You can make some database description (DBD) changes during the reorganization. A short outage is needed to swap the data set names after the reorganization and to make the reorganized database available. The Reorg function includes a Parallel Image Copy feature. The only missing function was the ability to update the database while its shadow is being reorganized. The Online Reorg function provides this missing piece.

The Online Reorg function is an extension of the Reorg function that lets you update a database while it is being reorganized. The Online Reorg function does not write before and after log records for the shadow database; this keeps traffic away from the log data sets. The Online Reorg function requires a short outage to swap the data set names. Complicated scenarios, such as manually stopping and restarting batch message processing programs (BMPs), doing online changes after a DBD change, or other unusual processing, might cause the outage to be longer.

DBRC control is essential to the integrity and success of the reorganization process. The Online Reorg function and Online/Defrag function require DBRC registration. For more information, see DBRC support.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI Online Reorg for IMS 5.2