DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

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

Use snapshot monitor instead.

DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in DB2 Version 9.7, Fixpack 6.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

01.09.2011
18.07.2012
18.07.2012

9.7.FP6