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 IC72907 Status: Geschlossen

SMALL TIMING WINDOW WHERE PARALLEL RECOVERY (ROLLFORWARD OR CRAS H
RECOVERY) MAY HANG AFTER ALL LOG RECORDS HAVE BEEN PROCESSED.

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
Customer will see that crash recovery or rollforward is not 
making progress after it appears that all log records have been 
processed.  If you generate call stacks, you may see something 
similar to this. 
 
The redo master process is waiting : 
 
0x00002ACC32851DCD ossSleep + 0x0059 
                (/home/eunicec2/sqllib/lib64/libdb2osse.so.1) 
0x00002ACC2C4C770F sqlorest + 0x008f 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C832662 
_Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 
0x5de8 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C7FA31E _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca + 
0x0d54 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2A6F7AA1 _Z26sqleSubCoordProcessRequestP8sqeAgent + 
0x00f3 
 
and so is the redo worker : 
 
0x00002ACC2C59AAA3 sqloDumpDiagInfoHandler + 0x01bb 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC27BE3D60 address: 0x00002ACC27BE3D60 ; dladdress: 
0x00002ACC27BD6000 ; offset in lib: 0x000000000000DD60 ; 
                (/lib64/libpthread.so.0) 
0x00002ACC3325C25A semtimedop + 0x000a 
                (/lib64/libc.so.6) 
0x00002ACC2C47C5A6 _ZN13sqlo_waitlist11timeoutWaitEi + 0x018c 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C47B7A9 sqloWaitEDUWaitPost + 0x025b 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C836FA1 
_Z19sqlprWaitDuringPRecP8sqeAgentP16SQLO_EDUWAITPOST + 0x0095 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C83B30D _Z14sqlprFindQueueP8sqeAgentP9SQLP_DBCBmmPm + 
0x04dd 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1) 
0x00002ACC2C832E6B 
_Z15sqlpPRecProcLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb + 
0x02c7 
                (/home/eunicec2/sqllib/lib64/libdb2e.so.1)
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Customer will see that crash recovery or rollforward is not  * 
*                                                              * 
* making progress after it appears that all log records have   * 
* been                                                         * 
* processed.  If you generate call stacks, you may see         * 
* something                                                    * 
* similar to this.                                             * 
*                                                              * 
*                                                              * 
*                                                              * 
* The redo master process is waiting :                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* 0x00002ACC32851DCD ossSleep + 0x0059                         * 
*                                                              * 
*                                                              * 
* (/home/eunicec2/sqllib/lib64/libdb2osse.so.1)                * 
* 0x00002ACC2C4C770F sqlorest + 0x008f                         * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C832662                                           * 
*                                                              * 
* _Z15sqlpPRecReadLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb +   * 
*                                                              * 
* 0x5de8                                                       * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C7FA31E _Z20sqlpParallelRecoveryP8sqeAgentP5sqlca * 
* +                                                            * 
* 0x0d54                                                       * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2A6F7AA1 _Z26sqleSubCoordProcessRequestP8sqeAgent  * 
* +                                                            * 
* 0x00f3                                                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* and so is the redo worker :                                  * 
*                                                              * 
*                                                              * 
*                                                              * 
* 0x00002ACC2C59AAA3 sqloDumpDiagInfoHandler + 0x01bb          * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC27BE3D60 address: 0x00002ACC27BE3D60 ; dladdress:  * 
*                                                              * 
* 0x00002ACC27BD6000 ; offset in lib: 0x000000000000DD60 ;     * 
*                                                              * 
*                 (/lib64/libpthread.so.0)                     * 
*                                                              * 
* 0x00002ACC3325C25A semtimedop + 0x000a                       * 
*                                                              * 
*                 (/lib64/libc.so.6)                           * 
*                                                              * 
* 0x00002ACC2C47C5A6 _ZN13sqlo_waitlist11timeoutWaitEi +       * 
* 0x018c                                                       * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C47B7A9 sqloWaitEDUWaitPost + 0x025b              * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C836FA1                                           * 
*                                                              * 
* _Z19sqlprWaitDuringPRecP8sqeAgentP16SQLO_EDUWAITPOST +       * 
* 0x0095                                                       * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C83B30D                                           * 
* _Z14sqlprFindQueueP8sqeAgentP9SQLP_DBCBmmPm +                * 
* 0x04dd                                                       * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
*                                                              * 
* 0x00002ACC2C832E6B                                           * 
*                                                              * 
* _Z15sqlpPRecProcLogP8sqeAgentP8SQLP_ACBP14sqlpMasterDbcb +   * 
*                                                              * 
* 0x02c7                                                       * 
*                                                              * 
*                 (/home/eunicec2/sqllib/lib64/libdb2e.so.1)   * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Apply Version 9.5 fixpack 7                                  * 
****************************************************************
Local-Fix:
Kill DB2 and restart the recovery.  DB2 will continue from the 
previous point and will complete the recovery successfully.
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
Apply Version 9.5 fixpack 7
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IC74770 IC74771 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.11.2010
31.01.2011
31.01.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
9.5.FP7
Problem behoben lt. FixList in der Version
9.1.0.7 FixList
9.5.0.7 FixList