Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2006
    Posts
    6

    Unanswered: database server getting down

    hi guys
    iam facing a problem , my database server gets down abruptly, is it possible that the application code can cause the database server down, and it gets up after some time ..... and every time i have to issue a db2 start database manager command , is there in way to find out what is causing the problem....
    and iam working on linux....

    Regards
    Jayawant

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    down

    db2diag.log is the place to be...
    all errors will be present, or give you a hint about the problem..
    have db2fm started, so the instance will be started automatically..
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Jan 2006
    Posts
    6
    hi Guy Przytula,
    thanks for the reply .
    correct me i f i am wrong db2 diag.log file is generated as a result of db2support.zip that file is huge what to look for in it ?
    waiting eagerly for ur reply

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    Hi,

    Seems your error is of Level Severe. As your diag.log file is very large, try the following command and see what is the output..

    at the db2cmd prompt:

    $db2diag -g level=Severe

    and redirect the output to a flat file: Analyse the Sever Error. Hopefully you should find some clue to the problem.

    Tx,
    Jay

Posting Permissions

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