HP 3000 Manuals HP 3000 Manuals
Recovery Tables
The first three of the following four tables are displayed, along with
statistics, by every execution of the recovery system. The last table is
displayed only if the user recovery file feature is used.
LOGFILE PROCESS STARTED ON MON, AUG 14, 1989, 5:48 PM
LOGFILE PROCESS TERMINATED ON MON, AUG 14, 1989, 5:49 PM
************************************************************************
* 1 PROCESS STATISTICS *
* *
*LOG# TIME NAME ACCOUNT PROGRAM DATABASE TRANS PUTS DELS UPS *
*---- ----- ---- ------- ------- --------- ----- ---- ---- --- *
* 1.1 15.45 TST MKTG INVENTRY ORDERS 145 145 0 0 *
* 2.1 15.47 TST MKTG ORDENTRY ORDERS 431 431 0 0 *
************************************************************************
************************************************************************
* 2 DATABASE STATISTICS *
* *
* NAME GROUP ACCOUNT OPENS TRANS PUTS DELETES UPDATES *
* ------ ----- ------- ----- ----- ---- ------- ------- *
* ORDERS TST MKTG 2 576 576 0 0 *
************************************************************************
************************************************************************
* 3 LOGGING SYSTEM *
* *
* ---CREATOR---- RECORDS DEV --------LOGFILE-------- *
* LOGID NAME ACCOUNT PROCESSED TYPE NAME GROUP ACCOUNT *
* ----- ---- ------- --------- ---- ---- ----- ------- *
* ORDERLOG TST MKTG 640 DISC ORDER001 TST MKTG *
************************************************************************
************************************************************************
* 4 RECOVERY SYSTEM *
* *
* FILE REFERENCE USER IDENT RMODE FMODE *
* -------------------- ------------- ----- ----- ----- *
* PART1 SYS MKTG TST MKTG P1D1 1 1 *
* PART2 SYS MKTG TST MKTG P1D2 1 1 *
* PART3 SYS MKTG TST MKTG P1D3 1 1 *
************************************************************************
END OF PROGRAM
The tables provide the following information:
1 The PROCESS STATISTICS table lists the logging user process number
assigned to each process by the OPENLOG intrinsic, the logon name and
account, program name, and transaction statistics. This table
contains one entry for each process that logged transactions to the
log file. 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 specified with
>RECOVER commands.
____________________________________________________________________
3 The LOGGING SYSTEM table should have only one entry, the log
identifier for the log file that was accessed by the recovery system.
The creator is the user who created the log identifier 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 file contains header and trailer records.
4 The RECOVERY SYSTEM table references the file to which the records
were returned, the user name and identifier, and the rmode and fmode
parameters specified 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.