DB2 - Problembeschreibung
Problem IC72203 | Status: Geschlossen |
DB2 MAY CRASH WHEN DROPPING A GLOBAL TEMPORARY TABLE IN A DMS TABLESPACE | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
When dropping a Global Temporary Table in a DMS Tablespace, a crash could possibly occur. The db2diag message and the related stack are shown below. 2010-08-20-12.12.11.282571-240 E141829194A549 LEVEL: Severe PID : 684280 TID : 258 PROC : db2wdog 0 INSTANCE: db2fdad NODE : 000 EDUID : 258 EDUNAME: db2wdog 0 FUNCTION: DB2 UDB, base sys utilities, sqleWatchDog, probe:20 MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Diagnostic information has been recorded. Contact IBM Support for further assistance. <StackTrace> 0x0900000004D8331C sqlrrGetTableName__FP8sqlrr_cbUsT2PPcPiT4N25 + 0x9C 0x0900000004D830FC sqldLoadTableName__FP8sqeAgentP8SQLD_TCBPciT3T4 + 0x460 0x0900000004D82B2C sqldLoadTableName__FP8sqeAgentP8SQLD_TCBPciT3T4@glueA28 + 0x78 0x0900000004CB82BC sqldLockTableFixTCB__FP8sqeAgentUsT2UciN35UlT9T5PcT5T12_T5P14SQL P_LOCK_INFOPP8SQLD_TCBUiT18_ + 0x6E0 0x0900000004DF7500 sqldLockTableFixTCB__FP8sqeAgentUsT2UciN35UlT9T5PcT5T12_T5P14SQL P_LOCK_INFOPP8SQLD_TCBUiT18_@glue8CA + 0x114 0x0900000004E9DE98 sqldRemoveTableFromTran__FP8sqeAgentiN52PP8SQLD_TCB + 0x84 0x0900000004F3EA1C sqldTableDrop__FP8sqeAgentUsT2UciPcT5T6T5 + 0xCC 0x0900000005961698 sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciUsT5T4 + 0x5F8 0x0900000006A636A8 sqlrl_userTempDropAll__FP8sqlrr_cb + 0x194 0x0900000006A63454 sqlrl_userTempDropAll__FP8sqlrr_cb@glue8F3 + 0x70 0x0900000005016A78 sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x19C 0x0900000004D7A598 sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO + 0x390 0x090000000551AC70 sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO@glue8EA + 0x80 0x0900000005022630 sqlrr_rds_common_post__FP14db2UCinterfaceiT2l + 0x130C 0x0900000004EA16F0 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0xEC 0x09000000064C681C executeSection__10pvmPackageFP5sqlcaUi + 0x87C 0x09000000064B9E30 executeQuery__3PVMFUi + 0xCC 0x09000000064B96B4 run__3PVMFv + 0x9AC 0x09000000064B79AC pvm_entry + 0x320 0x0900000004ED02F4 sqloInvokeFnArgs + 0xB0 0x090000000638A07C sqloInvokeFnArgs@glue5F0 + 0x74 0x09000000050069C4 sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf + 0x1138 0x09000000051718B8 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 0x09000000051F2040 sqlricall__FP8sqlrr_cb + 0x7C 0x0900000004E75440 sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - 0x708 0x0900000004EAD7F0 sqlrr_process_execute_request__FP8sqlrr_cbi - 0x234 0x0900000004EA1664 sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo + 0x60 0x0900000004EA7424 sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + 0x8E4 0x0900000004EA7D74 sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC interface - 0x50 0x0900000004EA7B80 sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 0x0900000004EA913C @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb + 0x160 0x0900000004D3FE88 @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 0x0900000004D3FBAC @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 0x0900000004D3F940 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x13C 0x0900000004D42D8C RunEDU__8sqeAgentFv + 0x140 0x0900000004D431D8 EDUDriver__9sqzEDUObjFv + 0x94 0x0900000004DC8928 sqloEDUEntry + 0x228 </StackTrace> | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * When dropping a Global Temporary Table in a DMS Tablespace, * * a crash could possibly occur with the following Stack Trace: * * * * * * <StackTrace> * * * * 0x0900000004D8331C * * sqlrrGetTableName__FP8sqlrr_cbUsT2PPcPiT4N25 * * + 0x9C * * * * 0x0900000004D830FC * * * * sqldLoadTableName__FP8sqeAgentP8SQLD_TCBPciT3T4 + 0x460 * * * * 0x0900000004D82B2C * * * * sqldLoadTableName__FP8sqeAgentP8SQLD_TCBPciT3T4@glueA28 + * * 0x78 * * 0x0900000004CB82BC * * * * sqldLockTableFixTCB__FP8sqeAgentUsT2UciN35UlT9T5PcT5T12_T5P14S * P_LOCK_INFOPP8SQLD_TCBUiT18_ * * * * + 0x6E0 * * * * 0x0900000004DF7500 * * * * sqldLockTableFixTCB__FP8sqeAgentUsT2UciN35UlT9T5PcT5T12_T5P14S * P_LOCK_INFOPP8SQLD_TCBUiT18_@glue8CA * * * * + 0x114 * * * * 0x0900000004E9DE98 * * * * sqldRemoveTableFromTran__FP8sqeAgentiN52PP8SQLD_TCB + 0x84 * * * * 0x0900000004F3EA1C sqldTableDrop__FP8sqeAgentUsT2UciPcT5T6T5 * * + * * 0xCC * * * * 0x0900000005961698 * * * * sqlrl_userTempDrop__FP8sqlrr_cbP19sqlrl_userTempEntryPUciUsT5T * + 0x5F8 * * * * 0x0900000006A636A8 sqlrl_userTempDropAll__FP8sqlrr_cb + * * 0x194 * * 0x0900000006A63454 * * sqlrl_userTempDropAll__FP8sqlrr_cb@glue8F3 + * * 0x70 * * * * 0x0900000005016A78 * * * * sqlrr_cleanup_tran_before_DPS__FP8sqlrr_cbiN62PiT9 + 0x19C * * * * 0x0900000004D7A598 * * sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO + * * 0x390 * * * * 0x090000000551AC70 * * * * sqlrrbck__FP8sqlrr_cbiN32P15SQLXA_CALL_INFO@glue8EA + 0x80 * * * * 0x0900000005022630 * * sqlrr_rds_common_post__FP14db2UCinterfaceiT2l * * + 0x130C * * * * 0x0900000004EA16F0 * * sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo * * + 0xEC * * * * 0x09000000064C681C executeSection__10pvmPackageFP5sqlcaUi + * * * * 0x87C * * * * 0x09000000064B9E30 executeQuery__3PVMFUi + 0xCC * * * * 0x09000000064B96B4 run__3PVMFv + 0x9AC * * * * 0x09000000064B79AC pvm_entry + 0x320 * * * * 0x0900000004ED02F4 sqloInvokeFnArgs + 0xB0 * * * * 0x090000000638A07C sqloInvokeFnArgs@glue5F0 + 0x74 * * * * 0x09000000050069C4 * * * * sqlriInvokerTrusted__FP10sqlri_ufobP21sqlriRoutineErrorIntf * * + * * 0x1138 * * * * 0x09000000051718B8 sqlriInvokeInvoker__FP10sqlri_ufob + 0x90 * * * * 0x09000000051F2040 sqlricall__FP8sqlrr_cb + 0x7C * * * * 0x0900000004E75440 * * sqlriSectInvoke__FP8sqlrr_cbP12sqlri_opparm - * * 0x708 * * * * 0x0900000004EAD7F0 * * sqlrr_process_execute_request__FP8sqlrr_cbi - * * 0x234 * * * * 0x0900000004EA1664 * * sqlrr_execute__FP14db2UCinterfaceP9UCstpInfo * * + 0x60 * * * * 0x0900000004EA7424 * * * * sqljs_ddm_excsqlstt__FP14db2UCinterfaceP13sqljDDMObject + * * 0x8E4 * * 0x0900000004EA7D74 * * * * sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2 * interface * * * * - 0x50 * * * * 0x0900000004EA7B80 * * * * sqljsParse__FP13sqljsDrdaAsCbP14db2UCinterface - 0x124 * * * * 0x0900000004EA913C * * @63@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb * * + 0x160 * * * * 0x0900000004D3FE88 * * * * @63@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0x98 * * * * 0x0900000004D3FBAC * * * * @63@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0xE0 * * * * 0x0900000004D3F940 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * * + * * 0x13C * * * * 0x0900000004D42D8C RunEDU__8sqeAgentFv + 0x140 * * * * 0x0900000004D431D8 EDUDriver__9sqzEDUObjFv + 0x94 * * * * 0x0900000004DC8928 sqloEDUEntry + 0x228 * * * * </StackTrace> * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 8. * **************************************************************** | |
Local-Fix: | |
N/A | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows | |
Lösung | |
Problem was fixed on DB2 Version 9.5 Fix Pack 8. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC73883 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 26.10.2010 09.08.2011 09.08.2011 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP8 | |
Problem behoben lt. FixList in der Version | |
9.5.0.8 |