IBM Support

PI31554: SYSPROC.ADMIN_INFO_SYSPARM BEHAVES DIFFERENTLY ON THE SAME LPAR.THE OUTPUT IS INCONSISTENT DB2OVRLAY/K

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Stored proc SYSPROC.ADMIN_INFO_SYSPARM returns all ZPARM, HDECP
    and IRLM parameters. It returns 'ONLINE=N' as ADDITIONAL_INFO
    for the last IRLM parameter 'SYSTEM LOCK TABLE LIST ENTRIES'
    sometimes and sometimes has no data returned.
    The resultant output is inconsistent.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of the DB2-supplied stored         *
    *                 procedure SYSPROC.ADMIN_INFO_SYSPARM,        *
    *                 DB2 10 for z/OS and DB2 11 for z/OS,         *
    *                 are affected by this change.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: The ADDITIONAL_INFO column of the       *
    *                      last result set row returned by         *
    *                      ADMIN_INFO_SYSPARM is blank. The        *
    *                      keyword ONLINE= is missing from         *
    *                      this column.                            *
    ****************************************************************
    * RECOMMENDATION: APPLY PTF                                    *
    ****************************************************************
    The ADDITIONAL_INFO column of the last result set row is
    blank due to storage overlay. Currently, the procedure result
    set columns are not properly initialized which can result in
    storage overlay.
    

Problem conclusion

  • To address this problem, this APAR modifies ADMIN_INFO_SYSPARM
    to properly initialize storage for the procedure result set
    columns.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI31554

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-12-15

  • Closed date

    2015-01-26

  • Last modified date

    2015-03-03

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

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

    UI24725 UI24726

Modules/Macros

  • DSN@DMIZ DSNADMIZ
    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RA10 PSY UI24725

       UP15/02/25 P F502

  • RB10 PSY UI24726

       UP15/02/25 P F502

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.



Document information

More support for: DB2 for z/OS

Software version: 10.1

Reference #: PI31554

Modified date: 03 March 2015