Run premigration queries (DSNTIJPM)

Before you migrate to Db2 13, run premigration queries on the Db2 12 catalog.

Start of change

Before you begin

Complete the premigration activities and activate function level 510 in Db2 12, as described in Verify Db2 13 premigration activities and activate function level 510 in Db2 12. The DSNTIJPE job that you ran for that task is functionally equivalent to the DSNTIJPM. However, depending on when you activated function level 510, it is possible that more release incompatibilities were added since.

Important: To identify native SQL routines that need to be regenerated for use in Db2 13, apply the PTF for APAR PH57086 before you run job DSNTIJPE in Db2 12 or DSNTIPM in Db2 13. See PH57086.
End of change

Procedure

To run premigration queries:

  1. Copy the updated job DSNTIJPM from Db2 13 to Db2 12.
  2. Customize job DSNTIJPM as described in the job prolog.
  3. Run job DSNTIJPM.

Results

Job DSNTIJPM generates reports about conditions that require action before or during the migration process. Such conditions include obsolete object formats, missing required objects, packages that must be rebound before migration, and dependencies that are affected by the migration process. For detailed information about the contents of the reports for migration to Db2 13, see the report descriptions in job DSNTIJPM.