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: For best results, use this process to check the DB2 catalog regularly, even outside of the migration process.
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.