PK72444: RETURN CATALOG ATTRIBUTES AND ICF CATALOG OF DB2 SUBSYSTEM DATA SETS GET_SYSTEM_INFO

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enhance the stored procedure SYSPROC.GET_SYSTEM_INFO to return
  Sysplex name, catalog attributes, ICF catalog of DB2 subsystem
  data sets for the DB2 directory and catalog databases, the
  default database, and the temporary database, ICF catalog of
  active and archive log data sets, and ICF catalog associated
  with each storage group in SYSIBM.SYSSTOGROUP
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 UDB for z/OS V8 and all              *
  *                 DB2 9 for z/OS users of the stored           *
  *                 procedures SYSPROC.GET_SYSTEM_INFO,          *
  *                 SYSPROC.GET_CONFIG, SYSPROC.GET_MESSAGE,     *
  *                 SYSPROC.ADMIN_DS_DELETE, and                 *
  *                 SYSPROC.ADMIN_DS_RENAME                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This new function APAR ships function   *
  *                      enhancements for the stored procedure   *
  *                      SYSPROC.GET_SYSTEM_INFO and updates     *
  *                      the stored procedures                   *
  *                      SYSPROC.GET_CONFIG, GET_MESSAGE,        *
  *                      SYSPROC.ADMIN_DS_DELETE and             *
  *                      SYSPROC.ADMIN_DS_RENAME to support      *
  *                      the enhancements made to                *
  *                      GET_SYSTEM_INFO and to enable version 8 *
  *                      of GET_CONFIG, GET_MESSAGE, and         *
  *                      GET_SYSTEM_INFO to execute in a         *
  *                      z/OS 1.3 system.                        *
  *                                                              *
  *                      The function of GET_CONFIG,             *
  *                      GET_MESSAGE, ADMIN_DS_DELETE, and       *
  *                      ADMIN_DS_RENAME are unchanged.          *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  (1) The stored procedure SYSPROC.GET_SYSTEM_INFO is enhanced to
      return the following information in the XML output document:
      - Catalog attributes
      - ICF catalog information about DB2 subsystem data sets for
        the DB2 directory and catalog databases
      - ICF catalog information about active and archive log data
        sets
      - ICF catalog information associated with each storage
        group in SYSIBM.SYSSTOGROUP
  (2) GET_SYSTEM_INFO will now run in the security context of the
      stored procedure definer.
  
      If GET_SYSTEM_INFO will be called to return the ICF catalog
      information about DB2 data sets, the definer must also have
      MONITOR1 and DISPLAY privileges.
  
      If GET_SYSTEM_INFO will be called to return catalog
      attributes or ICF catalog information about DB2 data sets,
      the definer must also have READ access to the RACF
      OPERCMDS resource named MVS.MCSOPER.DSNADMGS, if this is
      defined, or otherwise have READ access to the OPERCMDS
      resource named MVS.MCSOPER.*. This READ access is required
      for the stored procedure to execute the MVS command
      "F CATALOG,ALLOCATED" to retrieve catalog attributes.
  (3) The SYSPROC.ADMIN_DS_DELETE, SYSPROC.ADMIN_DS_RENAME,
      SYSPROC.GET_CONFIG (V9), and SYSPROC.GET_MESSAGE (V9)
      stored procedures are modified to support the changes
      made to GET_SYSTEM_INFO. The function of these four stored
      procedures is unchanged.
  (4) Currently in V8, GET_CONFIG, GET_MESSAGE and GET_SYSTEM_INFO
      do not execute successfully when they run on a z/OS 1.3
      system, because a non-zero return code is received from the
      Unicode Conversion Service CUNLCNV. The return code from
      CUNLCNV is 8, and the reason code is 3.
  

Problem conclusion

• (1) Currently, the stored procedure SYSPROC.GET_SYSTEM_INFO
      returns 5 different sets of information in its XML output
      document:
      - Operating System Information
      - Product Information
      - DB2 MEPL
      - Workload Manager (WLM) Classification Rules for
        DB2 Workload
      - SYSMOD Status
  
      GET_SYSTEM_INFO is enhanced to return the following
      additional information in its XML output document:
      - Catalog attributes
      - ICF catalog information about DB2 subsystem data sets for
        the DB2 directory and catalog databases
      - ICF catalog information about active and archive log data
        sets
      - ICF catalog information associated with each storage
        group in SYSIBM.SYSSTOGROUP
  (2) GET_SYSTEM_INFO is modified to run in the security context
      of the stored procedure definer.
  
      If GET_SYSTEM_INFO will be called to return the ICF catalog
      information about DB2 data sets, the definer must also have
      MONITOR1 and DISPLAY privileges.
  
      If GET_SYSTEM_INFO will be called to return catalog
      attributes or ICF catalog information about DB2 data sets,
      the definer must also have READ access to the RACF
      OPERCMDS resource named MVS.MCSOPER.DSNADMGS, if this is
      defined, or otherwise have READ access to the OPERCMDS
      resource named MVS.MCSOPER.*. This READ access is required
      for the stored procedure to execute the MVS command
      "F CATLOG,ALLOCATED" to retrieve catalog attributes.
  (3) The SYSPROC.ADMIN_DS_DELETE, SYSPROC.ADMIN_DS_RENAME,
      SYSPROC.GET_CONFIG (V9), and SYSPROC.GET_MESSAGE (V9)
      stored procedures are modified to support the changes
      made to GET_SYSTEM_INFO. The function of these four stored
      procedures is unchanged.
  
  Details of the GET_SYSTEM_INFO enhancements described above
  are described in the flat file DSNDAMGI.
  
  (4) To enable CUNLCNV to complete successfully in a z/OS
      V1.3 system, the CUNLCNV CUNBCPRM_Technique parameter is
      set to the value of "ER" in the module DSNADMGU (V8),
      which is common to GET_CONFIG, GET_MESSAGE, and
      GET_SYSTEM_INFO.
  
  
  Additional Search Keywords
    GET_SYSTEM_INFO, GET_CONFIG, GET_MESSAGE,  ADMIN_DS_DELETE,
    ADMIN_DS_RENAME
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK52834 UK52835

Modules/Macros

• DSN@DMGU DSN@DMGV DSNADMDE DSNADMDR DSNADMGH
  DSNADMGS DSNADMGU DSNADMGV DSNADMGX DSNADMGY DSNADMG1 DSNADMID
  DSNADMIO DSNDAMGI DSNDCCIA DSNTIJSG HDB8810J HDB9910J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK52834

     UP10/01/01 P F912

• R910 PSY UK52835

     UP10/01/01 P F912

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.