DB2 FOR LUW / DB2FORLUW / 970 - DB2

Reaching this point does not mean a code problem. Instead, 
this is a warning indicating that despite our earlier 
aggressive attempts to flush the bufferpool several times 
in a row we have failed to move up MinBuffLSN, which means 
that there must be an application holding up this hot 
dirty page for a longer period of time. There is nothing 
we can do about this; the application holding up the page 
should be investigated. We will produce some extended 
diagnostic information here. 
 
db2diag.log sample: 
 
2009-05-05-19.58.56.871940-240 E90316E711         LEVEL: Warning 
PID     : 12009                TID  : 183045175872PROC : 
db2agent (SAMPLE) 
INSTANCE: db2inst1             NODE : 000         DB   : RAWDB 
APPHDL  : 0-11                 APPID: *LOCAL.psustr.090505235827 
AUTHID  : PSUSTR 
FUNCTION: DB2 UDB, data protection services, sqlpgResSpace, 
probe:1270 
MESSAGE : ZRC=0x00020173=131443=SQLB_FIXP "Page fixed during 
hard check point." 
DATA #1 : <preformatted> 
LSNs are: 
 copyLowTran    : 0000000003F3B5D6 
 copyMinBuff    : 0000000003EDA3CE 
 savedCurMinBuff: 0000000003EDA3CE 
 flushlsn       : 0000000003EE3FFB 
After flushing buffer pool: 
 curMinBuff     : 0000000003EDF3E6 
 copyNextLsn    : 0000000003F63F36

ENHANCE DIAGNOSTIC INFORMATION WHEN AGRESSIVELY FLUSHING PAGES 
FLUSHING LOGIC IS INVOKED.

n/a

DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 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 9a 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 10 for Linux, UNIX, and Windows
 

First Fixed in DB2 LUW v9.7 Fixpack 1 and later.

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

22.10.2009
15.12.2009
15.12.2009

9.7.FP1