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

LOAD OPERATION MIGHT CRASH WITH A SPECIFIC STACK TRACE, BRING THE DB2
INSTANCE DOWN

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
A load operation might fail near the end of its operation in a 
specific way, and crash the DB2 instance.  This is a 
timing-dependent issue, and only affects DB2 9.7 Fixpack 5.  One 
or more of the load processes (EDU) have stack trace like this: 
 
... 
0x00002AAAADF2ABFB sqloEDUCodeTrapHandler + 0x027b 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAABD4C10 address: 0x00002AAAAABD4C10 ; dladdress: 
0x00002AAAAABC7000 ; offset in lib: 0x000000000000DC10 ; 
                (/lib64/libpthread.so.0) 
0x00002AAAAEDC57CC _ZN8SMemNode18findParentsPointerEPPS_ + 
0x001c 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAEDC94F2 _ZN17SqloChunkSubgroup14removeFromPoolEv + 
0x0032 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAEDC1EB0 sqlofmblkEx + 0x03d0 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAACCE8397 _Z17sqluLoadEDUDriverPhj + 0x01f7 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
0x00002AAAAC8CC101 sqloEDUEntry + 0x02a1 
                (/home/wallace1/sqllib/lib64/libdb2e.so.1) 
... 
 
 
All LOADs can potentially hit this problem, but this should be 
rarely hit.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All LOAD users running DB2 9.7 Fixpack 5                     * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A load operation might fail near the end of its operation in * 
* a                                                            * 
* specific way, and crash the DB2 instance.  This is a         * 
* timing-dependent issue, and only affects DB2 9.7 Fixpack 5.  * 
* One                                                          * 
* or more of the load processes (EDU) have stack trace like    * 
* this:                                                        * 
*                                                              * 
* ...                                                          * 
* 0x00002AAAADF2ABFB sqloEDUCodeTrapHandler + 0x027b           * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* 0x00002AAAAABD4C10 address: 0x00002AAAAABD4C10 ; dladdress:  * 
* 0x00002AAAAABC7000 ; offset in lib: 0x000000000000DC10 ;     * 
*                 (/lib64/libpthread.so.0)                     * 
* 0x00002AAAAEDC57CC _ZN8SMemNode18findParentsPointerEPPS_ +   * 
* 0x001c                                                       * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* 0x00002AAAAEDC94F2 _ZN17SqloChunkSubgroup14removeFromPoolEv  * 
* +                                                            * 
* 0x0032                                                       * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* 0x00002AAAAEDC1EB0 sqlofmblkEx + 0x03d0                      * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* 0x00002AAAACCE8397 _Z17sqluLoadEDUDriverPhj + 0x01f7         * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* 0x00002AAAAC8CC101 sqloEDUEntry + 0x02a1                     * 
*                 (/home/wallace1/sqllib/lib64/libdb2e.so.1)   * 
* ...                                                          * 
*                                                              * 
*                                                              * 
* All LOADs can potentially hit this problem, but this should  * 
* be rarely hit.                                               * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 9.7 Fix Pack 6.                       * 
****************************************************************
Local-Fix:
Not available.
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
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

Lösung
Problem was first fixed in DB2 Version 9.7 Fix Pack 6.  At a 
minimum, this fix should be applied on the server.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
24.02.2012
05.06.2012
05.06.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP6
Problem behoben lt. FixList in der Version
9.7.0.6 FixList