Product to fix broken chains in a database

Products

• IDMS
• IDMS - Database

Issue/Introduction

Is there a product to fix broken chains in an IDMS database?

Environment

Release: All supported releases.
Component: DB Audit.

Resolution

IDMS DB Audit can find and fix broken chains. It can fix errors it has found or simulate error fixing so that both the error and the proposed solution can be evaluated.

Broken chains are usually detected by running the IDMSDBAN utility program. Reports from this utility indicate any pointers that are not in integrity with the database definition and/or or with other pointers.  

For a site that does not have the DB Audit product, broken chains can be corrected manually, using the PRINT PAGE utility to determine the current state of the inaccurate pointers; and the FIX PAGE utility statement to correct the pointers. When manually correcting broken chains, a thorough understanding of the database structure and contents is imperative.

If a backup of the corrupted database is available, another way to address broken chains is to restore the database from the backup and to use the ROLLFORWARD utility (as well as re-running any relevant batch local mode jobs) to restore database updates that were completed after the backup was taken.