DB2V9 logging

[juhu]

Hi,

for test i have installed the DB2v9 Express on Windows. Can please you please say me where I can found any logging information? Is there a main logfile where I can see errors. Can you also give me a tipp how I can create "small" errors to analyse.

Regards

 

[blom0344]

dbdiag.log??
(no idea if V9 still has this)

Ties Blom

 

[Truusvlugindewind]

Dunno. I've got V9 installed on linux.
Please read/try those:

http://tek-tips.com/viewthread.cfm?qid=1287246&page=3

http://tek-tips.com/viewthread.cfm?qid=1278327&page=3

and inform us if it still valid or not. My guess is that nothing is changed in that field.

 

[juhu]

yes the db2diag.log exists but there I can't see for example when I drop a table ore something else:

Where can I ses why a db2 crashed for example? (regular)

 

[blom0344]

On Windows you can use the
Notification log that writes to the Application Event Log
(Use Event Viewer). Look for events of application DB2.
In version 7 it was possible (at instance level) to set the level of messages (ranging from only severe errors to very extensive logging) that were written to the dbdiag.log.
(3 or 4 levels) Not sure if DDL actions were recorded at all.

Ties Blom