Hi, I am a DB2 for NT administartor. Where and how can I get a log of all the activities that take place in my database. For example, I want to get information on what DDL, DMLs have taken place on a day to day basis to keep a track on all the activities being done. Is there any specific log file maintained internally by DB2 database server or I need to create it expilicitly. In case I need to make it, pls let me know how can I achieve it.

Thanks,
Neeraj

http://publib.boulder.ibm.com/infoce...n/c0005483.htm