Home

Neueste Versionen	FixList
11.1.0.7
10.5.0.9
10.1.0.6
9.8.0.5
9.7.0.11
9.5.0.10
9.1.0.12

Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren
Kontaktformular

DB2 - Problembeschreibung

Problem IC69690	Status: Geschlossen
CRASHED INVOLVING NESTED FUNCTION CALLS AND PL/SQL CODE IN SQLRIINVOKERTRUSTED
Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Signal 11 can occuring with nested function calls that include pl/sql code. <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000056F10E0 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 0xA4 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4 0x0900000004D05EB4 sqlriInvokeInvoker__FP10sqlri_ufobb@glueFD8 + 0x78 0x090000000506CFEC sqlri_close_udf_ufob_cleanup__FP10sqlri_ufobP5sqlcaP8sqlrr_cb + 0x30C 0x09000000054949E8 sqlri_close_udf_eos__FP25sqlra_sql_context_siblingiP8sqlrr_cb + 0x13C 0x0900000005493F8C sqlricls_simple__FP8sqlrr_cbil + 0x634 0x09000000054943DC @148@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_siblin giN63 + 0xEC 0x090000000808C244 sqlrr_process_close_request__FP8sqlrr_cbiN32 + 0x8DC 0x09000000054F0EA8 sqlrr_close__FP14db2UCinterfaceP15db2UCCursorInfo + 0x3F0 0x0900000008404DC0 csmDriveClose__FP14db2UCinterfaceP9db2UC_CCBUlT3 + 0x108 0x09000000069AFAC4 csmCursorBlaster__FP14db2UCinterfaceUiT2PUiN22 + 0x784 0x09000000083E9CC8 run__3PVMFv + 0x5F4 0x09000000083E7F30 pvm_entry + 0x460 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 0x090000000587FA94 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x1D0 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 0x0900000005475548 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x588 0x090000000548C19C sqlrr_process_execute_request__FP8sqlrr_cbi + 0xC7C 0x090000000548C414 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x1C4 0x0900000008400B98 executeSection__10pvmPackageFP5sqlcaUi + 0x7DC 0x09000000083EB23C executeQuery__3PVMFUi + 0xE0 0x09000000083EA3BC run__3PVMFv + 0xCE8 0x09000000083E7F30 pvm_entry + 0x460 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 0x090000000587FA94 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x1D0 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + 0x6E4 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 0x0900000005475548 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + 0x588 0x09000000054CAC50 sqlrr_process_fetch_request__FP14db2UCinterface + 0x1E8 0x09000000052E6CFC sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x110 0x09000000054B94C8 sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0xBE8 0x09000000054BA53C sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface + 0x98 0x09000000054BA32C .sqljsParse.fdpr.clone.624__FP13sqljsDrdaAsCbP14db2UCinterface + 0x330 0x09000000054B6F48 @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x3CC 0x090000000566C128 @64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 0x090000000566BF70 @64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2B0 0x090000000566B604 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0xFC 0x090000000560EA10 RunEDU__8sqeAgentFv + 0x80 0x0900000005615AA0 EDUDriver__9sqzEDUObjFv + 0xE4 0x0900000005609474 sqloEDUEntry + 0x264 </StackTrace>
Problem-Zusammenfassung:
**************************************************************** * USERS AFFECTED: * * All v97 * **************************************************************** * PROBLEM DESCRIPTION: * * Signal 11 can occuring with nested function calls that * * include * * pl/sql code. * * * * * * * * <StackTrace> * * * * -------Frame------ ------Function + Offset------ * * * * 0x09000000056F10E0 * * * * sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf * * + * * 0xA4 * * * * 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + * * 0x6E4 * * 0x0900000004D05EB4 * * sqlriInvokeInvoker__FP10sqlri_ufobb@glueFD8 + * * 0x78 * * * * 0x090000000506CFEC * * * * sqlri_close_udf_ufob_cleanup__FP10sqlri_ufobP5sqlcaP8sqlrr_cb * + * * 0x30C * * * * 0x09000000054949E8 * * * * sqlri_close_udf_eos__FP25sqlra_sql_context_siblingiP8sqlrr_cb * + * * 0x13C * * * * 0x0900000005493F8C sqlricls_simple__FP8sqlrr_cbil + 0x634 * * * * 0x09000000054943DC * * * * @148@sqlra_close_section__FP8sqlrr_cbP25sqlra_sql_context_sibl * * * giN63 * * * * + 0xEC * * * * 0x090000000808C244 * * sqlrr_process_close_request__FP8sqlrr_cbiN32 * * + 0x8DC * * * * 0x09000000054F0EA8 * * * * sqlrr_close__FP14db2UCinterfaceP15db2UCCursorInfo + 0x3F0 * * * * 0x0900000008404DC0 * * * * csmDriveClose__FP14db2UCinterfaceP9db2UC_CCBUlT3 + 0x108 * * * * 0x09000000069AFAC4 * * * * csmCursorBlaster__FP14db2UCinterfaceUiT2PUiN22 + 0x784 * * * * 0x09000000083E9CC8 run__3PVMFv + 0x5F4 * * * * 0x09000000083E7F30 pvm_entry + 0x460 * * * * 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC * * * * 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 * * * * 0x090000000587FA94 * * * * sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf * * + * * 0x1D0 * * * * 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + * * 0x6E4 * * 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 * * * * 0x0900000005475548 * * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + * * 0x588 * * * * 0x090000000548C19C * * sqlrr_process_execute_request__FP8sqlrr_cbi + * * 0xC7C * * * * 0x090000000548C414 * * sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo * * + 0x1C4 * * * * 0x0900000008400B98 executeSection__10pvmPackageFP5sqlcaUi + * * * * 0x7DC * * * * 0x09000000083EB23C executeQuery__3PVMFUi + 0xE0 * * * * 0x09000000083EA3BC run__3PVMFv + 0xCE8 * * * * 0x09000000083E7F30 pvm_entry + 0x460 * * * * 0x09000000054F3E44 sqloInvokeFnArgs + 0xBC * * * * 0x09000000064CFE24 sqloInvokeFnArgs@glue497 + 0x78 * * * * 0x090000000587FA94 * * * * sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf * * + * * 0x1D0 * * * * 0x09000000054F89FC sqlriInvokeInvoker__FP10sqlri_ufobb + * * 0x6E4 * * 0x0900000008957650 sqlriusf__FP8sqlrr_cb + 0x264 * * * * 0x0900000005475548 * * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm + * * 0x588 * * * * 0x09000000054CAC50 * * * * sqlrr_process_fetch_request__FP14db2UCinterface + 0x1E8 * * * * 0x09000000052E6CFC * * * * sqlrr_open__FP14db2UCinterfaceP15db2UCCursorInfo + 0x110 * * * * 0x09000000054B94C8 * * * * sqljs_ddm_opnqry__FP14db2UCinterfaceP13sqljDDMObject + 0xBE8 * * * * 0x09000000054BA53C * * * * sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2 * * * interface * * * * + 0x98 * * * * 0x09000000054BA32C * * * * .sqljsParse.fdpr.clone.624__FP13sqljsDrdaAsCbP14db2UCinterface * + * * 0x330 * * * * 0x09000000054B6F48 * * @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb * * + 0x3CC * * * * 0x090000000566C128 * * * * @64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 * * * * 0x090000000566BF70 * * * * @64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x2B0 * * * * 0x090000000566B604 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * * + * * 0xFC * * * * 0x090000000560EA10 RunEDU__8sqeAgentFv + 0x80 * * * * 0x0900000005615AA0 EDUDriver__9sqzEDUObjFv + 0xE4 * * * * 0x0900000005609474 sqloEDUEntry + 0x264 * * * * </StackTrace> * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 version 9.7 Fix Pack 3. * ****************************************************************
Local-Fix:

verfügbare FixPacks:
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 8 for Linux, UNIX, and Windows DB2 Version 9.7 Fix Pack 9a 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

Workaround
n/a
Bug-Verfolgung
Vorgänger : APAR is sysrouted TO one or more of the following: IC69695 Nachfolger :
Weitere Daten
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung:	05.07.2010 28.09.2010 28.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version
9.7.0.3
9.7.0.3