|
Problem IC62911
|
Status: Geschlossen |
Instance crash due to stack overflow during query execution of a query with LOB locators and parameter markers. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
****************************************************************
* 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 DB2 9.5 FP6a or higher. *
**************************************************************** |
| Local-Fix: |
increase dbm cfg parameter AGENT_STACK_SZ and recycle the
instance or rewrite application to decrease the number of lob
locators used. |
| verfügbare FixPacks: |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
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 |
Problem First Fixed in DB2 Version 9.5 Fix Pack 6a |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Bug-Verfolgung |
Vorgänger : APAR is sysrouted TO one or more of the following: IC64093
Nachfolger : |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 01.09.2009
14.05.2010
06.08.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.5.FP6
|
| Problem behoben lt. FixList in der Version |
