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
Catalogued DataBasic program.
TL-SET-LOG-STATUS
Use is restricted to SYSMAN. Options 4 and 5 can only be executed when Transaction Logging is active.
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
[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.
For some files the logging status is preset to 'Compulsory
Logged' or 'Compulsory Unlogged', as appropriate, and cannot be changed using
The SYSTEM dictionary is 'Compulsory Logged', as are all
account master dictionaries. This ensures that each
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.