monDBRecovery

Applies to 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