Results 1 to 5 of 5
  1. #1
    Join Date
    May 2013
    Posts
    10

    Unanswered: DB2 LUW 9.7.7 crashed suddenly

    Hi All,

    DB2 LUW 9.7.7 crashed suddenly by generating some dump file. And after that i am not ablw to stop/start the instance. no events logging on to db2dumpdiag.log

    please see the info logged on to db2diag.log

    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:10
    MESSAGE : Error in agent servicing application

    FUNCTION: DB2 UDB, base sys utilities, sqleagnt_sigsegvh, probe:9
    MESSAGE : Error in agent servicing application with PRODUCT SIGNATURE:


    It was in hung state

    any idea is highly appreciated.

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    if not responding at all - try ipclean
    this will kill all db2 processes
    db2start to bring it back
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  3. #3
    Join Date
    May 2013
    Posts
    10
    Thanks for your reply Guy! Appreciate your help!
    i'm a system admin....but trying to understand why DB2 9.7.7 LUW was in hung state/crashed

    it generated a dump file FODC_Trap_2013 under instance home.

    Qn) FODC_Trap_2013 dump file created after it was hung/crashed.....reason ?
    is that because of any heap memory in DB2 ?

    i mean FODC dmp file generated due to heap memory issues ??

    now we restarted the middleware/OS. and now DB2 is working fine. but am not sure why crashed ?
    one of our DBA is planning to open a PMR.
    please advice

    Thanks,
    SA

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    Quote Originally Posted by SA77 View Post
    one of our DBA is planning to open a PMR.
    Sounds like a good plan ...
    You should raise a PMR.

  5. #5
    Join Date
    Jan 2009
    Location
    United Kingdom
    Posts
    77
    There are many reasons why it can crash - read this post for info on how to analyse a DB2 trap file Analyzing a DB2 trap file - DBA DB2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •