Configuration for Db2

Edit online

IBM® AD Connect for Mainframe supports all currently supported versions of Db2® for z/OS®. At the time of this publication, it includes the minimum supported version 11.1 and higher.

Previous versions of IBM AD Connect for Mainframe that allowed for the creation of DBRM-based plans on Db2 are no longer supported. You need to create the Db2 packages and a plan if you want to allow IBM AD Connect for Mainframe to gather Db2 operational information as part of your AD/ADDI project. For more information, perform the following steps:
Note:
  • Make sure to use the same package name to create the packages and plan. The package name appears in sample job IAYBNDPL under PKLIST. If you want to change the package name, update both sample jobs IAYBNDPK and IAYBNKPL.
  • The owner of the packages and plan must have the authority to run the BIND command on the specified PKLIST.
  • The name of the plan that is used to access Db2 from IBM AD Connect for Mainframe must be IAYSRC.
  1. Use sample job IAYBNDPK to create packages. Modify the sample according to your environment.
    Figure 1. Sample job IAYBNDPK
    //IAYBNDPK JOB <job parameters>   
//JOBLIB DD DSN=DSN1210.SDSNLOAD,DISP=SHR <=== DB2 Loadlib 
//BINDUNL EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT) 
//SYSTSPRT DD SYSOUT=* 
//SYSPRINT DD SYSOUT=* 
//SYSUDUMP DD SYSOUT=* 
//SYSTSIN DD *
DSN SYSTEM(DBCG) <==set owner (see all cases of owner in the job) 
  BIND PACKAGE (IAY60PKG) OWNER(userdefined) +  <== set owner (see all cases of owner in the job) 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2DB) LIBRARY('IAYV600.SIAYDBRM')  <== DBRM library (same goes for all appearance in job) 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2VL) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2TB) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2TS) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2PL) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2CL) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2SG) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2IX) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2KY) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2TG) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2VW) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2PK) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2PX) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
     MEMBER(IAYDB2RT) LIBRARY('IAYV600.SIAYDBRM') 
  BIND PACKAGE (IAY60PKG) OWNER(IBMUSER)                + 
     ACTION(REPLACE) ISOLATION(CS) ENCODING(EBCDIC)     + 
  MEMBER(IAYDB2PR) LIBRARY('IAYV600.SIAYDBRM') 
  END 
//
  2. Use sample job IAYBNDPL to create a plan. The plan must refer to the packages that are created in the previous step. Modify the sample according to your environment.
    Figure 2. Sample job IAYBNDPL
    //IAYBNDPL JOB <job parameters>  
//* 
//JOBLIB DD DSN=DSN1210.SDSNLOAD,DISP=SHR <== DB2 Loadlib 
//BINDUNL EXEC PGM=IKJEFT01,DYNAMNBR=20,COND=(4,LT) 
//SYSTSPRT DD SYSOUT=* 
//SYSPRINT DD SYSOUT=* 
//SYSUDUMP DD SYSOUT=* 
//SYSTSIN DD * 
 DSN SYSTEM(DBCG)  <=== DB2 Subsystem name 
 BIND PLAN(IAYSRC) OWNER(userdefined) + <== set owner (see all   cases of owner in the job) 
 ACTION(ADD) ISOLATION(CS) + 
 PKLIST(IAY60PKG.*) 
 END 
//SYSIN DD * 
GRANT EXECUTE ON PLAN IAYSRC TO PUBLIC; 
//* 
//