DB2 FOR LUW / DB2FORLUW / 970 - DB2

In a distributed unit of work (DUOW) environment, transactions 
which have been prepared but not yet committed are kept in a 
linked resync list. This list is used to recover from 
transaction commit or rollback failures due to network, 
hardware, or software failures. The resync list is stored in the 
resync heap with a fixed size, which is in the shared memory of 
the server. 
 
If there are a lot of outstanding DUOW transactions, DB2 
database server can run out of entries in Resync List during 
user activities or during crash recovery with the following 
message in db2diag.log: 
 
2011-09-23-15.08.39.785187-420 E1503306A441       LEVEL: Severe 
 
PID     : 758298               TID  : 110442      PROC : db2sysc 
0 
 
INSTANCE: test                NODE : 000         DB   : SAMPLE 
 
APPHDL  : 0-40210              APPID: 
 
USPCCW01.INA400.C86AD450D8A8 
 
AUTHID  : user 
 
EDUID   : 110442               EDUNAME: db2agent (SAMPLE) 0 
 
FUNCTION: DB2 UDB, base sys utilities, sqleAddEntryToResync, 
 
probe:20 
 
MESSAGE : Out of ResyncEntries! 
 
 
 
In case that crash recovery hits this symptom, crash recovery 
fails. In other cases, if APAR IC79235 has not been fixed yet, 
DB2 database server traps afterward, otherwise user's sql fails.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 7                        * 
****************************************************************

Increase NUMDB in DBM CFG, restart DB2 database server and 
restart database.

DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

First fixed in Version 9.7 Fix Pack 7

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC88637 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

20.10.2011
31.12.2012
31.12.2012

9.7.FP7