IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

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 number

    PI78292

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-16

  • Closed date

    2017-05-15

  • Last modified date

    2017-07-05

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



Document information

More support for: DB2 for z/OS

Software version: B10

Reference #: PI78292

Modified date: 05 July 2017


Translate this page: