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

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

APAR status

• Closed as program error.

Error description

• 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
  

Local fix

• n/a
  

Problem summary

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

Problem conclusion

• First Fixed in DB2 LUW v9.5 Fixpack 5 and later.
  

Temporary fix

Comments

APAR Information

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

  IZ50325

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

Fix information

• Fixed component name

  DB2 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels

• R950 PSY

     UP