IBM Support

Crash recovery fails with "Out of ResyncEntries!" error when processing indoubt transactions

Technote (troubleshooting)


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- E7663812A435 LEVEL: Severe
PID : 7078876 TID : 11567 PROC : db2sysc 0
INSTANCE: dwp01 NODE : 000 DB : DWP01
APPHDL : 0-98 APPID: *N0.dwp01.111013023616
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.

Document information

More support for: DB2 for Linux, UNIX and Windows
OTHER - Uncategorised

Software version: 9.7, 10.1

Operating system(s): AIX, HP-UX, Linux, Solaris

Software edition: Enterprise Server

Reference #: 1615510

Modified date: 22 March 2016