PK67794: SYSPROC.GET_CONFIG DATA SHARING SUPPORT

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PK67794

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / CST

  • Submitted date

    2008-06-18

  • Closed date

    2009-05-12

  • Last modified date

    2009-06-10

  • 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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for z/OS

Software version:

8.0

Reference #:

PK67794

Modified date:

2009-06-10

Translate my page

Machine Translation

Content navigation