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

396 Chapter8
Using the Database Utilities
>FILE
transactions, use DBEND mode 2 for immediate posting of the log system's
memory buffer.
fmode can take one of the following values:
0 No records associated with failed transactions are copied.
(Default value.)
1 Log records corresponding to the first unsuccessfully
recovered call to DBBEGIN of each transaction block are
copied.
2 The sequence of log records associated with the first
unsuccessfully recovered transaction of each transaction
block are copied.
3 All log records that could not be recovered are copied.
Discussion
The >FILE command copies qualified DBOPEN and DBCLOSE log records to each user's
recovery file. See "File Command" in chapter 7 for a full discussion qualifying the return of
log records. The optional rmode and fmode parameters specify the copies of additional log
records.
Once the >FILE command is entered, the user recovery file is opened and any existing
records are deleted. If the specified user file does not exist, an error is reported unless the
file references the logon group and account, in which case the file is automatically created.
The state of a log record (either recovered or not) is indicated by a flag set by DBRECOV in
the record itself. MPE/iX WRITELOG records returned by DBRECOV are variable length,
because DBRECOV eliminates the continuation records by appending their data to the
original WRITELOG record. Consequently, DBRECOV will create recovery files with a variable
length record format. However, fixed length records are permitted if the file already exists
or an MPE/iX FILE command is in effect. If a log record exceeds the record size of a user
file with fixed length records, the log record is truncated and an error message is printed.
Example
>FILE PART/MGR,MARY/RYAN.MKTG,0,3
PART is the filename. MGR is the lockword. MARY is the username and RYAN is the
identifier. MKTG is the account. The 0 is the rmode, and the 3 is the fmode.
The >FILE command is repeated for each recovery file to be created and for each user
whose records will be copied to a user recovery file.
Text Reference
Chapter 7