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

Obtain the fix for this APAR.

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