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

Status
Not open for further replies.

oana12

Programmer
Jan 6, 2005
21
0
0
CA
Hi,
When I am doing an import or when I want to execute a complex procedure DB2 server is shut down.
Which can be the cause?

Thanks.
 
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.
 
I can't even look in db2diag.log , the file had over 40 MB and I can't open it.
I use DB2 v8.2 on Windows 2003. What can I do ?
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top