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

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..

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

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