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

402 Chapter8
Using the Database Utilities
>RUN
>RUN
Initiates recovery-process. The recovery system opens the log file and validates the log
identifier before roll-forward recovery or roll-back recovery begins.
Syntax
>RUN
Discussion
For recovery to succeed, the log file must be accessible to the database administrator. This
means that the database administrator must either be the creator of the log identifier used
to create the log file, or know the maintenance word and have system manager (SM) or
operator (OP) capability. If the database administrator does not have system manager
capability, and if the log file resides on disk in a group and account different from logon,
then the administrator must have read access to the log file according to MPE/iX file
security. File equations are permitted. However, the fully qualified file name of the
expected log file must be specified. If the log file resides on tape, the database
administrator must know the volume identifier, so that the operator can respond to the log
file tape mount request.
If recovery succeeds, tabulated information is displayed and the program is terminated. A
table of process statistics includes the number of DBPUT, DBDELETE, and DBUPDATE log
records processed and the total transactions for each process.
When using roll-forward recovery, an asterisk (*) may appear next to any process
indicating that either a DBCLOSE record is missing or some transactions may not have been
recovered. Therefore, no asterisk for a process in the table of process statistics indicates
that all transactions were recovered.
The same table information is displayed when using roll-back recovery; however, there is a
slight difference. The database table will list all incomplete transactions or DBPUT,
DBDELETE, and DBUPDATE log records that were "rolled-out." An asterisk (*) will appear
next to these processes.
A table of database statistics includes the same information totaled for each database. A
logging system table includes the log identifier, log file information, and recovery file
information if this facility is used. Refer to "Recovery Tables" in chapter 7 for more
information on Process, Database, Logging and Recovery Tables.