iX V6.5 (30391-90011)

362 Chapter7

Logging and Recovery

Recovery Tables

account, program name, and transaction statistics. This table contains one

entry for each process that logged transactions to the log ﬁle. An asterisk

appears for any process that issued a DBOPEN without a corresponding

DBCLOSE before the system failure. In roll-forward recovery, the columns

"TRANS, PUTS, DELS, UPS" indicate the number of transactions

recovered. In roll-back recovery, these columns and numbers indicate the

number of transactions rolled out.

2 In the DATABASE STATISTICS table, the total number of transactions is

given for each database recovered. The columns "TRANS, PUTS,

DELETES, UPDATES" indicate the number of transactions recovered in

roll-forward recovery, or rolled back if using roll-back recovery.

NOTE

If you need this table, along with statistics, without actually performing the

recovery, use >CONTROL STATS to display this information. The >PRINT

DBTABLE command also displays this table, but does not include the statistics;

use this command if you only need to list the names of the databases speciﬁed

with >RECOVER commands.

3 The LOGGING SYSTEM table should have only one entry, the log

identiﬁer for the log ﬁle that was accessed by the recovery system. The

creator is the user who created the log identiﬁer with the MPE/iX GETLOG

command. The number of records processed is usually greater than the

number of transactions given in the other tables because some

transactions require more than one log record, and each log ﬁle contains

header and trailer records.

4 The RECOVERY SYSTEM table references the ﬁle to which the records

were returned, the user name and identiﬁer, and the rmode and fmode

parameters speciﬁed in the MPE/iX FILE commands. Note that all of these

tables can be returned without recovering a database by using the

>CONTROL STATS option when running the recovery program. Roll-back

recovery ignores the rmode parameter.