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 IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

where is db2diag.log located? 1

Status
Not open for further replies.

ddiamond

Programmer
Apr 22, 2005
918
US
On a windows installation, where can I find db2diag.log?
 
Start search in the 'sqllib' folder of the installation partition.

Ties Blom

 
Ties is right: C:\sqllib\db2\.
But on windows you can use the event-viewer to look for DB2 messages.
 
I couldn't find the folder sqllib. I was able to see messages on the event-viewer, however.
 
The directory SQLLIB with 2 l's. Cannot be found? Ties, do you agree with the qualification "eigenaardig"?
 
If you cannot find under sqllib [ 'C:\Program Files\sqllib\db2' is the default ]. If the instance name is not db2, then use the instance name instead of the directory db2 in the above path.

If you are unable to find the db2diag.log there, check the dbm cfg DIAGPATH.

db2 get dbm cfg

In other words, the diagnostic file is present in the DIAGPATH directory. If no path is specified, the file is in the default path

HTH

Sathyaram

For db2 resoruces visit More DB2 questions answered at &
 
Truusvlugindewind,

That is correct. I searched the entire C drive and cound not find sqllib. I also searched the entire C drive and could not find the file db2diag.log.

Sathyaram,

DIAGPATH is blank, so that means it should be in the default path. Is that c:\sqllib? In any case, for the time being, I will use the event viewer to track errors and warnings.

- Dan
 
What is the value of the parameter diaglevel? If it is zero, no diagnostic info will be captured ...

Other reasons could be that db2 is not able to write into the file ... On unix, it can be permission issues or the diagpath itself doesn't exist ... Not sure, what it can be on windows

HTH
Sathyaram

For db2 resoruces visit More DB2 questions answered at &
 
Hold on ..

It's strange you do not find sqllib?? You should be able to find in D:\, E:\ ..... Z:\ ... Because that's where db2 software is installed ...

I suggest you check for the environment variable db2path

echo %DB2PATH%

Check for the diag file under this path

HTH

Sathyaram


For db2 resoruces visit More DB2 questions answered at &
 
What is the value of the parameter diaglevel?
diaglevel=3

I located sqllib on the D drive:
D:\program files\IBM\sqllib

Still can't find db2diag.log.
 
Found it, finally. Thanks everyone for your help.

D:\Program Files\IBM\SQLLIB\PROD\db2diag.log
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top