Raj, the first thing I would do is run DB2 GET DBM CFG and see what the DIAGLEVEL is set to. I think 4 is the highest level which records all messages, even the informational ones. If it is 4 you can change it with:
update dbm cfg using DIAGLEVEL 3
If DIAGLEVEL is already at 3, you will need to examine the DB2DIAG.LOG file and see if you can determine what messages are causing such large increases to the size of the file.
I have checked the db2diag.log file.This file increasing only night time only.I able to see lot of message regarding to EVENT. Automatic Runstats happening night time how to stop this please help me..
A tip and a warning on this subject:
- Tip: execute "db2diag -A" once a day/week/month. This will start a fresh copy of the db2diag file
- warning: on win2003 I noticed a complete freeze of DB2 when the db2diag file reaches 4Gb! Avoid this using above mentioned tip :-)