|
Problem IC95902
|
Status: Closed |
DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
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. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to 10.5.0.3 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Solution |
Problem Fixed In 10.5.0.3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 12.09.2013
28.02.2014
28.02.2014 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
