IBM DB2 Services shutdown problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Nilesh C
    New Member
    • Nov 2010
    • 1

    IBM DB2 Services shutdown problem

    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, sqloEDUSIGCHLDH andler, 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, sqloEDUCodeTrap Handler, 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, sqloEDUCodeTrap Handler, 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, sqleChildCrashH andler, 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, sqleChildCrashH andler, 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, sqleChildCrashH andler, probe:17
    MESSAGE : DiagData
    DATA #1 : Hexdump, 4 bytes
    0xBFFFC52C : 0101 0000


    Thanks

    Nilesh Chavan
  • vijay2082
    New Member
    • Aug 2009
    • 112

    #2
    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

    Comment

    Working...