Job DSNTIJUA: define data-only application defaults module

Job DSNTIJUA defines the Db2 data-only application defaults module.

Run this job when installing Db2 or migrating to Db2 12, and optionally to change the default SQL processing level (SQLLEVEL) for the precompiler/coprocessor after activating a new Db2 function level.

You run job DSNTIJUA as part of the following tasks:

You might also be directed by IBM® to run it when applying service to Db2.

In Db2 data sharing, each member of the group can use a single application defaults module or have its own. The Db2 installation and migration process assumes one module for the whole group and provides a DSNTIJUA job only for the first member.

The default SQL processing level (SQLLEVEL) for the precompiler/coprocessor can be changed anytime, such as after activating a higher Db2 function level. For more information, see PRECOMPILER SQL LEVEL field (SQLLEVEL DECP value).

Important: With the exception of SQLLEVEL, updates to application defaults parameters are generally not recommended. In general, you must restart Db2 for changes to any application programming parameters to take effect.

DSNTIJUA also contains a disabled job step, DSNTIMQ, that can be enabled to set up a GENASM entry in SMP/E for the Db2 application programming (DSNHDECM) macro. The GENASM entry causes service to DSNHDECM to trigger SMP/E to initiate a reassembly of the Db2 application defaults module. Advanced SMP/E skills are recommended for using GENASM entries. See the warnings in the comment block for job step DSNTIMQ before enabling it.

Adjustments to job DSNTIJUA

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.