Db2 customization

The following customization is required for all Db2® systems where discovery is run:
  • z/OS® DLA uses the DSNREXX DB2® REXX interface to issue SQL commands from REXX. The DSNREXX interface must be bound to each Db2 subsystem where discovery is required. See IBM Db2 12 for z/OS Installation and Migration Guide for more information about how to bind the packages for DB2 REXX language support.
  • The z/OS DLA user ID must have authority to issue the following DB2 DISPLAY commands:
    • DISPLAY GROUP
    • DISPLAY DDF
    • DISPLAY DB
  • The z/OS DLA user ID must also have the authority to read the following SYSIBM tables:
    • SYSIBM.SYSDATABASE
    • SYSIBM.SYSTABLES
    • SYSIBM.SYSTABLESPACE
    • SYSIBM.SYSINDEXES
    • SYSIBM.SYSCOLUMNS
    The sample JCL IZDJGRANT is included in the SIZDSAMP library to assist in granting these authorities to the z/OS DLA user ID. For more information on granting command and table authority, see the IBM Db2 12 for z/OS Administration Guide.
  • If multiple versions of Db2 are installed on the operating system, a STEPLIB (or LINKLST entry) for the SDSNLOAD data set matching the Db2 version of the discovery target must be supplied. Order the SDSNLOAD library data sets in the STEPLIB/LINKLST concatenation from the latest level (first) to the earliest level (last).