Suspending and Resuming the Transaction Logging Process

There may be times when it is necessary to suspend the transaction logging process temporarily without stopping the transaction logging process. For instance, it may be necessary to assign the backup medium temporarily to another process then return it to the transaction logging process later. To terminate a transaction logging session without stopping the transaction logging process, use the TLOG-SUSPEND command. Use TLOG-RESUME to restart the session.

When using TLOG-SUSPEND, transaction logging stops, but control is not returned to TCL, nor is the transaction logging process terminated. The transaction logger finishes processing the current transaction, output is terminated, the END OF SESSION message displays, and an End-Of-File mark is written to the backup medium. The W option can also be used with TLOG-SUSPEND.

Remove the tape or diskette from the device drive. When resuming transaction logging, do not attempt to use the same backup medium, because TLOG-RESUME starts a new transaction logging session. Instead, load a new one in the drive.

TLOG-RESUME restarts the suspended transaction logging process and initiates a new transaction logging session. The tape drive (or device drive) is attached and a new Start-of-Session message is written.

See Also

The Transaction Logger

Starting the Transaction Logger

Stopping the Transaction Logger

Monitoring Transaction Logging

Transaction Restoration

Preventing Loss of Transactions

Transaction Windowing