Technote (troubleshooting)
Problem(Abstract)
Crash recovery fails with "Out of ResyncEntries!" error when processing indoubt transactions.
Symptom
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-19.36.27.916950-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!
Cause
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.