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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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)
