DB2 - Problembeschreibung
Problem IC63346 | Status: Geschlossen |
INSTANCE TRAPS IN SQZDATACHAINITERATOR::PEEKCHAINELEM | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problembeschreibung: | |
Problem occurs when concentrator and WLM service superclass connections concurrency threshold are enabled. If a connection with a TCP/IP client is switched out and the client dies, the concentrator dispatcher will try to perform a clean up. The agent will perform switch in processing before it can proceed with cleaning up the connection. If the switch failed, the dispatcher and agent might get into a loop. The connection never gets cleaned up in this scenario and system CPU usage spikes to 100% because of the loop. The system may also end up with a signal 11 trap. <StackTrace> -------Frame------ ------Function + Offset------ 0x09000000116922A8 peekChainElem__20sqzDataChainIteratorXT14sqeApplication_Fv + 0x28 0x0900000011692334 isNull__20sqzDataChainIteratorXT14sqeApplication_Fv + 0x14 0x0900000011693164 sqleServiceClassDeregisterConn__FP8sqeAgentb + 0x2E4 0x0900000010B29A2C AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x72C 0x0900000010CFFC8C sqlesrspWrp__FP14db2UCinterface + 0x2AC 0x0900000010D04578 sqleUCagentConnectReset + 0x1F8 0x0900000013418718 sqljsCleanup__FP8sqeAgentP14db2UCconHandle + 0x398 0x0900000013427348 sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5A8 0x0900000013428ABC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 0x23C 0x090000001075178C RunEDU__8sqeAgentFv + 0x3AC 0x090000001074137C EDUDriver__9sqzEDUObjFv + 0x19C | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * all platforms * **************************************************************** * PROBLEM DESCRIPTION: * * Problem occurs when concentrator and WLM service superclass * * * * connections concurrency threshold are enabled. If a * * connection * * with a TCP/IP client is switched out and the client dies, * * the * * concentrator dispatcher will try to perform a clean up. The * * * * agent will perform switch in processing before it can * * proceed * * with cleaning up the connection. If the switch failed, the * * * * dispatcher and agent might get into a loop. The connection * * never * * gets cleaned up in this scenario and system CPU usage spikes * * to * * 100% because of the loop. The system may also end up with a * * * * signal 11 trap. * * * * * * * * <StackTrace> * * * * -------Frame------ ------Function + Offset------ * * * * 0x09000000116922A8 * * * * peekChainElem__20sqzDataChainIteratorXT14sqeApplication_Fv + * * * * 0x28 * * * * 0x0900000011692334 * * * * isNull__20sqzDataChainIteratorXT14sqeApplication_Fv + 0x14 * * * * 0x0900000011693164 * * sqleServiceClassDeregisterConn__FP8sqeAgentb * * + 0x2E4 * * * * 0x0900000010B29A2C * * * * AppStopUsing__14sqeApplicationFP8sqeAgentUcP5sqlca + 0x72C * * * * 0x0900000010CFFC8C sqlesrspWrp__FP14db2UCinterface + 0x2AC * * * * 0x0900000010D04578 sqleUCagentConnectReset + 0x1F8 * * * * 0x0900000013418718 * * sqljsCleanup__FP8sqeAgentP14db2UCconHandle + * * 0x398 * * * * 0x0900000013427348 * * * * sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x5A8 * * * * 0x0900000013428ABC sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T * * + * * 0x23C * * * * 0x090000001075178C RunEDU__8sqeAgentFv + 0x3AC * * * * 0x090000001074137C EDUDriver__9sqzEDUObjFv + 0x19C * **************************************************************** * RECOMMENDATION: * * Upgrade to v95 FP6 * **************************************************************** | |
Local-Fix: | |
verfügbare FixPacks: | |
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows | |
Lösung | |
V95 FP6 | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 22.09.2009 14.05.2010 14.05.2010 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.5.FP6 | |
Problem behoben lt. FixList in der Version |