Migration step 15: Tailor the Db2 13 catalog: DSNTIJTC

Job DSNTIJTC invokes the CATMAINT utility to migrate the Db2 12 catalog to the Db2 13 catalog, and its successful completion makes Db2 13 available for use. Start of changeNo Db2 catalog object changes are applied when you complete this task.End of change

Before you begin

Ensure that no incompatible applications will interfere with the catalog migration. For details, see Identify applications that are incompatible with online migration.

About this task

By completing this step, you migrate the Db2 catalog and make it available for use in Db2 13.

Tip: Start of changeNo structural changes are applied to Db2 catalog objects with the catalog updates in this task. The first updates to Db2 catalog objects for Db2 13 occur later, when you update the catalog for function level V13R1M501 or higher.End of change

When you start Db2 13 before you complete this step, Db2 returns various messages because the Db2 13 catalog is not yet available for use. Examples include the following messages and reason codes:

  • DSNT500I with reason code 00C900A6
  • DSNT501I with reason code 00C900A6
  • DSNL700I with reason code 00C900A6 (if DDF is auto-started). This message might be followed by messages DSNL007I and DSNL008I, indicating that DDF is terminating.
  • Abend 04E with reason code 00E70014 (during DDL registration)
You can determine the existing restrictions by issuing the command after you start Db2. (However, this command might also generate message DSNT501I with reason code 00C900A6.)
-DSN1 DISPLAY DATABASE(*) SPACENAM(*) RESTRICT

DSNTIJTC contains the following job steps:

DSNTITC
Start of change

Job step DSNTITC checks the eligibility of the catalog and then updates it to catalog level V13R1M100. (When you run DSNTIJTC at other times, this job step might create new catalog and directory objects, add columns to existing catalog tables, or create and update indexes on the catalog tables for new objects. However, no such changes occur for the initial catalog level at migration to Db2 13. Start of changeThe first updates to Db2 catalog objects occur later, when you update the catalog for function level V13R1M501 or higher.End of change)

Start of changeEnd of change

End of change
CHKTITC
Job step CHKTITC checks the return code of the CATMAINT utility. If the return code is 8 or greater, the job executes the job steps that follow CHKTITC.
DSNTIRI
Start of changeJob step DSNTIRI executes only when job step DSNTITC terminates abnormally or with a return code of 8 or greater. DSNTIRI rebuilds any catalog indexes that are currently in a REBUILD-pending status.End of change
DSNTITD
Job step DSNTITD executes only when job step DSNTITC terminates abnormally or with a return code of 8 or greater. DSNTITD issues the DISPLAY BLOCKERS command with the DETAIL option and displays information about locks or claims that might have interfered with the catalog migration.

Procedure

To complete the tailoring of the Db2 13 catalog:

  1. Run job DSNTIJTC on your Db2 13 subsystem.

    A status message, DSNU777I, is issued at several points to indicate migration progress. Diagnostic error messages are issued when CATMAINT processing fails. If a problem is found during the SQL processing phase of migration, message DSNU778I is issued. If non-supported functions are encountered, message DSNU776I is issued. All of these messages are written to the SYSPRINT data set.

    When the catalog update is complete, Db2 records the catalog level change in the SYSIBM.SYSLEVELUPDATES catalog table and issues message DSNG014I to the console.

  2. If job DSNTIJTC fails, save the output and correct the problem.
    1. Terminate the CATMAINT utility if it is pending.
    2. Run job DSNTIJTC again without modification.
  3. If you are unable to resolve the failure, return to Db2 12.
    To return to Db2 12, complete these steps:
    1. Rename procedures to use the libraries of your previous release.
    2. Reconnect TSO, IMS, and CICS® to the libraries of your previous release.
  4. When you remigrate to Db2 13, run the DSNTIJTC job again.

Results

Start of changeThe catalog is now tailored at catalog level V13R1M100, which supports Db2 13 function level 100.End of change

What to do next

  • If you received message DSNL700I with reason code 00C900A6 and DDF terminated after you started Db2 13 for the first time, start DDF manually after you run DSNTIJTC.
  • If the CATMAINT utility jobs from the previous step placed any altered Db2 catalog objects in REORG-pending (AREO*) advisory status, run the REORG utility for those objects.
  • After you tailor the Db2 13 catalog, check the integrity of your catalog and directory. For more information, see Ensure that the catalog has no problems (optional)