|
Problem IC95822
|
Status: Geschlossen |
DB2 INSTANCE MIGHT TRAP IN SQMAGENTRTNSTACK::GETRTNCTXFORSND() WHILE CONSTRUCTING THE ROUTINE CONTEXT INFORMATION. |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problembeschreibung: |
If the MON_HEAP_SZ database level configuration parameter is
configured to a low value OR if the memory available in monitor
heap is not sufficient, routine monitoring infrastructure may
fail to allocate memory for statement nodes used for tracking
the statements executed by the routine. As a result, an agent
can trap inside getRtnCtxForSnd function while accessing the
statement nodes.
Callstack of trapping EDU might look like :
ossDumpStackTraceInternal
ossDumpStackTraceV98
OSSTrapFile::dumpEx
sqlo_trce
sqloEDUCodeTrapHandler
__invoke_dynamic_linker__
sqmAgentRtnStack::getRtnCtxForSnd
sqlkdDispatchRequest
sqlricrt
sqlriSectInvoke
sqlrr_process_fetch_request
sqlrr_open
sqluOpenCursor
sqluCrossInit
sqluvload
call_sqluvload
sqluLoadPartition
sqlu_register_table_load
sqluvtld_route_in
sqlesrvr
sqleMappingFnServer
sqlerKnownProcedure
sqlerCallDL
sqljs_ddm_excsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDrdaAsSPDriver
sqlerInvokeFencedRoutine
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
PVM::run
pvm_entry
sqloInvokeFnArgs
sqlriInvokerTrusted
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
PVM::run
pvm_entry
sqloInvokeFnArgs
sqlriInvokerTrusted
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
sqljs_ddm_excsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
sqeAgent::RunEDU
sqzEDUObj::EDUDriver
sqlzRunEDU
sqloEDUEntry
pthread_detach
clone |
| Problem-Zusammenfassung: |
If the MON_HEAP_SZ database level configuration parameter is
configured to a low value OR if the memory available in monitor
heap is not sufficient, routine monitoring infrastructure may
fail to allocate memory for statement nodes used for tracking
the statements executed by the routine. As a result, an agent
can trap inside getRtnCtxForSnd function while accessing the
statement nodes.
Callstack of trapping EDU might look like :
ossDumpStackTraceInternal
ossDumpStackTraceV98
OSSTrapFile::dumpEx
sqlo_trce
sqloEDUCodeTrapHandler
__invoke_dynamic_linker
sqmAgentRtnStack::getRtnCtxForSnd
sqlkdDispatchRequest
sqlricrt
sqlriSectInvoke
sqlrr_process_fetch_request
sqlrr_open
sqluOpenCursor
sqluCrossInit
sqluvload
call_sqluvload
sqluLoadPartition
sqlu_register_table_load
sqluvtld_route_in
sqlesrvr
sqleMappingFnServer
sqlerKnownProcedure
sqlerCallDL
sqljs_ddm_excsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDrdaAsSPDriver
sqlerInvokeFencedRoutine
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
PVM::run
pvm_entry
sqloInvokeFnArgs
sqlriInvokerTrusted
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
PVM::run
pvm_entry
sqloInvokeFnArgs
sqlriInvokerTrusted
sqlriInvokeInvoker
sqlricall
sqlriSectInvoke
sqlrr_process_execute_request
sqlrr_execute
sqljs_ddm_excsqlstt
sqljsParseRdbAccessed
sqljsParse
sqljsSqlam
sqljsDriveRequests
sqljsDrdaAsInnerDriver
sqljsDrdaAsDriver
sqeAgent::RunEDU
sqzEDUObj::EDUDriver
sqlzRunEDU
sqloEDUEntry
pthread_detach
clone |
| Local-Fix: |
Turn off routine metrics collection by setting MON_RTN_DATA db
cfg to NONE. |
| verfügbare FixPacks: |
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 10.5 Fix Pack 3. |
| Workaround |
Turn off routine metrics collection by setting MON_RTN_DATA db
cfg to NONE. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 09.09.2013
04.08.2014
04.08.2014 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.5.0.3
|
 |
| 10.5.0.3
|
|
