Migration step 4: Check for consistency between catalog tables (optional)

The DSNTESQ queries check the logical correctness of the DB2® catalog.

Before you begin

Before you run these queries, complete Migration step 2: Verify the integrity of DB2 table spaces to run the DSN1CHKR utility, the CHECK INDEX utility, and the DSN1COPY utility with the CHECK option.

About this task

Tip: Start of changeFor best results, use this process to check the DB2 catalog regularly, even outside of the migration process.End of change

Procedure

To check for consistency between catalog tables:

Run the queries that are not commented out in member DSNTESQ of the prefix.SDSNSAMP library. You can execute the SQL statements in DSNTESQ from SPUFI or from a dynamic SQL program like DSNTEP2.

You can run the queries on the actual catalog tables or on "mirror" copies of the catalog tables. If you run the queries on the copies, use the comment lines in member DSNTESQ for guidance. By running queries on copies of the catalog table, you reduce contention on the catalog.