Updates that apply to IMS Database Solution Pack for z/OS V2.2 Overview and Customization (SC27-9037-02).
Date of change: September 2019
Change description: Documentation updates
Topic: Customizing IMS Database Solution Pack > 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 Online Reorganization Facility||Optional||Optional||Required||Optional||Optional|
|IMS HALDB Toolkit||-||-||Optional||-||-|
|IMS Database Reorganization Expert||Optional||Optional||Optional||Optional||Optional|
|IMS HP Unload||-||Optional||Optional||Optional||-|
|IMS HP Load||-||Optional||Optional||Optional||-|
|IMS HP Prefix Resolution||-||Optional||Optional||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||-||-||Optional||-||-|
|IMS Library Integrity Utilities extension (DBD/PSB Map Viewer)||-||Required||-||Required||-|
|IMS Administration Tool||-||Required||Required||Required||-|
|Database Repair Facility||-||-||-||-||-|
Date of change: August 2019
Change description: Documentation updates
Topics: Changes apply to multiple topics.
Topic: IMS Database Solution Pack for z/OS overview > Tools in IMS Database Solution Pack > IBM IMS Library Integrity Utilities for z/OS
This topic has been updated as follows:
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.
Supported 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.
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.
Integration with other IMS Tools
IMS Library Integrity Utilities provides many utilities for maintaining IMS libraries. All the utilities are used as stand-alone utilities. However, the DBD/PSB/ACB Mapper utility can be called in IMS Database Reorganization Expert jobs, IMS Online Reorganization Facility jobs, and IMS HALDB Toolkit jobs to print database hierarchy.
The DMB verification function of the Integrity Checker utility uses RDEs (registered DMB entries) to prevent database corruptions caused by accidental misuse of ACBs or DBDs. When a DMB verification-enabled database is initially loaded or reorganized by one of the following IMS tools, the Integrity Checker automatically creates an RDE for the database:
- IMS Database Reorganization Expert
- IMS HP Load
- IMS Online Reorganization Facility
IMS Library Integrity Utilities extends the functions of IMS Administration Tool. IMS Library Integrity Utilities enables database and application administration, such as viewing, adding, changing, and deleting IMS objects. It also enables comprehensive reporting of IMS objects, such as DBDs and PSBs, and validation of IMS objects, such as DBDLIB/PSBLIB, ACBLIB, and IMS catalog.
The DBD/PSB Map Viewer must be installed to Management Console to extend the functionality of Management Console.
All the utilities of IMS Library Integrity Utilities do not support IMS Tools Base.
Topic: IMS Database Solution Pack for z/OS overview > Benefits
This topic has been updated as follows:
IMS Database Solution Pack helps you simplify and accelerate the database maintenance tasks for IMS full-function databases and HALDBs.
IMS Database Solution Pack provides a complete 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, health check, verification, tuning, monitoring, and optimization of IMS databases.
IMS Database Solution Pack provides the following benefits:
- The high performance reorganization tools 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 Online Reorganization Facility reorganizes online databases without affecting IMS transactions and applications.
- 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.
- IMS 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.
- 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.
- IMS Administration Tool provides a comprehensive set of functions and features to assist the DBAs with tasks associated with managing IMS environments. The tool provides an online interface, including integration with Management Console, allowing real-time management of IMS environments.
- With the automated sensor data collection and exception detection that are provided by Autonomics Director and IMS Database Solution Pack, 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.
Topic: Scenarios: Managing IMS full-function databases and HALDBs > Manage IMS ACB/DBD/PSB/MFS libraries and RECON data sets
The title of this topic has been changed to "Manage IMS libraries".
Also, this topic has been updated as follows:
Database administration and change management are the core responsibilities of DBAs. If not managed correctly, they can monopolize data center resources, waste valuable time, and can result in the generation of unwanted errors.
In managing the database administration and change management process, DBAs are faced with many challenges like how do I:
- Ensure that I complete all of the necessary steps when making a change?
- Manage and track the changes to the definitions of my database objects?
- Propagate changes to other database environments quickly?
- Prevent accidental misuse in production?
The answers to these questions are provided by IMS Library Integrity Utilities. This tool helps you by providing the features and functions that enable you to manage your ACB libraries, DBD libraries, PSB libraries, MFS libraries, libraries containing DFSMDA members, IMS catalog, IMS directory, and RECON data sets. These features and functions include:
- The IMS Advanced ACB Generator utility, which contains additional features and functions to help you manage your IMS ACB libraries more effectively and provides a high-speed generation process.
- The Consistency Checker utility, which helps you ensure that the necessary definitions in your IMS subsystem have been created.
- The Integrity Checker utility, which protects your databases from corruption caused by using the wrong IMS control blocks for access.
- The Multiple Resource Checker utility, which helps you identify the resources that contain different definitions across multiple sets of RECON data sets or DBDLIBs, PSBLIBs, and ACBLIBs.
- The Catalog Manager utility, which helps you ensure that the DBDs and PSBs in the IMS catalog are maintained correctly by validating the consistency of DBDs and PSBs in the ACB libraries with those in the IMS catalog.
- The MDA Reversal utility, which converts DFSMDA members back into DFSMDA macros and generates a report that contains a list of DFSMDA members.
04 February 2020