Migration step 19: Ensure that the catalog has no problems (optional)

After you tailor your Db2 13 for z/OS® catalog, you should check the integrity of your catalog and directory.

Procedure

To check the integrity of your catalog and directory, complete these steps in any order:

  • Run the CHECK INDEX utilities on all the indexes in the catalog and directory by using job DSNTIJCX.
  • Run the queries in member DSNTESQ of prefix.SDSNSAMP. Because SPUFI is not yet bound, you cannot use SPUFI to run these queries.
    One alternative is to use the Db2 12 DSNTEP2 program to run the queries.
  • Run the DSN1COPY utility with the CHECK option on the catalog table spaces.