IBM Support

IC78454: DB2PD REPORTS INCORRECT BUFFERPOOL INFO UNDER THE "UNRDPFETCH" (I.E. UNREAD PREFETCH PAGES").

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2pd reports incorrect bufferpool info under the "UnRdPFetch"
    (i.e. Unread prefetch pages").
    
    ERROR DESCRIPTION:
    
    db2pd reports the UnRdPFetch info as "No victim buffers
    available".
    
    For example,
    
    Here's the db2pd output -
    
    <snippet>
    
    BPID TotRdTime  TotWrtTime VectIORds  VectIOReq  BlockIORds
    BlockIOReq PhyPgMaps  FilesClose NoVictAvl  UnRdPFetch
    1    1422390052 26942193   322127539  5045963    0          0
          0          0          0          433428539
    2    410866628  9008646    77341291   2185063    0          0
          0          0          0          91730436
    3    107945951  14837661   0          0          0          0
          0          0          0          582943505
    
    Here's the corresponding snapshot output -
    
    <snippet>
    
    Asynchronous xda read requests             = 0
    No victim buffers available                = 433428539
    <<<<<<<<<
    Direct reads                               = 419342
    Direct writes                              = 5394
    Direct read requests                       = 200483
    Direct write requests                      = 804
    Direct reads elapsed time (ms)             = 33979
    Direct write elapsed time (ms)             = 1771
    Database files closed                      = 0
    
    Asynchronous xda read requests             = 0
    No victim buffers available                = 91730436
    <<<<<<<<
    Direct reads                               = 1536
    Direct writes                              = 0
    Direct read requests                       = 3
    Direct write requests                      = 0
    
    Asynchronous data read requests            = 0
    Asynchronous index read requests           = 535
    Asynchronous xda read requests             = 0
    No victim buffers available                = 582943505
    <<<<<<<<<
    Direct reads                               = 12800
    Direct writes                              = 520
    Direct read requests                       = 23
    

Local fix

  • Use snapshot monitor instead.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Without this APAR, customer is exposed to the issue as       *
    * described in the "ERROR DESCRIPTION" section.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7, Fixpack 6.                       *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7, Fixpack 6.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC78454

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-09-01

  • Closed date

    2012-07-18

  • Last modified date

    2012-07-18

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

    IZ89666

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

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC78454

Modified date: 18 July 2012