PK67794: SYSPROC.GET_CONFIG DATA SHARING SUPPORT

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enhance the procedure SYSPROC.GET_CONFIG to support data
  sharing and XML input document.
  

Local fix

• No Work Around
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 UDB for z/OS V8 and DB2 9 for        *
  *                 z/OS users of the stored procedures          *
  *                 SYSPROC.ADMIN_COMMAND_DB2,                   *
  *                 SYSPROC.ADMIN_INFO_HOST,                     *
  *                 SYSPROC.GET_CONFIG,                          *
  *                 SYSPROC.GET_MESSAGE, and                     *
  *                 SYSPROC.GET_SYSTEM_INFO                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: This new function APAR ships function   *
  *                      enhancements for the stored procedures  *
  *                      SYSPROC.ADMIN_COMMAND_DB2 and           *
  *                      SYSPROC.GET_CONFIG; ships a new stored  *
  *                      procedure SYSPROC.ADMIN_INFO_SYSPARM;   *
  *                      and updates the stored procedures       *
  *                      SYSPROC.ADMIN_INFO_HOST,                *
  *                      SYSPROC.GET_MESSAGE and                 *
  *                      SYSPROC.GET_SYSTEM_INFO to support      *
  *                      the changes made to GET_CONFIG and      *
  *                      ADMIN_COMMAND_DB2.                      *
  ****************************************************************
  * RECOMMENDATION: Apply PTF                                    *
  ****************************************************************
  (1) The GET_CONFIG stored procedure is enhanced to accept an
      XML input document, and return IRLM parameters and
      configuration data for any or all members of the
      DB2 data sharing group to which the connected DB2
      subsystem belongs. The IRLM parameters returned are the
      ones found in IFCID 106 section 5.
  
      GET_CONFIG will now run in the security context of the
      stored procedure definer, and the definer must have, in
      addition to all the specific privileges needed to create the
      stored procedure and bind the DBRMs of the stored procedure,
      SYSOPR and MONITOR1 privileges. Since GET_CONFIG is now
      running in the context of the stored procedure definer,
      instead of the installation SYSADM id, the load module that
      executes the GET_CONFIG stored procedure, DSNADMGC, does not
      have to reside in an APF-authorized library anymore.
  
  (2) A new stored procedure, SYSPROC.ADMIN_INFO_SYSPARM, is
      added. This stored procedure returns, in a result table,
      the DB2 subsystem parameters, DSNHDECP values, and IRLM
      parameters of the connected DB2 subsystem or a member of
      the data sharing group to which the connected DB2
      subsystem belongs. The IRLM parameters returned are the
      ones found in IFCID 106 section 5.
  
  (3) The SYSPROC.ADMIN_COMMAND_DB2 stored procedure is enhanced
      to return the new information returned by the enhanced
      -DISPLAY DDF command shipped in APAR PK80474.
  
  (4) The SYSPROC.ADMIN_INFO_HOST, SYSPROC.GET_MESSAGE and
      SYSPROC.GET_SYSTEM_INFO stored procedures are modifed to
      support the changes made to ADMIN_COMMAND_DB2 and
      GET_CONFIG. The function of these three stored procedures
      is unchanged.
  
  In a data sharing group:
    If PK67794 is applied on one member of a data sharing group,
    a member in the same data sharing group on which PK67794 is
    not applied will experience the following problems:
      - If PK80474 is applied on this member, the stored
        procedure SYSPROC.ADMIN_COMMAND_DB2 will not return the
        DSNL090I message, which shows the DT, CONDBAT, and MDBAT
        fields, when it is called to issue the -DISPLAY DDF
        DETAIL command with the PARSE_TYPE DDF. The stored
        procedure SYSPROC.GET_CONFIG will return invalid values
        in the "DT - DDF Thread Value", "CONDBAT - Maximum
        Inbound Connections" and "MDBAT - Maximum Concurrent
        Active DBATs" fields under the "DB2 Distributed Access
        Information" entry.
  
  In a non-data sharing subsystem, if PK80474 is applied but not
  PK67794:
    - SYSPROC.ADMIN_COMMAND_DB2 will not return the parsed
      -DISPLAY DDF output when it is called to issue the
      -DISPLAY DDF command with PARSE_TYPE DDF. It will return
      an empty SYSIBM.DDF_CONFIG result set.
    - In the SYSPROC.GET_CONFIG output, the DDF fields under the
      "DB2 Distributed Access Information" entry which display
      the parsed DDF fields will have invalid values.
    - SYSPROC.ADMIN_INFO_HOST will return the following:
         RETURN_CODE: 12
         MSG: DSNA635I  DSNADMIH AN INTERNAL ERROR OCCURRED.
                        EMPTY RESULT SET TABLE SYSIBM.DDF_CONFIG
                        RECEIVED FROM SYSPROC.ADMIN_COMMAND_DB2
  

