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

392 Chapter8
Using the Database Utilities
>CONTROL
STOPTIME= mm/dd/yy hh:mm causes DBRECOV to impose an artificial end-of-file when the
specified log record time stamp (supplied by MPE/iX) is encountered. All
log records with subsequent time stamps will not be recovered. This
feature is useful in the event of a user program failure; the database can
be recovered to a point in time before the suspect program began
execution.
Default condition: Log record time stamps are not checked by DBRECOV.
ERRORS=
nnnn controls the maximum number of non-fatal errors allowed during a job
(batch) execution. Should
nnnn be exceeded, DBRECOV terminates and sets
the job control word to −1 to indicate an error. However, this check does not
take effect until all commands have been parsed and processed.
Default condition: ERRORS=0 for batch jobs and ERRORS=30,000 for
interactive sessions. The number of errors allowed can be altered by
entering a revised ERRORS parameter.
STATS is used to obtain information from the log file without actually recovering a
database. Requires use of a file equation to specify the log file. For
example:
:FILE LOGFILE=ORDER001;DEV=TAPE;LABEL=LOG001
:RUN DBRECOV.PUB.SYS
>CONTROL STATS
>RUN
This example shows the log file ORDER001 residing on tape and belonging
to an expandable file set (refer to the GETLOG command with AUTO option
in the MPE/iX Commands Reference Manual. The recovery system
responds by printing tabulated information from log files, similar to tables
printed after a database recovery. However, no databases are actually
opened or recovered.
[NOSTATS] negates the STATS option; tabulated information is not printed unless a
database is recovered.
[MODEX] causes recovery toexecute in exclusive (deferred) mode. No other users can
access the database concurrent with recovery.
MODE4 recovery proceeds in DBOPEN mode 4, allowing users in mode 6 to access
(read) the database while recovery is in process.
EOF=
nnnn causes DBRECOV to impose an artificial end-of-log file when the specified
log record number is encountered. All log records with subsequent
numbers will not be recovered. This feature is useful in the event of a user
program failure; the database can be recovered up to a record number
preceding the suspect records. While logging is in progress, the MPE/iX
SHOWLOGSTATUS command can be used to determine the current number
of records logged before initiating a questionable program.
Default condition: All log records are recovered by DBRECOV.
[MDBX] causes DBRECOV to treat multiple database transactions contained in the