Logging Status [ TurboIMAGE/XL Database Management System Reference Manual ] MPE/iX 5.5 Documentation
TurboIMAGE/XL Database Management System Reference Manual
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.[REV BEG] 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.[REV END] 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.
[REV BEG]
: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.
Database has at least one indexed dataset.
BTREEMODE1 is off, wildcard = "@".
Logid: ORDERLOG is valid.
password is correct.
XM log set : default XM user log set
for volume set MPEXL_SYSTEM_VOLUME_SET
XM log set type : circular
XM log set size : 32 megabytes
The language is 0 - NATIVE-3000.
Buffer specifications:
8(1/2),9(3/4),10(5/6),11(7/8),12(9/10),13(11/12),14(13/14),
15(15/16),16(17/18),17(19/120)
No other users are accessing the database.
[REV END]
NOTE The displayed buffer specifications are the default TurboIMAGE/V
values. These specifications or any new ones that you set are
displayed for MPE V compatibility, but they are not used by
TurboIMAGE/XL which uses a large default value. See chapter 8 or
appendix H for more information.
MPE/iX 5.5 Documentation