I have broken chains in my CA-IDMS database and want to fix them. Is there a product that does this?

Document ID : KB000028298
Last Modified Date : 14/02/2018
Show Technical Document Details

Question:

I have broken chains in my CA-IDMS database and want to fix them. Is there a product that does this?

 

Answer:

Yes, CA-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.

DB Audit is one of the IDMS tools and must be purchased & licensed separately from the base IDMS product.

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.

 

Additional Information:

Details about how to execute the CA IDMS DB Audit product can be found in the CA IDMS/DB Audit User Guide which is included in the documentation set for IDMS. 

Additional details about the PRINT PAGE and FIX PAGE utility statements can be found in the CA IDMS Utilities Guide.