|
Problem IC63655
|
Status: Closed |
USING GLOBAL VARIABLES, CURSOR VARIABLES OR MODULES CAN CAUSE AN INFINITE LOOP IN THE FUNCTION SQLRAERTFINDMEMBER. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
There's no workaround. Customer should upgrade to DB2 version
9.7 fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 08.10.2009
15.01.2010
15.01.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
