DB2 FOR LUW / DB2FORLUW / 970 - DB2

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

**************************************************************** 
* USERS AFFECTED:                                              * 
* All Platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to v9.7 Fixpack 6 or Higher                          * 
****************************************************************

Ensure ulimit nofiles set to value less than 65534

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
 

Fixed in v9.7 Fixpack 6

keiner bekannt / siehe Local-Fix

Vorgänger  : APAR is sysrouted TO one or more of the following: IC84323 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

18.11.2011
17.07.2012
17.07.2012

9.7.FP6