home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
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