Latest technical tip - Append only DB2 diagnostic log and administration notification log files?
September 2nd, 2009

No more in DB2 9.7!

How many times have I asked customers for the DB2 diagnostic log file (db2diag.log) only to be told "it's too large to send" or "it's taking too long to open." This is because the DB2 diagnostic files have been append only since time memorial, their growth only restricted by the maximum space available in the file system they reside in. The only way to curb this growth would be to rename the files which would then force the creation of new ones. Scripts had to be written to automate this process and to delete old files after a certain period. 

Check out our knowledgebase for the full explanation.