Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Disconnected from the server DB2
- Thread starter oana12
- Start date
It seems your database is crashing. Before driving to that conclusion, see the logs.
See your db2diag.log file for more information. To locate that file, use the command
db2 get dbm cfg |grep DIAGPATH
Also,
Pls psot the contenets [last 20 lines] of
1. db2diag.log file in this directory
2. 20 lines of Notify log : It will be like <instance-name>.nfy .
3. Conents of DIAGPATH directory.
4. DB2 Version, Fixpack, Operating System Version.
These will help to analyze.
See your db2diag.log file for more information. To locate that file, use the command
db2 get dbm cfg |grep DIAGPATH
Also,
Pls psot the contenets [last 20 lines] of
1. db2diag.log file in this directory
2. 20 lines of Notify log : It will be like <instance-name>.nfy .
3. Conents of DIAGPATH directory.
4. DB2 Version, Fixpack, Operating System Version.
These will help to analyze.
- Thread starter
- #3
If you can recreate the problem, then, do this.
Rename db2diag.log file as db2diag.log.old and
create a file 'db2diag.log'.
Similarly for <instance-name>.nfy file.
After that you try to reproduce the problem and post the errors of these files.
Rename db2diag.log file as db2diag.log.old and
create a file 'db2diag.log'.
Similarly for <instance-name>.nfy file.
After that you try to reproduce the problem and post the errors of these files.
- Status
Similar threads
- Locked
- Question