Starting Transaction Logging

This procedure starts up logging on a database and should not need to be repeated while the database is operating normally. It will only be necessary to repeat this procedure if for some reason it has been necessary to stop Transaction Logging, for example, to recover the database.

Before Transaction Logging is started on a database, a clean log is created in the clean log sub-directory associated with the database.

Note

  • For Shadow Database and FailSafe configurations, this procedure must be carried out on the live and primary databases, respectively.
  • Ensure all users are logged off the database before carrying out this procedure.
  • Before starting up logging, ensure that a backup tape exists which reflects the current state of the database. This is needed as a base for restoring future logged updates in the event of a failure. If such a tape does not exist, use option 7 on the Routine Maintenance menu to save the database and create a backup before starting Transaction Logging.

Procedure

  1. Select option 2 on the Configuration and Setup menu. A message is displayed describing the purpose of the procedure; enter y  to continue.

  2. You are then asked to specify the name of the clean log to start logging to. A menu similar to the following is displayed:

    Start logging to:
1.  Another Clean Log for today (CLOG990731-01)
2.  Next day's Clean Log (CLOG990801-01)
3.  Clean Log for named day or date
4.  A named Clean Log
Enter option (1-4) : _

    Select the option you require (see Clean Log Menu Options).

    Note

    It is recommended that you use the standard clean log naming conventions (for example, CLOGyymmdd-nn) when selecting a clean log name.

  3. You are then asked to confirm your selection and ensure that all users are logged off the database. If you are sure that all users are logged off, enter y  to start Transaction Logging. The specified clean log is then created and Transaction Logging is started.

    If you try to start logging while users are still logged on, the following message will be displayed:

    [CTL2205] This command may only be used when no other users are logged on.  There are in fact n other users logged on.  Use LISTU to see logged on users.
Do you want to log off all users from the database
and try again (y/n/q) ? :

    Entering y  will enforce a logoff of all users from the database; then repeat step 3. Alternatively, you can enter q  to return to the host command prompt and then send a message requesting them to log off to all database users before repeating this procedure.