Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2010
    Posts
    207

    Unanswered: DB2 Version 9.7 Fixpack 4 crashes 2-3 times a week

    Hello Guys,

    How you doing? Since a week more more we are experiencing problems on a productive system. The IBM Support mentioned that it could be because of to less RAM ... which we are going to upgrade soon.

    Any other possibility is to find something within DB2, maybe a db or dbm parameter. Does anyone know something with "Sort Shared" which we have to limit a bit ...

    I am thankful for each hint. Thanks in advance.

    DB_N00b

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    I was aware of few incidents where db2 instance got crashed after LOAD command is run on DB2 V9.7 ( aix) where customer recently upgraded to fixpack 4. Last status I was aware of was PMR was looking into the same whether it was related to FP 4.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    does it crash with a specific operation or conditon
    any indication in diag file ?
    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

  4. #4
    Join Date
    Jan 2010
    Posts
    207
    db2diag doesnt say anything

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    there is always an entry for a crash - and different files in diagpath..

    at least the db2star2 db2start should be seen
    so the error is just before this start..
    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

  6. #6
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    checkout for the FFDC information. It will surely exist either in the .nfy file, diag.log, or will create some trap file or coredumps. Once we have some bit of information from the ffdc, it will be easy to understand.

    I will recommend you to open a PMR in such situation as 9.7 --FP4 is very recent there can be a possible bug which might not have been detected before the release.

    Jayanta Datta
    DB2 UDB DBA
    IBM India, Global Delivery
    New Delhi

  7. #7
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,368
    There is should be something in the db2diag.log and/or some diagnostic info (ie. trap files..) dumped in the diagpath if db2 crashed. What is the OS? Check if there are any errors logged in the OS log. Anything related to db2sysc getting killed by the kernel?

Posting Permissions

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