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

USING GLOBAL VARIABLES, CURSOR VARIABLES OR MODULES CAN CAUSE AN INFINITE
LOOP IN THE FUNCTION SQLRAERTFINDMEMBER.

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
The application would hang with sqlraERTFindMember on the top of 
the stack. For example: 
 
0x0900000023675994 
sqlraERTFindMember__FP8sqlrr_cb16sqlraERTCategoryPvPP14sqlraERTM 
ember 
+ 
 0xD0 
0x0900000023C08D68 sqlraERTInitModule__FP8sqlrr_cbPUcsT2T3 + 
0x64 
0x09000000236D715C 
sqlraERTInitModule__FP8sqlrr_cbPUcsT2T3@glue839 + 0x7C 
0x090000002100E5C8 sqlriInitModule__FP8sqlrr_cbP9sqlri_shd + 
0x4C 
0x09000000257FBFC8 
sqlriSectInitializeComplex__FP8sqlrr_cbP9sqlri_shdb + 0x334 
0x09000000257ACB9C sqlrr_process_execute_request__FP8sqlrr_cbi + 
0xD4 
0x09000000257ADA00 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo 
+ 0x1FC 
0x09000000227E3A98 executeSection__10pvmPackageFP5sqlcaUi + 0x78 
0x09000000227C99F4 executeQuery__3PVMFUi + 0xE0 
0x09000000227C8B04 run__3PVMFv + 0xAC 
0x09000000227C6754 pvm_entry + 0x464 <StackTrace> 
 
db2pd -alldbs -dmpert would enter an infinite loop and show a 
circle in the ERT linked list.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All platforms starting from v97 GA.                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* The application would hang with sqlraERTFindMember on the    * 
* top of the stack. For example:                               * 
*                                                              * 
* 0x0900000023675994                                           * 
* sqlraERTFindMember__FP8sqlrr_cb16sqlraERTCategoryPvPP14sqlraER 
* ember                                                        * 
* +                                                            * 
* 0xD0                                                         * 
* 0x0900000023C08D68 sqlraERTInitModule__FP8sqlrr_cbPUcsT2T3 + * 
*                                                              * 
* 0x64                                                         * 
* 0x09000000236D715C                                           * 
* sqlraERTInitModule__FP8sqlrr_cbPUcsT2T3@glue839 + 0x7C       * 
*                                                              * 
* 0x090000002100E5C8 sqlriInitModule__FP8sqlrr_cbP9sqlri_shd + * 
*                                                              * 
* 0x4C                                                         * 
* 0x09000000257FBFC8                                           * 
* sqlriSectInitializeComplex__FP8sqlrr_cbP9sqlri_shdb + 0x334  * 
*                                                              * 
* 0x09000000257ACB9C                                           * 
* sqlrr_process_execute_request__FP8sqlrr_cbi                  * 
* +0xD4                                                        * 
* 0x09000000257ADA00                                           * 
* sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo                 * 
* + 0x1FC                                                      * 
* 0x09000000227E3A98 executeSection__10pvmPackageFP5sqlcaUi +  * 
* 0x780x09000000227C99F4 executeQuery__3PVMFUi + 0xE0          * 
*    0x09000000227C8B04 run__3PVMFv + 0xAC                     * 
*   0x09000000227C6754 pvm_entry + 0x464 <StackTrace>          * 
*                                                              * 
* db2pd -alldbs -dmpert would enter an infinite loop and show  * 
* a  circle in the ERT linked list.                            * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 version 9.7 fixpack 1                         * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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 10 for Linux, UNIX, and Windows

Lösung
There's no workaround. Customer should upgrade to DB2 version 
9.7 fixpack 1
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
08.10.2009
15.01.2010
15.01.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP1
Problem behoben lt. FixList in der Version
9.7.0.1 FixList