By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,445 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

Need help on deleting log file (log_dir)

P: 2
Hi, I have read some of the forums regarding deletion of log files. Just to get more information before I perform the deletion of log files. These are the steps I got:

1. db2 get db cfg <DBSID>
2. search for the "first active log file", then subtract 1 from it. For example i got S0000745.LOG. Subtract 1, that's S0000744.LOG
3. db2 prune logfile prior to S0000744.LOG

What is the difference if I simply command the "rm -r <filename>"?

I am taking a weekly offline full back up. Do I really need to retain the old logs? If deletion is permitted, how will I perform it? Are the steps above suficient to do the deletion?

What is the difference if it is an online full back up?

I haved read also about LOGRETAIN and USEREXIT, values I get from db2 get db cfg are both "OFF", Please explain in simple terms.

Hope you could help me, my log_dir is reaching 97%. Thanks.
Jun 26 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.