Real-time statistics in BMC AMI Recover
The following table provides the columns in SYSIBM.SYSTABLESPACESTATS and SYSIBM. SYSINDEXSPACESTATS that the BMC AMI Recover RECOVER command updates.
Column name | Updated value |
|---|---|
UPDATESTATSTIME | Timestamp of update |
COPYLASTTIME 1 | Timestamp |
COPYUPDATEDPAGES 1 | 0 |
COPYCHANGES 1 | 0 |
COPYUPDATELRSN 1 | Null |
COPYUPDATETIME 1 | Null |
1 This field is updated by the BMC AMI Recover RECOVER command only when an output image copy is made during a recovery. Because making an output image copy during recovery is not an option with the IBM Db2 RECOVER utility, the IBM Db2 RECOVER utility never updates these fields.
The IBM Db2 REBUILD utility updates some reorganization-related statistics in SYSIBM.INDEXSPACESTATS and the REBUILDLASTTIME column. The following table summarizes the support for updating these statistics when you use the BMC AMI Recover REBUILD command.
Column name | Updated value |
|---|---|
UPDATESTATSTIME | Timestamp of update |
REBUILDLASTTIME | Timestamp |
REORGINSERTS | 0 |
REORGDELETES | 0 |
REORGAPPENDINSERT | 0 |
REORGPSEUDODELETES | 0 |
REORGMASSDELETE | 0 |
REORGLEAFNEAR | 0 |
REORGLEAFFAR | 0 |
REORGNUMLEVELS | 0 |
REORGTOTALSPLITS (V13R1M501 catalog level) | 0 |
REORGSPLITTIME (V13R1M501 catalog level) | 0 |
REORGEXCSPLITS (V13R1M501 catalog level) | 0 |