IBM Support

PI22091: NEW FUNCTION ON DB2 11 FOR Z/OS

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as new function.

Error description

  • New function on DB2 11 for z/OS.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All DB2 11 for z/OS users.                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Provide new function for users to       *
    *                      measure the benefit of increasing       *
    *                      the buffer pool size.                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    To aid users in determining the benefit of increasing
    buffer pool sizes, support for buffer pool simulation is
    introduced in this APAR.  The ALTER BUFFERPOOL command is
    enhanced with the SPSIZE and SPSEQT options to allow users
    to create a simulated buffer pool.  When a simulated buffer
    pool exists, pages that are stolen from the virtual buffer
    pool are tracked in the simulated buffer pool.  With the
    simulated buffer pool, DB2 determines whether a read I/O
    could have been avoided if the virtual buffer pool had the
    additional buffers in the simulated buffer pool.
    
    The number of read I/Os that could have been avoided, as
    determined by the simulated buffer pool, is displayed in a new
    DSNB432I message when the DISPLAY BUFFERPOOL command is
    issued.  There is also a new section for simulated buffer pool
    statistics in the IFCID 2 statistics record.
    
    Please see the HOLD DOC information in this APAR for more
    information about the messages added and modified by this APAR,
    the new options added to the ALTER BUFFERPOOL command, and
    the instrumentation changes.
    
    Additional search keywords:
    MSGDSNB404I MSGDSNB508I MSGDSNB522I MSGDSNB431I MSGDSNB432I
    MSGDSNB457I MSGDSNB547I MSGDSNB612I MSGDSNB613I MSGDSNB614I
    IFCID2      IFCID201    IFCID202
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    PI22091

  • Reported component name

    DB2 OS/390 & Z/

  • Reported component ID

    5740XYR00

  • Reported release

    B10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-07-15

  • Closed date

    2014-10-31

  • Last modified date

    2014-12-01

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

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

    UI22679

Modules/Macros

  • DSNBDMPS DSNB1ABP DSNB1ABS DSNB1AES DSNB1BEP
    DSNB1BSD DSNB1BVP DSNB1CBP DSNB1CHK DSNB1CLM DSNB1CMD DSNB1CPF
    DSNB1CPP DSNB1DBP DSNB1DEP DSNB1DVP DSNB1EEP DSNB1GEP DSNB1GET
    DSNB1GIO DSNB1GRA DSNB1GWB DSNB1LRR DSNB1MBR DSNB1OPP DSNB1OPS
    DSNB1PCK DSNB1PMI DSNB1PM2 DSNB1RLS DSNB1RRR DSNB1SPF DSNB1TSD
    DSNB1WLM DSNB1WRA DSNB5PGB DSNB5RAP DSNB5RDP DSNB5WCS DSNDQBSP
    DSNDQDBP DSNDQWST DSNDQWS1 DSNDQW03 DSNFBDIR DSNFCDIR DSNIIEPL
    DSNKLFPR DSNWDFSH DSNWVZD1 DSNWZDG2 DSNXIC01 DSNXOTL  DSNXOZAT
    DSN9SCNA HDBBB10J
    

Publications Referenced
SC19405400 SC19406000 GC19406200    

Fix information

  • Fixed component name

    DB2 OS/390 & Z/

  • Fixed component ID

    5740XYR00

Applicable component levels

  • RB10 PSY UI22679

       UP14/11/17 P F411

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: 11.0

Reference #: PI22091

Modified date: 01 December 2014