Database Administration Tools | An Introduction to IMS: Your Complete Guide to IBMs Information Management System

The following sections describe the IBM IMS database administration tools.

The IBM Data Encryption for IMS and DB2 Databases tool:

Provides user-customizable, pre-coded exit routines for encryption of IMS and DB2 data.
Conforms to the existing OS/390 and z/OS security model and is implemented using standard IMS and DB2 exit routines.
Exploits zSeries and S/390 Crypto Hardware features, which results in low overhead encryption and decryption.
Uses the ANSI Data Encryption Algorithm (DEA), which is also known as the U.S. National Institute of Science and Technology (NIST) Data Encryption Standard (DES) algorithm.
Works at the IMS segment level, and can be customized at that level. For DB2, encryption and decryption is customizable at the table level.

Program number: 5799-GWD

The IBM IMS Database Repair Facility for z/OS:

Interactively repairs VSAM- and OSAM-organized IMS databases that contain pointer or data errors.
Performs repairs quickly, thereby reducing the amount of time that the affected database is taken offline.
Supports IMS Fast Path DEDB databases.
Features VSAM and OSAM pointer repair, pointer navigation, a backout safety feature, and an ISPF front end.
Runs in interactive mode, in which you can view entire blocks of data of individual IMS segments and can navigate to other segments. Any changes made are tracked and can be undone.
Runs in batch mode, in which you can dump blocks from the data set or submit changes to the block data.

Program number: 5655-E03

The IBM IMS Hardware Data Compression - Extended for z/OS tool:

Replaces and extends the dictionary creation and Segment Edit/Compression exit routine creation utilities of IMS.
Provides HDC enhanced analysis capability, including extended reporting and multiple input sources.
Offers dictionary archival and evaluation services.
Supports compression of HDAM, HIDAM, HISAM, and Fast Path databases.

Program number: 5655-E02

The IBM IMS High Availability Large Database (HALDB) Conversion and Maintenance Aid for z/OS:

Guides DBAs through HALDB conversions with ease.
Performs index pointer healing.
Speeds the conversion process with partition modeling.
Enables conversion with minimal manual intervention.
Requires no HALDB experience and little IMS expertise.
Creates DBD and DBRC definitions as well as the conversion JCL.
Provides additional conversion options such as Initial HALDB Load assistance and Status Code 'BA' Aid.
Includes a Partition Maintenance Aid that supports split partitions, DBRC functions for HALDB, creation of backup and recovery JCL, and generation of reorganization utilities.

Program number: 5655-K47

The IBM IMS Library Integrity Utilities for z/OS:

Includes and replaces all of the features and functions of the IMS Library Management Utilities:
- Managing IMS ACB, PSB, and DBD libraries
- DBD/PSB/ACB Compare, DBD/PSB/ACB Reversal, and DBD/PSB/ACB Mapper and IMS Advanced ACB Generator
- Providing a high-speed generation process that greatly reduces the time needed to process large volumes of IMS ACBs
- Reporting information in a tabular form
- Checking results from your desktop and ensuring that all PSBs and DBDs were processed as expected
Includes an Integrity Checker to help prevent system outages caused by databases corrupted by using the wrong DBD.
Includes a Consistency Checker function to ensure that all the necessary definitions have been created for a database.

Program number: 5655-I42

The IBM IMS Online Reorganization for z/OS tool:

Enables reorganization of IMS full-function databases with a short outage (a short period of time called takeover time).
Reorganizes databases to shadow data sets, captures the changes during this period, and applies them to the reorganized shadow data sets.
Requires databases and their data sets to be registered with DBRC.
Reorganizes HISAM, HIDAM, HDAM, and SHISAM databases, and recreates their associated index data sets.
Reorganizes PHIDAM and PHDAM databases as single partitions.
Makes selected DBD changes during the reorganization process that are automatically propagated to the participating online systems without the need of launching an online change.
Allows predefinition of the period when takeover time may occur.
Automatically creates the shadow data sets: SMS allocation uses the same SMS constructs; non-SMS allocation uses the same volume serial, and user predefinition.
Supports a user exit during reload that can be called to process any changes.

Program number: 5655-H57

The IBM IMS Parameter Manager for z/OS tool:

Enables IMS administrators to control the specification and maintenance of IMS parameter library members.
Simplifies parameter management and provides increased levels of parameter control.
Supports the 19 startup parameter members in an IMS system startup.
Allows parameter specification by ISPF dialog panels or the integrated ISPF editor.
Contains extensive online help and parameter descriptions.
Provides parameter syntax and value checking, and automatic parameter statement construction.
Provides a view of active (current) parameter members by IMS system.
Enables the creation of a "back-up" member immediately prior to applying changes.
Automatically collects previous version histories for altered parameter members.
Includes facilities to assist with IMS software version migration.

Program number: 5655-L69

The IBM IMS Sequential Randomizer Generator for OS/390:

Creates a randomizer that enables the user to access HDAM and DEDB database segments either directly or sequentially.
Allows access to HDAM and DEDB databases in logical key sequence without sacrificing their efficient direct access capabilities.
Optimizes the distribution of database records by adjusting the randomizing module if the number of synonyms or the control interval (CI) or block utilization exceeds the user-specified value.

Program number: 5655-E11