Show Logging Status Option

You can always check on the status of the logging subsystem on the database by using tlmenu. This is done by entering S or s at the main menu prompt, or at any of the four sub-menu prompts. On entering S or s the following message prompt is displayed:

This option continually shows the status of 
Transaction Handling/Logging, Rapid Recovery, Shadow or FailSafe.
To exit from this option, hit any key.
Hit return to continue:

Pressing RETURN displays a status report similar to that shown below.

Transaction Logging Status for database at 20:05:01 on 31 JUL 1999
Status  ACTIVE  
Clean Log file CLOG3
Recovery file   CLOG2
Raw log items waiting   0
Last Clean log image    6
Clean log in use        560,253
Transactions open       2
Database Recovery mode  FULL RECOVERY
Time of last status change      11:41 29 JUL 1999
Size of raw log 1,994,624 bytes
Maximum raw log usage   16%
Raw log usage   6%
Clean Log Usage 94%
Post processor status   PRESENT
FailSafe configured as  PRIMARY (FailSafe Only)
FailSafe status ACTIVE (FailSafe Only)

The display shown above is refreshed at regular intervals. Just press any key to continue with tlmenu.

The status information given on each report line is:

Status Current state of the logging. This may be one of the following:

ACTIVE In progress, initiated by TL-START.

INACTIVE Supported, but not in progress.

SWITCH REQUESTED
A switch to a new clean log has been requested, but not yet actioned.

SWITCH IN PROGRESS
In the process of changing to a new clean log. It will remain in this state until the old clean log is no longer required.

STOP IN PROGRESS
Writing of updates to raw log is stopped, but outstanding updates are still being flushed to the clean log.

STOPPED Inactive, but still maintaining images in the raw log until all outstanding updates have been flushed from the host buffers to the clean log.

Clean log file Name of the clean log to which transactions are currently being logged.

Recovery file Name of the previous clean log retained while in a state of switching or switched.

Raw log items waiting
The number of update records present in the raw log.

Clean log in use
The number of bytes currently stored in the clean log.

Transactions open
The number of transactions which are still active and open on the database.

Database recovery mode
The recovery mode currently supported. The mode can be:

NONE Neither Transaction Logging nor Rapid Recovery is enabled.

RECOVER Rapid Recovery only is enabled.

FULL Transaction Logging only is enabled.

QUICK Transaction Logging and Rapid Recovery are enabled

Time of last status change
The date and time when logging status was last changed.

Size of raw log The size of the raw log in bytes.

Maximum raw log usage
The maximum proportion of the raw log filled during the period of its use.

Raw log usage The proportion of the raw log currently filled with images.

Clean Log Usage The proportion of the clean log partition in use.

Post processor status
Indicates the presence or absence of the post processor.