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

PRUNE Logfile Command Question

P: n/a
Guys -

Does the PRUNE logfile command do anything other than just do a simple
delete of the files? Or is there more to it internally in DB2?

Thanks in Advance,

-B

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
AFAIK, the prune command just cleans up your history file for all entries
equal to or prior to the timestamp specified.
It will clean all references to objects that are note involved with the
NUM_BACKUPS (default 12) specified.<
If you use the WITH FORCE option, it prunes all entries from that timestamp
without regard.

It does not touch any backup image nor does it touch logs (for all it knows,
they could be in an archive not accessible to the prune command).
It just "identifies" these entries in the recovery history as Active,
Inactive or Expired.

HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
<bw********@yahoo.com> a écrit dans le message de news:
11*********************@g44g2000cwa.googlegroups.c om...
Guys -

Does the PRUNE logfile command do anything other than just do a simple
delete of the files? Or is there more to it internally in DB2?

Thanks in Advance,

-B


Nov 12 '05 #2

P: n/a
PRUNE LOGFILE PRIOR TO <logfilename> will actually delete logfiles.

Fred

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.