Verifying your Db2 12 system in V12R1M100 (optional)

Verify your Db2 12 system by running some of the sample jobs from the previous release.

About this task

If all of the local Db2 objects from Db2 11 still exist (that is, if you have not run job DSNTEJ0), follow this procedure.

Procedure

Start of changeTo verify the migration of IVP objects in your Db2 12 system:End of change

  1. Change the JOBLIB statements to point to prefix.SDSNLOAD.
  2. Ensure that the DSN8EAE1 module that you created when you originally ran the Db2 11 sample jobs is copied to prefix.SDSNEXIT. DSN8EAE1 is an EDITPROC that is used by the employee sample table.
  3. Edit the Db2 11 sample jobs before running them. Do not run all the sample jobs. Run only the specific jobs and job steps that are listed in the following steps.
  4. Test the migration of the IVP phase 2 applications from your previous version:
    1. DSNTEJ2A: Perform all except the first two steps of job DSNTEJ2A. Expect a return code of 4 because table spaces DSN8D11U.NEWDEPT and DSN8D11U.NEWPHONE are placed in COPY-pending states.
    2. DSNTEJ2C: Issue only the RUN PROGRAM(DSN8BC3) PLAN(DSN8BH11) statement in step PH02CS04.
    3. DSNTEJ2D: Issue only the RUN PROGRAM(DSN8BD3) PLAN(DSN8BD11) statement in step PH02DS03.
    4. DSNTEJ2E: Issue only the RUN PROGRAM(DSN8BE3) PLAN(DSN8BE11) statement in step PH02ES04.
    5. DSNTEJ2F: Issue only the RUN PROGRAM(DSN8BF3) PLAN(DSN8BF11) statement in step PH02FS03.
    6. DSNTEJ2P: Run only step PH02PS05.
  5. Test the migration of the IVP phase 3 applications from your previous version:
    1. Do not run job DSNTEJ3C or DSNTEJ3P.
    2. If you want to test the Db2 11 ISPF-CAF applications under Db2 12, place the Db2 11 SDSNSPFP panel library ahead of the Db2 12 SDSNSPFP panel library in the ISPPLIB concatenation.
      This placement is necessary so that the plans that are migrated from Db2 11 can be used. Remove the Db2 11 SDSNSPFP library from your ISPPLIB concatenation when you are finished testing the Db2 11 IVP applications under Db2 12.

What to do next

Do not run any other Db2 11 sample jobs.