HP 3000 Manuals

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