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

670 AppendixG
Recovery and Logging Quick Reference
Sample Job Streams
Storing and purging the damaged database prior to restoring it is optional. After recovery
has completed, logging can either be restarted (with the current log file) or the log file can
be purged and a new log file built.
The next example in Figure G-7. uses roll-back recovery. A backup of the database using
DBSTORE or TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or
ONLINE=END option) can be done at this time; however, this is optional. The following
command in DBUTIL will show if the flags for recovery and access are correctly set:
>>SHOW
database name FLAGS
Figure G-7. Sample Job Stream for Roll-Back Recovery
:JOB MGR.DATAMGT
:RUN DBUTIL.PUB.SYS
DISABLE ORDERS FOR ACCESS Set the flags in the database
ENABLE ORDERS FOR RECOVERY root file.
EXIT
A backup of the database at this time is recommended.
:RUN DBRECOV.PUB.SYS
CONTROL NOSTORE Allows recovery to proceed whether or not the
DBSTORE flag is set.
ROLLBACK ORDERS Use roll-back recovery on database ORDERS.
RUN
EXIT
:LOG ORDERLOG,RESTART Restart the current log file and set
:RUN DBUTIL.PUB.SYS the database flags.
ENABLE ORDERS FOR ACCESS
DISABLE ORDERS FOR RECOVERY
EXIT
:EOJ
After recovery has completed, logging can either be restarted (from the current log file) or
the log file can be purged and a new log file built.