467,202 Members | 1,075 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,202 developers. It's quick & easy.

Need help on deleting log file (log_dir)

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
  • viewed: 1831

Post your reply

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

Similar topics

3 posts views Thread by Aaron Walker | last post: by
4 posts views Thread by al havrilla | last post: by
3 posts views Thread by Joe | last post: by
8 posts views Thread by Chris | last post: by
5 posts views Thread by Sandeep Singh Sekhon | last post: by
3 posts views Thread by Kimera.Kimera@gmail.com | last post: by
4 posts views Thread by memoman | last post: by
13 posts views Thread by programming | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.