Updating Db2 initialization parameters for function level activation

After you activate a function level, you can enable applications to begin using new capabilities by default by updating the APPLCOMPAT subsystem parameter and the SQLLEVEL value in the application defaults module.

About this task

Tip: Do not raise the default application compatibility level of the Db2 subsystem immediately after migrating or activating a new function level. Instead, wait until applications have been verified to work correctly at the higher function level, and any incompatibilities have been resolved. For details, see Enabling default application compatibility with function level 500 or higher.

Procedure

To update initialization parameters for function level activation, complete the following steps:

  1. Run job DSNTIJUZ.
    Job DSNTIJUZ defines the Db2 data-only subsystem parameter module (DSNZPxxx), which consists of the expansion of the following macros: DSN6ARVP, DSN6FAC, DSN6GRP, DSN6LOGP, DSN6SPRM, and DSN6SYSP.
    You might need to make the following adjustments before running the job:
    • If you added a STEPLIB DD statement to the Db2 start procedures ahead of prefix.SDSNEXIT and prefix.SDSNLOAD, you can move the SYSLMOD output to that library.
    Important: Start of changeIf the DSNTIJUZ job ends with return code 4, check that any warning messages can be safely ignored before continuing to the next step.End of change
    When DSNTIJUZ completes, the DSNTINST CLIST performs calculations by using the values that you specified for some of the parameter values that you entered on the panels. These calculations appear in the macro descriptions.

    For more information, see Job DSNTIJUZ: define the Db2 data-only subsystem parameter module.

  2. Run job DSNTIJUA.
    Job DSNTIJUA defines the Db2 data-only application defaults module.
    You might need to make the following adjustments before running the job:
    • If you added a STEPLIB DD statement to the Db2 start procedures ahead of prefix.SDSNEXIT and prefix.SDSNLOAD, you can move the SYSLMOD output to that library.

    For more information, see Job DSNTIJUA: define data-only application defaults module.