monDBRecovery

Description

(Cluster environments only) Contains rows from all instances in the cluster and contains rows for every database that contributes to recovery.

You need not enable any configuration parameters for this monitoring table to collect data.

Columns

The columns for monDBRecovery are:

Column name	Type	Description
DBID	int4	Unique identifier for the database
InstanceID	int1	Instance that performed the recovery (applicable only to the Cluster Edition)
MaxOpenXacts	int4	Maximum number of open transactions seen durning recovery
MaxPFTSEntries	int4	Maximum number of PFTS entries seen during recovery
Buckets	int4	Number of buckets
LogBTotPages	int4	Number of `log scan getpage` requests during the log boundary determination pass.
LogBTotAPFWaited	int4	Number of `log scan getpage` requests that found the I/O in progress during the log boundary determination pass
LogBTotIO	int4	Number of `log scan getpage` requests with physical I/O during the log boundary determination pass
AnlTotRec	int4	Total number of log records to be scanned by the recovery process
AnlPhase1Recs	int4	Number of log records in phase 1 recovery process
AnlPhase1RedoRecs	int4	Number of log records to redo in phase 1 recovery
AnlPhase2Recs	int4	Number of log records in phase 2 recovery process
AnlPhase2RedoRecs	int4	Number of log records to redo in phase 2 recovery
AnlTotPages	int4	Number of `log scan getpage` requests during the analysis process
AnlTotAPFWaited	int4	Number of `log scan getpage` requests that found the I/O in progress during the analysis pass
AnlTotIO	int4	Number of `log scan getpage` requests with physical I/O during the analysis pass
RedoOps	int4	Total operations considered for redo
RedoOpsNotRedonePFTS	int4	Operations that did not need redo (PFTS check)
RedoOpsRedonePFTS	int4	Operations that might need redo (PFTS check)
RedoOpsRedoneTS	int4	Operations that needed redo (timestamp check)
RedoOpsNotRedoneTS	int4	Operations that did not need redo (timestamp check)
RedoLogTotPages	int4	Number of `log scan getpage` requests during the redo pass
RedoLogTotAPFWaited	int4	Number of `log scan getpage` requests that found the I/O in progress during the redo pass
RedoLogTotIO	int4	Number of `log scan getpage` requests with physical I/O during the redo pass
RedoRecTotPage	int4	Number of `recovery pages getpage` requests during the redo pass
RedoRecTotAPFWaited	int4	Number of `recovery pages getpage` requests that found the I/O in progress during the redo pass
RedoRecTotIO	int4	Number of `recovery pages getpage` requests with physical I/O in progress during the redo pass
UndoRecsUndone	int4	Number of log records udone
UndoLogTotPages	int4	Number of `log scan getpage` requests during the undo pass
UndoLogTotAPFWaited	int4	Number of `log scan getpage` requests that found the I/O in progress during the undo pass
UndoLogTotIO	int4	Number of `log scan getpage` requests with physical I/O during the undo pass
UndoRecTotPages	int4	Number of `recovery pages getpage` requests during the undo pass
UndoRecTotAPFWaited	int4	Number of `recovery pages getpage` requests that found the I/O in progress during the undo pass
UndoRedTotIO	int4	Number of `recovery pages getpage` requests with physical I/O during the undo pass
DBName	varchar(30)	Name of the database
FailedInstanceID	int1	ID of the failed instance (applicable only to the Cluster Edition)
Command	varchar(30)	One of load database, load transaction, online database, mount database, and start or failover commands executed by the process that is running recovery
RecType	varchar(30)	Type of recovery – one of server start, load database, load transaction, or node failover
LobBStartTime	datetime(8)	Start time for the log boundaries determination pass
LogBEndTime	datetime(8)	End time for the log boundaries determination pass
AnlStartTime	datetime(8)	Start time of analysis pass
AnlEndTime	datetime(8)	End time of the analysis pass
RedoStartTime	datetime(8)	Start time of the redo pass
RedoEndTime	datetime(8)	End time of the redo pass
UndoStartTime	datetime(8)	Start time of the undo pass
UndoEndTime	datetime(8)	End time of the undo pass