Two commands make it possible to examine the status of update logging: TLOG-STATUS and TLOG-MONITOR.
The TLOG-STATUS report shows the current status of both the update and the transaction loggers; the TLOG-MONITOR report shows a continuously updated status report of both loggers.
The TLOG-STATUS report looks like this:
============= TRANSACTION LOGGING STATUS ============== |
|||||
Current Number of QUEUE ENTRIES: |
|
250 |
|
||
Current Number of UNPROCESSED QUEUE ENTRIES: |
0 |
|
|||
Current GLOBAL TRANSACTION NUMBER: |
|
3156 |
|
||
Frames in use by TRANSACTION LOGGING: |
|
6 |
|
||
"UPDATE LOGGING" is: |
|
ACTIVE |
|
||
|
|
|
|
|
|
============"TRANSACTION LOGGING PROCESSOR" ============ |
|||||
Transaction Processor STATUS: |
|
|
INACTIVE |
||
|
|
|
|
|
|
|
SESSION NUMBER |
|
TRANSACTION NUMBER |
*- ENQUEUED AT -* DATE TIME |
|
|
------------- |
|
------------ |
------------- |
------------ |
"LATEST" |
1 |
END: |
3156 |
11/02/92 |
17:17:40 |
|
|
BEGIN: |
1 |
09/16/92 |
13:20:18 |
|
|
|
|
|
|
"PREVIOUS" |
0 |
END: |
|
|
|
|
|
BEGIN: |
|
|
|
=========================================================== |
|||||
The upper portion of this report, labelled TRANSACTION LOGGING STATUS, gives information about update logging. (Information in the lower portion has to do with transaction logging and is described in the following section).
The first line lists the total number of transactions in the update queue. The second line of the report lists the number of transactions in the queue that have not yet been dequeued by the transaction logger. This is followed by the Global Transaction Number (the number of the current, or most recent, transaction) and the number of frames used by transaction logging. The last line indicates whether update logging is currently enabled (ACTIVE) or disabled (INACTIVE).
TLOG-MONITOR can be used to continuously monitor the status of the update logger. It displays the same report as TLOG-STATUS, but is continuously updated. To specify the interval of time between updates of the status report, include the number of seconds in the TLOG-MONITOR statement.
To obtain a count of the number of update logging transactions waiting to be dequeued, use the COUNT-TRANS command.
The following display provides an example of the output from the COUNT-TRANS command:
>COUNT-TRANS Number of transactions in queue: 250 Number of unprocessed transactions in queue: 0 |
To see if update logging is currently active, use the WHAT command. An asterisk (*) is displayed after the current number of users (top line of the report) if logging is active.
Use the TLOG-BUFFERS command to monitor the amount of overflow in use by transaction buffers.
See Also