TLOG-CLEAR Command

The TLOG-CLEAR command clears the update logging queue without dequeueing entries.

Format

TLOG-CLEAR [(options)]

Parameter(s)

options

The following options are supported:

D

Causes transactions to be dequeued immediately after they are queued.

O

Logs off the transaction logger when it is finished dequeueing transactions to backup medium.

S

Suppresses session-number and transaction-number in the in process output display.

Description

Using the TLOG-CLEAR command permits all update logging queue entries to be cleared without outputting the entries to a selected device. All transaction logging overflow will be returned as the entries are cleared.

Update logging must be turned off before attempting to clear the update logging queue. If an attempt is made to clear the queue while update logging is on, this error message will display:

[374]  ILLEGAL OPERATION WHILE ULOG IS ON

The user issuing TLOG-CLEAR will be treated as the transaction logging process for the duration of the clearing session. This user is not required to be attached to an output device. If another user issues the TLOG-CLEAR command or the TLOG-DQ command, they will be prevented from running as the transaction logging process and this error message will display:

[384]   PROCESS "X" IS ALREADY DESIGNATED AS THE TRANSACTION PROCESSOR!

where X is the process number of the user issuing the TLOG-CLEAR command.

Once the update logging queue is empty, the process will exit to TCL automatically. The TLOG control commands remain operational for cases where it may be required to terminate a clearing session before the queue is empty.