home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC95903 Status: Geschlossen

DB2 ROLLFORWARD MIGHT HANG IN BACKWARD PHASE WHEN INFINITE LOGGING IS USED

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
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-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Problem Description above.                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.5 Fix Pack 4.                      * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
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

Lösung
First fixed in DB2 Version 10.5 Fix Pack 4.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
12.09.2013
09.09.2014
09.09.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.4 FixList