IBM Support

Updates to IMS Database Utility Solution V2.1 Overview and Customization

Product Documentation


Abstract

Updates that apply to IMS Database Utility Solution V2.1 Overview and Customization (SC27-8778-00).

Content

The most recent updates appear at the top of the list.


Update 3

Date of change: June 2020

Change description: Documentation changes by APAR PH24779 (APAR for IMS Library Integrity Utilities).

Topics: Changes apply to multiple topics.

==========

Topic: Customizing the tools of IMS Database Utility Solution > Setting up the Integrity Checker utility of IMS Library Integrity Utilities > Planning for Integrity Checker configuration > LICON data sets and global option modules

The following topic has been added as follows:

LICON data sets

image 7001Integrity Checker obtains the DMB information that IMS™ used to load the database, stores the information in the RDE as the correct DMB information, and refers to that DMB information to verify the DMB information obtained from the DBDLIB, ACBLIB, or IMS directory that is referenced by IMS jobs.image 7002

==========

Topic: Customizing the tools of IMS Database Utility Solution > Setting up the Integrity Checker utility of IMS Library Integrity Utilities > Activating Integrity Checker

The following topic has been modified as follows:

About this task

image 7001To activate Integrity Checker, you first prepare the global option modules and the LICON data sets. Then, by using the DBD library, ACB library, or IMS directory, register the DMB information for your databases in the LICON data set.image 7002

==========

Topic:  Customizing the tools of IMS Database Utility Solution > Setting up the Integrity Checker utility of IMS Library Integrity Utilities > Activating Integrity Checker > Setting up the LICON data sets > Creating an RDE to register DMB information

The following topic has been modified as follows:

Procedure

Ensure that you provide the following information with the JCL statements:

  • image 7001Specify the DBD library, the ACB library, or the IMS directory that contains the DMB information to be used in DMB verifications.image 7002

Update 2

Date of change: September 2019

Change description: Documentation updates

Topic: Customizing the tools of IMS Database Utility Solution > Configuring IMS Tools Base

The following table has been updated as follows:

IMS Tools Autonomics Director Distributed Access Infrastructure IMS Tools Common Services IMS Tools Knowledge Base Policy Services
IMS Database Reorganization Expert Optional Optional Optional Optional Optional
IMS HP Unload - Optional image 7001Optionalimage 7002 Optional -
IMS HP Load - Optional image 7001Optionalimage 7002 Optional -
IMS Index Builder - Optional Optional Optional -
IMS HP Image Copy Optional Optional Optional Optional Optional
IMS HP Pointer Checker Optional Optional Optional Optional Optional
IMS Library Integrity Utilities - - image 7001Optionalimage 7002 - -
IMS Library Integrity Utilities extension (DBD/PSB Map Viewer) - Required - Required -
IMS HALDB Toolkit - - image 7001Optionalimage 7002 - -
Database Sensor Optional Optional Optional Optional Optional
Database Repair Facility - - - - -

Update 1

Date of change: August 2019

Change description: Documentation updates

Topics: Changes apply to multiple topics.

==========

Topic: IMS Database Utility Solution for z/OS overview > What is IMS Database Utility Solution?

This topic has been updated as follows:

IBM IMS Library Integrity Utilities for z/OS

IBM IMS Library Integrity Utilities for z/OS (also referred to as IMS Library Integrity Utilities) provides a set of utilities designed to validate, compare, map, recover, report, and regenerate a number of IMS libraries needed for operations.

image 7001Supported libraries include the ACB (application control block), DBD (database description), PSB (program specification block), MFS (Message Format Service) libraries, libraries containing DFSMDA members, IMS catalog, IMS directory, and RECON (recovery control) data sets. The utilities are used in conjunction with database maintenance tasks and migration operations, and to prevent accidental misuse in production.image 7002

To learn more about IMS Library Integrity Utilities, see the IMS Library Integrity Utilities User's Guide.

IMS Library Integrity Utilities also provides the DBD/PSB Map Viewer, which is an IMS Library Integrity Utilities extension for Management Console. The DBD/PSB Map Viewer displays graphical visualization of a database structure map, program specifications, DBD and PSB macro source, and DBD and PSB XML document. You can also use the cross reference feature to list logical DBDs and PSBs that refer to a specific DBD.

==========

Topic: IMS Database Utility Solution for z/OS overview > Benefits

This topic has been updated as follows:

The tools of IMS Database Utility Solution help you simplify and accelerate the database maintenance tasks for IMS full-function databases and HALDBs.

IMS Database Utility Solution provides a set of tools that help IMS DBAs in every phase of database management. The tools are high performance, easy-to-use, and powerful, and include capabilities for database reorganization, data backup, tuning, monitoring, and optimization of IMS databases.

IMS Database Utility Solution provides the following benefits:

  • The high performance reorganization tool can save time and money by reducing the CPU and elapsed time required for IMS database reorganization tasks, and for the IMS database retrieval and initial loading application programs by providing the APIs.
  • IMS Database Reorganization Expert further reduces time and resource requirements by enabling unload, load, index build, and backup tasks to run concurrently, and by eliminating I/Os for intermediate data sets. It also enhances the productivity of DBAs by making the reorganization processes simpler and easier, and by minimizing manual interventions.
  • IMS Database Reorganization Expert saves online system resources by evaluating the database with user-specified criteria, and running the reorganization job only when reorganization is determined to be effective for the database.
  • IMS Index Builder eliminates the need to image copy and log updates to IMS index data sets by providing a quick and efficient method for rebuilding indexes. It also provides the ability to add new indexes to existing IMS databases as needed.
  • IMS HP Image Copy reduces the unavailability time of databases by providing rapid image copy features, parallel processing, and minimized manual interventions. It also reduces operational and media costs by compressing and stacking the image copies.
  • IMS HP Pointer Checker helps ensure that your database pointers are error free. Used in conjunction with Database Repair Facility, it helps you detect and correct database errors quickly and repair them with minimum downtime to your IMS environment.
  • image 7001IMS Library Integrity Utilities enhances the productivity of DBAs by providing utilities that effectively manage IMS ACB, DBD, PSB, MFS libraries, libraries containing DFSMDA members, IMS catalog, IMS directory, and RECON data sets in database maintenance tasks and migration operations. It also avoids application downtime by preventing database corruption that might occur from accidental misuse of IMS libraries in production. image 7002
  • IMS Library Integrity Utilities provides a graphical view of IMS databases and program specifications through Management Console. Database structures, program specifications, and source code can be reviewed to simplify database administration tasks. The graphical interface can be used as an educational tool for new DBAs to learn about databases.
  • With the automated sensor data collection and exception detection that are provided by Autonomics Director and IMS Database Utility Solution, you can save time and resources in monitoring and tuning IMS full-function databases.
  • With the graphical web interface that is provided by Management Console, you can analyze your IMS environment to rapidly identify database exceptions and tuning opportunities.
  • IMS HALDB Toolkit efficiently diagnoses HALDB structures and suggests effective database structures.

Publication Number

SC27-8778-00

Document Location

Worldwide

[{"Line of Business":{"code":"LOB35","label":"Mainframe SW"},"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCLV2","label":"IMS Database Utility Solution for z\/OS"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Document Information

Modified date:
25 March 2021

UID

ibm10967611