Run premigration queries (DSNTIJPE)

Before you migrate to Db2 13, run premigration queries on the Db2 12 catalog. The goal is to check for any release incompatibilities introduced after the activation of function level 510 in Db2 12.

Start of change

Before you begin

End of change

About this task

Job DSNTIJPE 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 DSNTIJPE.

Tip: The DSNTIJPE job in Db2 12 is functionally equivalent to the DSNTIJPM job that is provided with Db2 13. An alternative approach to completing this task is to copy the DSNTIJPM job from Db2 13 to Db2 12 and then run the copied DSNTIJPM job instead.

Procedure

To run the premigration queries:

  1. Run the DSNTIJPE job. You can use the same DSNTIJPE that was run before function level 510. was activated.
  2. Verify the job output, and make plans to resolve any conditions that are identified in the generated reports.