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

Chapter 7 335
Logging and Recovery
Logging Status
Logging Status
The DBUTIL >>SHOW command can be used to display the log identifier and the status of
the flags for access, recovery, and logging. If TurboSTORE/iX 7x24 True-Online Backup
(with ONLINE=START or ONLINE=END option) is used to back up the database, it can
also display the date, time, and the logfile used during backup. The following example
illustrates roll-forward recovery and the commands used to set the logid and flags into the
database, as presented in this chapter. If the steps discussed earlier in this chapter have
been followed, the database can be stored. The password (denoted by *******) does not
appear on the screen.
:RUN DBUTIL.PUB.SYS
.
.
.
>>SET ORDERS LOGID=ORDERLOG
PASSWORD *******
LOGID: ORDERLOG IS VALID
PASSWORD IS CORRECT
>>DISABLE ORDERS FOR ACCESS
Access is disabled
>>ENABLE ORDERS FOR RECOVERY, LOGGING, MUSTRECOVER
WARNING: Database modified and not DBSTOREd
Recovery is enabled
Logging is enabled
Mustrecover is enabled
>>SHOW ORDERS ALL
For database ORDERS
Maintenance word is not present.
Access is disabled.
Autodefer is disabled.
Dumping is disabled.
Rollback recovery is disabled.
Recovery is enabled.
ILR is disabled.
Mustrecover is enabled.
Logging is enabled.
Prefetch is disabled.
Indexing is disabled.
HWMPUT is disabled.
Restart is disabled.
Database last stored using True-Online Backup and
Thu, JAN 18, 1996, 3:39 PM
Database has been modified since last store date.
Shadowing is disabled.
Subsystem access is READ/WRITE.
CIUPDATE is allowed.
Dynamic capacity expansion is not used.