Run premigration queries (DSNTIJPC)

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

About this task

Job DSNTIJPC 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 12, see the report descriptions in job DSNTIJPC.

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

Procedure

To run the premigration queries:

  1. Run the DSNTIJPC job.
  2. Verify the job output, and make plans to resolve any conditions that are identified in the generated reports.