IBM DB2 Services shutdown problem

[Nilesh C]

At our site IBM DB2 " Universal Database Express Edition

8.2 "install in Linux OS(Red hat Enterprise Linux 4(32

Bit ).In DB2 software configure ourdatabase but last 2-3

days this database stopping automatically when this

disconnecting our client unable to access database

application like .NET.

Following error detected in DB2diag.log file

2010-11-20-22.08.55.913360+330 I117212357G428 LEVEL: Severe
PID : 11311 TID : 3019474624 PROC : db2tcpcm
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUSIGCHLDHandler, probe:50
DATA #1 : String, 155 bytes
Detected the death of an EDU with process id 9796
The signal number that terminated this process was 9
Look for trap files (t9796.*) in the dump directory

2010-11-20-22.08.58.808617+330 E117212786G510 LEVEL: Severe
PID : 11311 TID : 3019474624 PROC : db2tcpcm
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:10
MESSAGE : ADM0503C An unexpected internal processing error has occurred. ALL
DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN.
Diagnostic information has been recorded. Contact IBM Support for
further assistance.

2010-11-20-22.08.58.809074+330 E117213297G903 LEVEL: Severe
PID : 11311 TID : 3019474624 PROC : db2tcpcm
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloEDUCodeTrapHandler, probe:20
DATA #1 : Signal Number Recieved, 4 bytes
6
DATA #2 : Siginfo, 128 bytes
0xBFFF6208 : 0600 0000 0000 0000 FAFF FFFF 2F2C 0000 ............/,..
0xBFFF6218 : FE01 0000 0000 0000 0E0C E84C 0000 0000 ...........L....
0xBFFF6228 : B0A1 4DC8 EEF6 11C0 80EC 7DF5 2F2C 0000 ..M.......}./,..
0xBFFF6238 : 501F 3632 9909 111A AC4F 6DE8 68D1 3FC0 P.62.....Om.h.?.
0xBFFF6248 : 4602 0000 0000 0000 0100 0000 A84F 6DE8 F............Om.
0xBFFF6258 : 11BC 12C0 0000 0100 0000 0000 A065 FFBF .............e..
0xBFFF6268 : A84F 6DE8 0000 0000 F2FF FFFF C3BC 12C0 .Om.............
0xBFFF6278 : 0000 0100 0000 0000 2000 0000 0000 0000 ........ .......

2010-11-20-22.09.01.466912+330 I117214201G361 LEVEL: Severe
PID : 11304 TID : 3019474624 PROC : db2sysc
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:15
MESSAGE : DiagData
DATA #1 : Hexdump, 15 bytes
0x08052DAC : 416E 2045 4455 2063 7261 7368 6564 2E An EDU crashed.

2010-11-20-22.09.01.470454+330 I117214563G349 LEVEL: Severe
PID : 11304 TID : 3019474624 PROC : db2sysc
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:16
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFC534 : 2F2C 0000 /,..

2010-11-20-22.09.01.470822+330 I117214913G349 LEVEL: Severe
PID : 11304 TID : 3019474624 PROC : db2sysc
INSTANCE: db2inst2 NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleChildCrashHandler, probe:17
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0xBFFFC52C : 0101 0000


Thanks

Nilesh Chavan

[vijay2082]

Hi Nilesh,

db2tcpcm is receiving a signal 9 whenever your client is terminating ( this client as told by you may be causing some internal issue). This required deep analysis and nothing can be told by looking at this piece of information. Raise a PMR with IBM and we will assit you there.

Wondering you are still with 8.2 though. Hope you have got support from IBM for exprecc C to receive the updates.

Cheers, Vijay