TurboIMAGE/XL Database Management System Reference Manual MPE/iX V6.5 (30391-90011)

Chapter 7 327
Logging and Recovery
Logging Preparation
:LISTLOG
NO LOGGING IDENTIFIERS ASSIGNED (CIWARN 1231)
:GETLOG ORDERLOG;LOG=ORDER001,DISC;PASS=PASSLOG
:LISTLOG
LOGID CREATOR CHANGE AUTO CURRENT LOG FILE
ORDERLOG BEA.MKTG YES NO ORDER001.MKTG.SYS
:ALTLOG ORDERLOG;AUTO
:LISTLOG
LOGID CREATOR CHANGE AUTO CURRENT LOG FILE
ORDERLOG BEA.MKTG YES YES ORDER001.MKTG.SYS
Because NOAUTO is assumed by default in the GETLOG command, the disk log file is closed
when it becomes full and logging is shut down unless you manually issue a CHANGELOG
command. When the NOAUTO default is used, you need to verify the capacity of the log
file on a regular basis and issue a CHANGELOG command when necessary. When the AUTO
option is specified as in the ALTLOG command above, logging automatically initiates a
CHANGELOG command when the current log file becomes full.
In the example above, the AUTO option has been specified. Here is what happens when log
file ORDER001 becomes full. Logging initiates a CHANGELOG command causing the log
records to be written to ORDER002, the next log file in the sequence. As each log file
becomes full, logging initiates additional CHANGELOG commands creating log files
automatically until log file ORDER999 becomes full. At this point, the log file name is reset
to ORDER001 and logging continues automatically.
If you use TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or
ONLINE=END) to backup your database and DBRECOV to perform roll-forward recovery,
you must take precautions to synchronize the proper log files with the stored database.
Refer to step 8 for more information.
If you specified the AUTO option as in the preceding example, and you need to restart
logging at logfile001, you can issue an ALTLOG command as shown in the following
example:
:LISTLOG
LOGID CREATOR CHANGE AUTO CURRENT LOG FILE
ORDERLOG BEA.MKTG YES YES ORDER026.MKTG.SYS
:ALTLOG ORDERLOG;LOG=ORDER001,DISC
Step 6--Setting the Log Identifier
The two previous steps were executed using MPE/iX commands. At this point, you must
notify the MPE/iX user logging system of the TurboIMAGE/XL logging intention by setting
the log identifier and logid password into the database root file, using the DBUTIL >>SET
command, as shown in the example below: