DB2 FOR LUW / DB2FORLUW / 970 - DB2

DB2 rollforward might hang in backward phase with db2loggr 
thread showing the following stack trace: 
 
EDU name     : db2loggr (SAMPLE) 0 
EDU ID       : 5807 
 
<StackTrace> 
-------Frame------ ------Function + Offset------ 
0x09000000007EC570 _p_nsleep + 0x10 
0x090000000002B9C4 nsleep + 0xE4 
0x0900000000155808 nanosleep + 0x188 
0x090000002ADA15A0 ossSleep + 0x80 
0x090000002F5697D8 sqlorest + 0x5C 
0x090000002DB2E5BC sqlpgLoggrSleep__FP9SQLP_DBCBUl + 0xC0 
0x090000002DB301BC sqlpgadf__FP9SQLP_DBCBb + 0x36C 
0x090000002BDC387C sqlpgasn__FPcUi + 0x4B4 
0x090000002F4CC68C sqloEDUEntry + 0x1C 
</StackTrace> 
 
The problem could only happen when infinite logging is used and 
may require below conditions: 
1) there is some very large transaction to rollback 
2) frequent restore and rollforward.

**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 9.                       * 
****************************************************************

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 DB2 Version 9.7 Fix Pack 9.

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC95901 IC95902 IC95903 
Nachfolger : 

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

31.07.2013
17.12.2013
17.12.2013

9.7.FP9