Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC63346 Status: Closed

INSTANCE TRAPS IN SQZDATACHAINITERATOR::PEEKCHAINELEM

product:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
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
Problem Summary:
**************************************************************** 
* 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:
available fix packs:
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

Solution
V95 FP6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.09.2009
14.05.2010
14.05.2010
Problem solved at the following versions (IBM BugInfos)
9.5.FP6
Problem solved according to the fixlist(s) of the following version(s)
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.