Latest versionsfixlist
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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IC79235 Status: Closed

ENGINE TRAPS DUE TO SEGV HIT IN SQLEREMOVEENTRYFROMRESYNC()

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
Engines traps with the following stack showing 
sqleRemoveEntryFromResync() hitting SEGV (Signal #11): 
 
EDU name     : db2agent (SAMPLE) 0 
EDU ID       : 109928 
Signal #11 
...... 
0x0900000005A1617C 
sqleRemoveEntryFromResync__FP11sqlxa_xid_t14sqleResyncTypePc + 
0x148 
0x0900000005A147A8 
sqljsSyncctlReply__FP13sqljsDrdaAsCbP14db2UCinterfacei + 0x1D04 
0x09000000051BDC10 
.sqljsDrdaAsCBCompletion.fdpr.clone.252__FP14db2UCinterfacei + 
0x32C 
0x09000000051BD1FC sqlrr_rds_common_post__FP14db2UCinterfaceiT2l 
+ 0x13BC 
0x0900000006FECEA0 sqlrr_xcommit__FP14db2UCinterface + 0x1F48 
0x0900000005B3ADF4 sqljsSyncCommitted__FP14db2UCinterface + 
0x4D0 
0x0900000005B88530 
sqljs_ddm_syncctl__FP14db2UCinterfaceP13sqljDDMObject + 0x3C8 
0x0900000004B36F34 
sqljsParseRdbAccessed__FP13sqljsDrdaAsCbP13sqljDDMObjectP14db2UC 
interface 
+ 0x178 
0x09000000051A15E4 
.sqljsParse.fdpr.clone.168__FP13sqljsDrdaAsCbP14db2UCinterfaceP8 
sqeAgentb 
+ 0x408 
0x090000000519C600 @64@sqljsSqlam__FP14db2UCinterfaceP8sqeAgentb 
+ 0xC50 
0x0900000005006BAC 
@64@sqljsDriveRequests__FP8sqeAgentP14db2UCconHandle + 0xB4 
0x09000000056F3754 
@64@sqljsDrdaAsInnerDriver__FP18SQLCC_INITSTRUCT_Tb + 0x178 
0x0900000005006444 sqljsDrdaAsDriver__FP18SQLCC_INITSTRUCT_T + 
0x1F8 
0x09000000050658E8 RunEDU__8sqeAgentFv + 0x7C 
0x0900000005060DB4 EDUDriver__9sqzEDUObjFv + 0xD8 
0x0900000005073EEC sqloEDUEntry + 0x264 
 
 
Before the trap, db2diag.log may have following message 
indicating Resync List has been full: 
 
2011-09-23-15.08.39.785187-420 E1503306A441       LEVEL: Severe 
PID     : 758298               TID  : 110442      PROC : db2sysc 
0 
INSTANCE: test                NODE : 000         DB   : SAMPLE 
APPHDL  : 0-40210              APPID: 
USPCCW01.INA400.C86AD450D8A8 
AUTHID  : user 
EDUID   : 110442               EDUNAME: db2agent (SAMPLE) 0 
FUNCTION: DB2 UDB, base sys utilities, sqleAddEntryToResync, 
probe:20 
MESSAGE : Out of ResyncEntries!
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW Version 9.7 Fix Pack 6                    * 
****************************************************************
Local Fix:
A larger Resync List by increasing NUMDB in DBM CFG may reduce 
risk of hitting this APAR
available fix packs:
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Problem was first fixed in Version 9.7 Fix Pack 6
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
14.10.2011
11.06.2012
11.06.2012
Problem solved at the following versions (IBM BugInfos)
9.7.FP6
Problem solved according to the fixlist(s) of the following version(s)
9.7.0.6 FixList
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.