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

DB2 may abend with SIGSEV due to socket FD overflow which can to lead stack
corruption

product:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problem description:
DB2 may abend with SIGSEV due to socket FD overflow which can to 
lead stack corruption. 
 
This can been seen if you have the following: 
 
- ulimit nofiles set greater than 65534 
- Large number of tablespace containers. 
- Multiple number of databases in a single instance. 
- Large number of remote client connection. 
 
db2diag.log: 
 
2011-11-14-16.58.32.830196+060 I933528E472         LEVEL: Severe 
PID     : 19296                TID  : 46931430598976PROC : 
db2sysc 0 
INSTANCE: db2adm               NODE : 000 
APPHDL  : 0-10974 
EDUID   : 3042                 EDUNAME: db2agent () 0 
FUNCTION: DB2 UDB, RAS/PD component, 
pdResilienceIsSafeToSustain, probe:800 
DATA #1 : String, 37 bytes 
Trap Sustainability Criteria Checking 
DATA #2 : Hex integer, 8 bytes 
0x0000000400008800 
DATA #3 : Boolean, 1 bytes 
false 
 
2011-11-14-16.58.32.857846+060 I934001E470         LEVEL: Error 
PID     : 19296                TID  : 46931430598976PROC : 
db2sysc 0 
INSTANCE: db2adm               NODE : 000 
APPHDL  : 0-10974 
EDUID   : 3042                 EDUNAME: db2agent () 0 
FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, 
probe:1 
MESSAGE : Error in agent servicing application with coor_node: 
DATA #1 : Hexdump, 2 bytes 
0x00002AAF1300F592 : 0000 
.. 
 
Stack Trace 
 
0x00002AAAB01A3E2F ossDumpStackTraceEx 
0x00002AAAB019EBEE OSSTrapFile::dumpEx 
0x00002AAAAD2AACAB sqlo_trce 
0x00002AAAAD2F0392 sqloEDUCodeTrapHandler 
0x00000037D840E4C0 __invoke_dynamic_linker__ 
0x00002AAAAB7E7384 sqloSwap2to2 
0x00002AAAAB9591C4 sqleReadDssHdr 
0x00002AAAAB95888F sqlePeekDrdaBuffer 
0x00002AAAAB9586F8 sqlePeekRequest 
0x00002AAAAB9FFF72 sqlePeekRequest 
0x00002AAAAB9FF5BD sqljsVerifyAgent 
0x00002AAAAB9FF014 sqljsInitAgent
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6 or Higher                          * 
****************************************************************
Local Fix:
Ensure ulimit nofiles set to value less than 65534
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
Fixed in v9.7 Fixpack 6
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC84323 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
18.11.2011
17.07.2012
17.07.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