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

Appendix G 667
Recovery and Logging Quick Reference
Sample Job Streams
Figure G-3. 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 DBSTORE 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.
FILE PART1,SYS/P1D1.MKTG,0,3 The FILE command is used to route log
FILE PART2,SYS/P1D1.MKTG,0,3 records to individual user files.
FILE PART3,SYS/P1D1.MKTG,0,3
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.
The following job stream shows how you can start a new log cycle for roll-forward recovery
using TurboSTORE/iX 7x24 True-Online Backup (with ONLINE=START or ONLINE=END
option) to backup the database. If using roll-back recovery, replace the line >>ENABLE
ORDERS FOR LOGGING with >>ENABLE ORDERS FOR ROLLBACK. This enables the database
for logging and for roll-back recovery.