DB2 FOR LUW / DB2FORLUW / 970 - DB2

During the backward stage of rollforward recovery - after either 
a system crash or during rollforward after a restore then DB2 
can repeatedly request the same two log files alternately.  This 
leads to the rollforward being extremely slow. 
In the db2diag.log the repeated requests for the same logs are 
recorded , eg : 
 
$ grep retrieve db2diag.log 
 
db2diag.log:MESSAGE : Started retrieve for log file 
S0000008.LOG. 
db2diag.log:MESSAGE : Completed retrieve for log file 
S0000008.LOG on chain 0 to 
db2diag.log:MESSAGE : Started retrieve for log file 
S0000009.LOG. 
db2diag.log:MESSAGE : Completed retrieve for log file 
S0000009.LOG on chain 0 to 
db2diag.log:MESSAGE : Started retrieve for log file 
S0000008.LOG. 
db2diag.log:MESSAGE : Completed retrieve for log file 
S0000008.LOG on chain 0 to 
etc 
 
 
The db2pd -recovery option will also show very slow bytes/second 
in backward 
phase of rollforward recovery. 
 
 
The problem is not platform specific.  The occurrence of the 
problem is chance dependent on whether a data buffer crosses two 
logfiles. 
The problem exists in the 9.5 and 9.7 codestreams.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* PRoblem Description: see Descripton above                    * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to Db2 V9.7 FP4 or later                             * 
****************************************************************

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

Problem is first fixed in Db2 V9.7 FP4

keiner bekannt / siehe Local-Fix

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

27.08.2010
18.05.2011
18.05.2011

9.7.FP4