This screen displays an estimate of the time it will take to roll
back a transaction, or to completely recover a failed process.
DISCLAIMER
The information provided in this screen is an estimate based
on previous process recovery operations and other factors
such as page contention and disk throughput.
Note that this information is an estimate only; the actual
process recovery duration may be more or less than described
on this screen.
Individual process failure recovery performance can vary
widely depending on many factors which cannot be accounted
for in the displayed estimate. These factors include lock
deadlock stalls, network delays, disk contention and many
other system factors such as lock remastering.
This screen displays the following fields:
o Process.ID - The process identifier of a process that has the
potential to roll back a transaction or require transaction
recovery in the event of process failure.
o RUJ.Sz - The number of blocks of RUJ information that have
been written by the process.
o Tx.Rollback - The estimate of the time it would require for
the process to roll back the transaction. Note that this is
different from the time it would take the DBR process to roll
back the transaction.
o DBR.Tx.Undo - The estimate of the time it would require for
the DBR process to undo the transaction. The DBR transaction
undo duration is typically less than it takes the process to
roll back the transaction, due to various optimizations and
simplifications in the DBR recovery algorithm.
o AIJ.Ckpt - If the fast commit feature is enabled, this is the
most recent checkpoint location in the AIJ journal for the
process.
o Pnd - If AIJ journaling is enabled, this is the number of
blocks of AIJ information that have been submitted, but not
yet written to the AIJ journal.
o DBR.Tx.Redo - If the fast commit feature is enabled, this is
the estimate of the time it would take the DBR process to redo
the previously committed transactions of the failed process to
the database.
o DB.Freeze.Tm - The estimate of the total time the database
would be frozen if the current process were to prematurely
terminate.
You can use the Config menu option to configure the Transaction
Recovery Duration Estimate screen. Select this option, by
typing the letter C, to display the configuration submenu. The
configuration submenu provides the following options:
o Unsorted Display
o Sort by oldest transaction rollback
o Sort by oldest DBR undo
o Sort by oldest DBR redo
o Sort by oldest database freeze
You can examine the past history of recovery operations by
issuing the RMU Dump Header command and reviewing the Database
Recovery section.
The Transaction Recovery Duration Estimate screen is not recorded
in the binary output file produced using the Output qualifier.
Consequently, this screen is not available when you replay a
binary file using the Input qualifier.