Crash recovery fails with "Out of ResyncEntries!" error when processing indoubt transactions
Crash recovery fails with "Out of ResyncEntries!" error when processing indoubt transactions.
Crash recovery fails during rollback phase when dealing with indoubt transactions and runs out of entries in Resync list with the following message:
2011-10-12-188.8.131.526950-420 E7663812A435 LEVEL: Severe
PID : 7078876 TID : 11567 PROC : db2sysc 0
INSTANCE: dwp01 NODE : 000 DB : DWP01
APPHDL : 0-98 APPID: *N0.dwp01.111013023616
AUTHID : DWP01
EDUID : 11567 EDUNAME: db2agent (DWP01) 0
FUNCTION: DB2 UDB, base sys utilities, sqleAddEntryToResync, probe:20
MESSAGE : Out of ResyncEntries!
The NUMDB database configuration parameter is used to compute the number of entries in the Resync list using the formula:
number of ResyncEntries = NUMDB * 25
The default value for NUMDB is 2 which offers 50 entries in the Resync list. This is usually sufficient to process all the indoubt transactions during crash recovery. However sometimes this is not sufficient and you will get the "Out of ResyncEntries!" error.
Resolving the problem
You may temporarily increase NUMDB database configuration parameter which will in turn increase the number of Resync entries. A good starting value NUMDB is 20. After crash recovery is complete you may may change NUMDB back to its original value of 2.
More support for:
DB2 for Linux, UNIX and Windows
Software version: 9.7, 10.1
Operating system(s): AIX, HP-UX, Linux, Solaris
Software edition: Enterprise Server
Reference #: 1615510
Modified date: 2012-11-28