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

Chapter 8 395
Using the Database Utilities
>FILE
>FILE
Routes log records to individual user files, providing the application program with
information about the outcome of recovery; provides a useful tool for auditing previous
entries. One file for each user can be opened simultaneously by re-entering the >FILE
command once for each user, or all users can be directed to a single file.
Syntax
>FILE fileref , userref [, rmode , fmode ]
Parameters
fileref is an MPE/iX file reference: filename [/lockword]
[.group[.
account ``]]. This is the destination file for each user's log
records.
userref is a user reference, specifying which user's log records to copy to this user
recovery file. The format is: username [/ident].account.
The optional identifier, which also must be passed to DBOPEN as part of the
password parameter, uniquely identifies persons using the same logon.
rmode is for roll-forward recovery only. Directs recovery system to copy log
records associated with transactions successfully recovered. rmode can
take one of the following values:
0 No records associated with recovered transactions are
copied to the user file. (Default value.)
1 Log records corresponding to the last successfully
recovered call to DBEND of each transaction block are
copied.
2 The sequence of log records associated with the last
successfully recovered transaction of each transaction
block are copied. In addition, all DBMEMO log records which
immediately follow this transaction are copied.
3 All log records associated with successfully recovered
transactions for each transaction block are copied.
fmode directs recovery system to copy log records associated with transactions
that failed to recover. Used with both roll-forward and roll-back recovery.
CAUTION The (roll-forward) recovery system cannot guarantee that all records
associated with unsuccessfully recovered transactions can be copied, because
log records which reside in the log system's memory buffers are lost in the
event of a system failure. When accessing the database for critical