|
Problem IC64093
|
Status: Closed |
Instance crash due to stack overflow during query execution of a query with LOB locators and parameter markers. |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Instance can crash if LOB columns are involved and application
is using more then 4400 locators for the same parameter marker.
The stack traceback file created for the crash in the db2dump
directory will show thousands of calls to the function
sqlrimso, for example:
....
0x00002B086E2B41DF _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2b3b
0x00002B086E2B4006 _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2962
0x00002B086E2B4006 _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2962
0x00002B086E2B4006 _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2962
0x00002B086E2B4006 _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2962
0x00002B086E2B4006 _Z8sqlrimsoP8sqlrr_cbP9sqllf_csoPhPjjisPPvi
+0x2962
.......
db2diag.log will have stack overflow message:
MESSAGE : ADM0502C The DB2 instance has terminated
abnormally. To remedy this
problem, increase the AGENT_STACK_SZ DBM
configuration parameter.
Contact IBM Support for further assistance. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* SQL using more then 4400 locators for the same *
* parametermarker. *
****************************************************************
* PROBLEM DESCRIPTION: *
* Instance crash due to stack overflow during query *
* executionof aquery with LOB locators and parameter markers. *
****************************************************************
* RECOMMENDATION: *
* change application or install this fix. *
**************************************************************** |
| Local Fix: |
increase dbm cfg parameter AGENT_STACK_SZ and recycle the
instance or rewrite application to decrease the number of lob
locators used. |
| available fix packs: |
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 6 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 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 |
Instance crash due to stack overflow during query execution of a
query with LOB locators and parameter markers. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 22.10.2009
31.05.2010
31.05.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.2
|
 |
