This Db2 for z/OS News from the Lab blog entry was originally published on 2018-03-19.

By Bruce McAlister and Paul McWilliams.

Db2 for z/OS DBAs often spend effort to tailor job DSNTIJUZ to run only certain job steps for specific installation and migration activities, such updating subsystem parameters, application programming defaults, or DDF related information in the BSDS.

With APAR PI85657, DB2 12 for z/OS introduces several new jobs for various activities that were previously completed by the single DSNTIJUZ job:

DSNTIJUZ is the existing job. It now only assembles and links a subsystem parameter module (DSNZPxxx).

DSNTIJUA assembles and links a Db2 application defaults module (DSNHDECP).

DSNTIJUM assembles and links the Db2 offline message generator CCSSID module (DSNHMCID).

DSNTIJUL updates DDF related information in the BSDS. This job is for installation only, not for migration.

Before this APAR, the DSNTIJUZ job completes all of these activities, which often happen separately from the others, and sometimes only rarely. For example, updating the subsystem parameter module is a frequent task when new subsystem parameters are delivered in the service stream, or to update the default application compatibility (APPLCOMPAT) level, which is likely to become a more frequent activity with the introduction of continuous delivery and function levels in Db2 12. A similar activity is rebuilding the Db2 application defaults module, such as to change the default SQL processing level, another more frequent activity with continuous delivery. Whereas, rebuilding of the Db2 offline message generator CCSID module has never yet been required at migration, or for applying Db2 service.

Separating the actions of the DSNTIJUZ job into several jobs, enables you to choose a job for just the steps that you need for your specific activities, and frees you from the effort of tailoring the DSNTIJUZ job to remove or disable unneeded steps.

Bruce McAlister is a developer for Db2 for z/OS and Paul McWilliams is a technical writer for Db2 for z/OS.