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

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:

(0 users)Average rating

Add comments

Document information


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

Translate my page

Machine Translation

Content navigation