Installation and migration jobs that the CLIST tailors

The installation CLIST uses the values that you specify on the installation panels to tailor and load the installation or migration jobs. Each job is composed of one or more JCL procedures or job steps.

The CLIST loads each job as a separate member of the newly created prefix.NEW.SDSNSAMP.

Before you run any of these jobs, however, you might want to perform some editing that the CLIST does not do. If disk allocation is completely controlled by SMS for your installation, verify that the input to IDCAMS from the installation jobs does not conflict with the requirements for SMS.

The tailored jobs are described in the procedures for Installing Db2 13 and Migrating to Db2 13. Recovery information is provided, along with a description of each job. Unless otherwise stated in the job description, a return code of 0 or 4 from any of the jobs indicates successful completion. Some of the jobs contain statements that could fail without causing the job to fail. For instance, delete commands for data sets, drop statements for SQL objects, and stop commands could fail when you first run a job because the data sets or objects do not exist. Unless otherwise stated, you can ignore these failures. The statements are needed to allow you to rerun the job (if necessary) without performing the deletes, drops, and stops manually; they are merely for cleanup or initialization processing. If a job fails, follow the instructions that are provided in the recovery information for the job.

Which jobs you edit depends on the task that you are performing: installation, migration, or update. In data sharing environments, you edit different jobs depending on the data sharing function: group, member, or enable. The installation CLIST tailors a different set of jobs for each task.

Jobs for installing Db2 13

If you are installing Db2 13, the CLIST tailors the following jobs:

Jobs Jobs Jobs Jobs Jobs
  • DSNADMZW
  • DSNTEJ0
  • DSNTEJ1
  • DSNTEJ1L
  • DSNTEJ1P
  • DSNTEJ1S
  • DSNTEJ1T
  • DSNTEJ1U
  • DSNTEJ2A
  • DSNTEJ2C
  • DSNTEJ2D
  • DSNTEJ2E
  • DSNTEJ2F
  • DSNTEJ2H
  • DSNTEJ2P
  • DSNTEJ3C
  • DSNTEJ3M
  • DSNTEJ3P
  • DSNTEJ4C
  • DSNTEJ4P
  • DSNTEJ67
  • DSNTEJ6U
  • DSNTEJ7
  • DSNTEJ71
  • DSNTEJ73
  • DSNTEJ75
  • DSNTEJ76
  • DSNTEJ77
  • DSNTEJ78
  • DSNTESA
  • DSNTESC
  • DSNTESD
  • DSNTESE
  • DSNTESH
  • DSNTIJCA
  • DSNTIJDE
  • DSNTIJEX
  • DSNTIJIC
  • DSNTIJID
  • DSNTIJIE
  • DSNTIJIF
  • DSNTIJIN
  • DSNTIJMV
  • DSNTIJRT
  • DSNTIJRV
  • DSNTIJRW
  • DSNTIJSG
  • DSNTIJTC
  • DSNTIJTM
  • DSNTIJUZ
  • DSNTIJUA
  • DSNTIJUM
  • DSNTIJUL
  • DSNTIJVC

If you specified a default WLM environment name in the WLM ENVIRONMENT field of installation panel DSNTIPX, the CLIST edits DSNTEJ2U, DSNTEJ6O, DSNTEJ6R, DSNTEJ6V, and DSNTEJ6W.

If you activated DDF and specified a value in the REMOTE LOCATION field of panel DSNTIPY, the CLIST also tailors job DSNTEJ6.

If you activated DDF and specified a default WLM environment name in the WLM ENVIRONMENT field of installation panel DSNTIPX, the CLIST edits DSNTEJ6Z, DSNTEJ63, DSNTEJ64, DSNTEJ65, and DSNTEJ66.

If you activated DDF, specified a value in the REMOTE LOCATION field of panel DSNTIPY, and specified a default WLM environment name in the WLM ENVIRONMENT field of installation panel DSNTIPX, the CLIST edits DSNTEJ6D, DSNTEJ6P, DSNTEJ6S, DSNTEJ6T, DSNTEJ61, and DSNTEJ62.

If CICS® is selected, the CLIST edits DSNTEJ5A, DSNTEJ5C, and DSNTEJ5P.

If you are using data sharing, the CLIST edits DSNTIJGF and DSNTIJFT.

The installation CLIST tailors the DSNHC, DSNH, DSNU, and DSNEMC01 CLISTs for installation.

When SYSINSTL is specified on panel DSNTIPG, the installation CLIST performs the following additional changes:

  • All BIND statements specify the package owner as entered in the INSTALL PKG OWNER field.
  • All dynamic SQL streams begin with the SET CURRENT SQLID 'SYSINSTL' statement.
  • All CREATE TABLE and CREATE INDEX statements are stripped of the creator name and preceded (as a group) by a SET CURRENT SCHEMA statement to indicate the creator.
  • The following notice is added to the prolog of each affected job. Itemized statements are individually included or excluded, as applicable:
//* NOTICE: This job must be run by a user ID with DB2 Installation  
//*         System Operator authority because it has been customized 
//*         as follows for performing DB2 installation or migration  
//*         without DB2 System Administrator authority:              
//*         - Dynamic SQL processing is performed with the current   
//*           SQL ID set to SYSINSTL                                 
//*         - DSNTIAD runs with PLAN(DSNTIAIN)                       
//*         - Creator IDs are removed from create statements for     
//*           tables and indexes                                     
//*         - SET CURRENT SCHEMA statements are added to provide     
//*           the necessary creator IDs for these objects            
//*

Additional tailoring is performed on job DSNTIJTM for SYSINSTL. For example, the job prepares and binds DSNTIAD, a program for processing executable dynamic SQL statements. It uses a version-specific naming convention of DSNTIAnn, where nn is 12, 11, or 10, to bind a package and plan for DSNTIAD. When configured for SYSINSTL, job DSNTIJTM binds an additional DSNTIAD package and plan, both named DSNTIAIN. No access is granted on the DSNTIAIN package or plan.

Jobs for migrating to Db2 13

If you are migrating to Db2 13, the CLIST tailors the following jobs:

Jobs Jobs Jobs
  • DSNADMZW
  • DSNTEJxx1
  • DSNTESA1
  • DSNTESC1
  • DSNTESD1
  • DSNTESE1
  • DSNTESH1
  • DSNTIJCV
  • DSNTIJCX
  • DSNTIJEX
  • DSNTIJFV
  • DSNTIJIC
  • DSNTIJIN
  • DSNTIJMV
  • DSNTIJNH
  • DSNTIJPD
  • DSNTIJRT
  • DSNTIJRV
  • DSNTIJRW
  • DSNTIJSG
  • DSNTIJTC
  • DSNTIJTM
  • DSNTIJUZ
  • DSNTIJUA
  • DSNTIJUM
  • DSNTIJUL
  • DSNTIJVC

The installation CLIST tailors the DSNHC, DSNH, DSNU, and DSNEMC01 CLISTs for migration.

Important:
  1. The DSNTEJxx jobs are for use only after new function is activated.

Jobs for activating Db2 13 function levels

If you are activating function level 500 or higher, the CLIST tailors jobs DSNTIJTC and DSNTIJAF. Depending on the target function level, the CLIST might also tailor job DSNTIJA1 if the current function level is V13R1M100.

Jobs for updating a Db2 13 installation

If you are updating, the CLIST tailors any of the following jobs based on the values that you update:
  • DSNTIJUZ
  • DSNTIJUA
  • DSNTIJUM
  • DSNTIJUL