|
Problem IC84323
|
Status: Closed |
DB2 may abend with SIGSEV due to socket FD overflow which can to lead stack corruption |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - 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 v10.1 Fixpack 1 or Higher *
**************************************************************** |
| Local Fix: |
Ensure ulimit nofiles set to value less than 65534 |
| available fix packs: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Solution |
First Fixed in v10.1 Fixpack 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.06.2012
13.11.2012
13.11.2012 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
