I cannot caution strongly enough against running undocumented commands,
especially when you are not familiar with what they do.

To clear the recovery log, if you are in roll-forward mode, you need to
back up the database. A full backup is not required.

If the recovery log is not running in roll-forward mode, then it clears
itself as outstanding transactions are completed.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/15/2004
12:15:36:

> The TSM server has an undocumented command from what I understand
called:
> "chkpt" or "ckpt". I issue it and it executes without an error message
> and nothing in the actlog. Anyone have any idea what that command does?
I
> know what a checkpoint does in Oracle. Knowing that I expected
> that the recovery log would clear once I did it: "q log". It didn't. Any
> ideas? While on the same subject, anyone have any undocumented ways, or
> ideas
> how to empty a recovery log without running a ful tsm database backup?
> Thanks!
>
> --Justin Richard Bleistein
> Unix/TSM Systems Administrator (Sungard Availability Services)