What is the required sequence of datasets in the STEPLIB and the PTILIB DD concatenation for batch job executions for the Database Management Solutions for DB2 for z/OS tools

Products

• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

The STEPLIB and PTILIB DD statements designate the datasets required for executing the Database Management for Db2 for z/OS tools in a batch environment.
If they are not concatenated in the correct sequence results could be unpredictable and difficult to debug.

Resolution

The load libraries must be concatenated in a specific sequence in order for the tools to find the correct load modules. The LOADLIB containing the CA DB2 Tools must be the first library in the concatenation for both the STEPLIB and PTILIB. It should be followed by the DB2 SDSNEXIT and then by the SDSNLOAD libraries.

The Database Management CDBALOAD is specified in the highlvl.CDBAPARM(DSNAMESxx) member.

The Db2 LOADLIBS are specified in the highlvl.CDBAPARM(SETUPxx). Each subsystem has a LOADLIBS parm that specifies the Db2 load libraries for this subsystem.
The Db2 DSNEXIT library should be the first data set listed with the SDSNLOAD library next.


An example would be:

//STEPLIB  DD  DISP=SHR,DSN=cahighlvl.LOADLIB                      -CA LOADLIB
//         DD  DISP=SHR,DSN=db2highlvl.SDSNEXIT                    -DB2           
//         DD  DISP=SHR,DSN=db2highlvl.SDSNLOAD                    -DB2           
//PTILIB   DD  DISP=SHR,DSN=cahighlvl.LOADLIB                      -CA LOADLIB
//         DD  DISP=SHR,DSN=db2highlvl.SDSNEXIT                    -DB2           
//         DD  DISP=SHR,DSN=db2highlvl.SDSNLOAD                    -DB2