Problem conclusion

• (1) The stored procedure SYSPROC.GET_CONFIG is enhanced to
      support:
      - Data sharing
        Currently, GET_CONFIG only returns configuration
        information associated with the connected DB2 subsystem.
        With the addition of data sharing support, GET_CONFIG will
        be able to return configuration information associated
        with members of the DB2 data sharing group to which the
        connected DB2 subsystem belongs.
      - IRLM parameters
        Currently, GET_CONFIG returns the DB2 subsystem parameters
        and DSNHDECP values. With the enhancement, IRLM parameters
        listed in IFCID 106 section 5 will also be returned.
      - An XML input document
        To minimize processing and response time and to reduce
        network flow from the server to the client, GET_CONFIG
        will now accept an input XML document that will allow a
        user to:
          o Select or filter the information to be returned by
            GET_CONFIG
          o In a data sharing environment, select or limit the DB2
            members whose configuration data will be returned by
            GET_CONFIG
  (2) A new stored procedure, SYSPROC.ADMIN_INFO_SYSPARM, is
      added.
      SYSPROC.ADMIN_INFO_SYSPARM returns the system, DSNHDECP, and
      IRLM parameters of the connected DB2 subsystem or a member
      of the data sharing group to which the connected DB2
      subsystem belongs. Its function is the same as
      SYSPROC.DSNWZP, except that it will also return IRLM
      parameters, accept as input a DB2 member, and return the
      parameter settings in a result set. Only the IRLM
      parameters in IFCID 106 section 5 are returned.
  (3) The SYSPROC.ADMIN_COMMAND_DB2 stored procedure is enhanced
      to return the new information returned by the enhanced
      -DISPLAY DDF command shipped in APAR PK80474.
      The result table SYSIBM.DDF_CONFIG returned by the stored
      procedure ADMIN_COMMAND_DB2 is extended to include the
      following DDF-related information (where applicable):
          o Secure port
          o IP name
          o Alias List - Name, port, secure port
          o Member IPv4 and IPv6 addresses
      The new messages DSNL100I, DSNL101I, and DSNL102I are
      returned in the first result table SYSIBM.DB2_CMD_OUTPUT
      when ADMIN_COMMAND_DB2 is called to DISPLAY DDF.
  
  (4) The SYSPROC.ADMIN_INFO_HOST, SYSPROC.GET_MESSAGE, and
      SYSPROC.GET_SYSTEM_INFO stored procedures are modified
      to support the changes made to ADMIN_COMMAND_DB2 and
      GET_CONFIG. The function of these three stored procedures
      is unchanged.
  
  A summary of these enhancements, as they affect the DB2 manuals,
  is described in the flat file DSNDAMGC.
  

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:

  UK46487 UK46488

Modules/Macros

• DSN@DMCD DSN@DMCW DSN@DMGC DSN@DMGU DSN@DMGV
  DSN@DMGW DSN@DMIH DSN@DMIZ DSN@ZP   DSNADMCD DSNADMCH DSNADMCW
  DSNADMC8 DSNADMC9 DSNADMGC DSNADMGH DSNADMGJ DSNADMGM DSNADMGS
  DSNADMGU DSNADMGV DSNADMGW DSNADMIH DSNADMIZ DSNADMXO DSNDAMGC
  DSNDIFCA DSNDQWPZ DSNLTDDF DSNTIJSG DSNTINS1 DSNWZIF8 DSNWZIF9
  DSNWZP   HDB8810J HDB9910J
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• R810 PSY UK46487

     UP09/05/22 P F905

• R910 PSY UK46488

     UP09/05/22 P F905

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.