I need to clean up the log files created by DB2 and OS on Linux and AIX servers. Can someone tell me which log files and their location should be cleaned up after reviewing/archiving ?. I know Smith log file is one of them on AIX..........It would be the best if I can have a script to clean them periodically...........

Thanks for any help.

which the db2 version are you on ?

Which version of DB2 are you on ?

list history backup all for DBNAME

This will tell you which logs are required for which backup images.

ie:
Op Obj Timestamp+Sequence Type Dev Earliest Log Current Log Backup ID
-- --- ------------------ ---- --- ------------ ------------ --------------
B D 20051214010002001 N D S0037889.LOG S0037889.LOG

For my backup above, I need S0037889.LOG and later to get to the current point in time. If I have 100% confidence in that particular backup then I can remove any logs before S0037889.LOG. Usually we keep a few weeks worth just to be sure, you never know when someone needs some data from an old point in time...

I think he means logs like db2diag.log and such.

They are in $HOME/sqllib/db2dump, where "$HOME" is the instance owner home directory.

I am sorry....I have been away for a while.

The log files that grow over time. What ever they are.........Either the DB2 process creates or the operating system creates.........I am not worried about the software installation log files.

Thanks.

DB2 version 8.1 & 8.2.............

It's a bit more complicated than that... my post above addresses transaction logs, every INSERT/UPDATE/DELETE to db2 is logged for integrity. If you crash, you can restore and replay the transactions in the logs so you don't lose data.

Diagnostic logs are where n_i said.

I am sorry..........No I wasn't talking about transaction logs...........

Thanks.

get the timestamp of the backup as a reply above, and you can use 'prune' command to remove the archived logs