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.