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

668 AppendixG
Recovery and Logging Quick Reference
Sample Job Streams
Figure G-4. Sample Job Stream for Starting Logging Cycle
:JOB MGR.DATAMGT
:GETLOG ORDERLOG;LOG=ORDER001,DISC;AUTO Acquire log identifier. AUTO is
optional.
:BUILD ORDER001;DISC=200000,20,7;CODE=LOG Build new log file.
:RUN DBUTIL.PUB.SYS
SET ORDERS LOGID=ORDERLOG Response to logid password prompt.
ENABLE ORDERS FOR LOGGING Set the database flags in the root file
DISABLE ORDERS FOR ACCESS
ENABLE ORDERS FOR RECOVERY
ENABLE ORDERS FOR MUSTRECOVER
EXIT
:FILE ORDERBK1;DEV=TAPE Mount the tape.
:STORE ORDERS;*ORDERBK1;ONLINE=START Store the database.
:LOG ORDERLOG,START Start the logging process; logid is
ORDERLOG.
:RUN DBUTIL.PUB.SYS
ENABLE ORDERS FOR ACCESS Set the database flags
DISABLE ORDERS FOR RECOVERY in the root file.
ENABLE ORDERS FOR MUSTRECOVER
EXIT
:EOJ
The job stream above builds a new log file. In this case, the log file resides on disk and sets
the database flags. Note that because no logid password was specified in the GETLOG
command, a blank line is left as a response to the password prompt. A backup copy of the
database is made (this sets the date and time the copy was made in the root file), logging is
initiated with START, the database is enabled for access, and recovery is disabled. The
database is ready for access.
If you want to make another backup to keep recovery time short, you do not need to stop
logging. Also the database could be open for access. You can backup the database using
TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or ONLINE=END option)
and optionally store and purge the log files (if AUTO option was used with GETLOG)
preceding the log file which was in use at the time of the backup. If you do not purge the
preceding log files, you can continue until log file ORDER999. After that you will get an
error when attempting to write to LOG0001.