Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
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
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