DB2 - Problem description
Problem IC66541 | Status: Closed |
"TOO MANY LOGS, NEED TO RECLAIM" IN STANDBY DB2DIAG.LOG FILE | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
After HADR tackover during the rollforward phase the below error is reported many times with different log numbers. ---------------------------------------------------------------- 2010-01-19-15.40.34.096153+000 I2410986A486 LEVEL: Error PID : 565572 TID : 7243 PROC : db2sysc INSTANCE: engine NODE : 000 DB : ARENA APPHDL : 0-4342 APPID: *LOCAL.DB2.091223194012 EDUID : 7243 EDUNAME: db2redom (ARENA) 0 FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:1086 DATA #1 : String, 79 bytes INFO ONLY: Too many logs, need to reclaim. Original head 51633, new head: 51637 2010-01-26-16.40.01.108491+000 I2445827A486 LEVEL: Error PID : 565572 TID : 7243 PROC : db2sysc INSTANCE: engine NODE : 000 DB : ARENA APPHDL : 0-4342 APPID: *LOCAL.DB2.091223194012 EDUID : 7243 EDUNAME: db2redom (ARENA) 0 FUNCTION: DB2 UDB, recovery manager, sqlpPRecProcLog, probe:1086 DATA #1 : String, 79 bytes INFO ONLY: Too many logs, need to reclaim. Original head 51732, new head: 51734 ---------------------------------------------------------------- | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 LUW V97 * **************************************************************** * PROBLEM DESCRIPTION: * * After HADR tackover during the rollforward phase the below * * error "TOO MANY LOGS, NEED TO RECLAIM"is reported many times * * with different log numbers. * **************************************************************** * RECOMMENDATION: * * The fix is going to include in the V97FP2. The fix will also * * include in future releases after V97FP2. The customer needs * * include this fix. * **************************************************************** | |
Local Fix: | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
The fix is going to include in the V97FP2. The fix will also include in future releases after V97FP2. After the fix when the HADR tackover during the rollforward phase the below error "TOO MANY LOGS, NEED TO RECLAIM" will not be seen many times . | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC66896 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 22.02.2010 22.06.2010 22.06.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |