PRUNE Logfile Command Question

[bwmiller16]

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

[Pierre Saint-Jacques]

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

[fred.sobotka]

PRUNE LOGFILE PRIOR TO <logfilename> will actually delete logfiles.

Fred