TL-SET-LOG-STATUS Command

Specifies which files on a Transaction Logging database should be logged.

On a Transaction Logging database that is configured for Rapid Recovery, you can define a file as 'Logged', 'Not Logged' or 'Recoverable'. Refer to Recoverable Files.

When you first configure a database for Transaction Logging, all files/data sections are set to be logged. You can then use TL-SET-LOG-STATUS to change the logging status of any files that you do not want to be logged.

Command Class

Catalogued DataBasic program.

Syntax

TL-SET-LOG-STATUS

Restrictions

Use is restricted to SYSMAN. Options 4 and 5 can only be executed when Transaction Logging is active.

Menu Options

                                 SET-LOG-STATUS
[0]   Exit
[1]   All system and user accounts
[2]   All system accounts
[3]   All user accounts
[4]   Selected accounts
[5]   Selected files
Enter option:

[0] Exits from TL-SET-LOG-STATUS to the TCL prompt.

[1] Allows you to define the logging status of some or all data sections in all accounts on your database (except those with compulsory logging status). You can define whether they are to be all Logged, all Not Logged, Selectively Logged, or Recoverable.

[2] Allows you to define the logging status of some or all system files on your database (except those with compulsory logging status). You can define whether they are to be all Logged, all Not Logged, Selectively Logged, or Recoverable.

[3] Allows you to define the logging status of some or all data sections in all user accounts on your database (except those with compulsory logging status). You can define whether they are to be all Logged, all Not Logged, Selectively Logged, or Recoverable.

[4] Allows you to select a specific account and define the logging status of some or all data sections in it.

[5] Allows you to select an individual data section or system file and define its logging status as Logged, Not Logged, or Recoverable.

On selecting one of these options, a typical message prompt is:

Globally Log all data sections
Enter option (L,R,N,S) :

The options are:

L all specified files/data sections to be Logged, except for those with compulsory status Not Logged.

R all specified files/data sections to be Recoverable.

N no files/data sections to be logged, except for those with compulsory status Logged.

S specify the logging status of files/data sections individually, except for those preset to Compulsory Logged or Compulsory Not Logged.

When you enter S, further prompts are displayed, giving you the option to set the logging status of each individual file/data section as L(ogged), N(ot Logged) or R(ecoverable).

Q which displays the further prompt Quit? (Y,N). Enter Y to exit immediately, or N to return to the logging mode prompt.

Compulsory Logging Status

For some files the logging status is preset to 'Compulsory Logged' or 'Compulsory Unlogged', as appropriate, and cannot be changed using TL-SET-LOG-STATUS.

The SYSTEM dictionary is 'Compulsory Logged', as are all account master dictionaries. This ensures that each CREATE-FILE, DELETE-FILE or MOVE-FILE operation, where a D-pointer is placed in or removed from the Master Dictionary, is logged.

Also, certain files are defined as 'Compulsory Not Logged'. For these files, restoration of updates is unnecessary or may even be undesirable.

When you select menu options [1], [2] and [3] followed by the S option, accounts and files with 'Compulsory Logged' or 'Compulsory Not Logged' status are displayed, but scrolled by automatically. The scrolling stops at the next account or file for which the logging status must be selected.