PI78292: EXECUTE -DISPLAY BUFFERPOOL DETAIL(INTERVAL) ONLY ONCE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ADMIN_COMMAND_DB2 should execute -DISPLAY BUFFERPOOL
  DETAIL(INTERVAL) only once to avoid stats from being reset
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All DB2 10 for z/OS and DB2 11 for z/OS      *
  *                 users of the DB2-supplied stored procedure   *
  *                 SYSPROC.ADMIN_COMMAND_DB2                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: ADMIN_COMMAND_DB2 may return buffer     *
  *                      pool interval statistics that do        *
  *                      not match the period specified.         *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF                                    *
  ****************************************************************
  ADMIN_COMMAND_DB2 issues the -DISPLAY BUFFERPOOL command
  twice if the command responses from the first command
  invocation do not fit the initial IFI return area.
  In this case, if the DETAIL(INTERVAL), DETAIL() or DETAIL
  option is specified, the first command invocation causes
  the buffer pool interval statistics to be reset, resulting
  in incorrect interval statistics returned after the second
  command invocation.
  

Problem conclusion

• In response to the problem described, ADMIN_COMMAND_DB2
  is modified to issue the -DISPLAY BUFFERPOOL command
  only once if any one of these options is specified:
    o DETAIL(INTERVAL)
    o DETAIL()
    o DETAIL
  and to use a bigger IFI return area (with a size of 921,600)
  when it submits this command to IFI. If the bigger IFI
  return area is still not big enough to contain the entire
  command output, ADMIN_COMMAND_DB2 sets the procedure output
  parameters IFCA_RET, IFCA_RES and XS_BYTES to the
  corresponding IFCARC1, IFCARC2 and IFCABNM values returned
  by IFI, and returns the incomplete command response.
  For the DETAIL(*) option, behavior remains unchanged.
  

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:

  PI78369 UI47256 UI47257

Modules/Macros

• DSN@DMCD DSNADMCD
  

Fix information

• Fixed component name

  DB2 OS/390 & Z/

• Fixed component ID

  5740XYR00

Applicable component levels

• RA10 PSY UI47256

     UP17/06/02 P F706

• RB10 PSY UI47257

     UP17/06/02 P F706

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.