Real-time statistics in BMC AMI Recover
BMC AMI Recover enables real-time statistics as follows:
- BMC AMI Recover resets the COPY-related counters, even during recovery to current, if it is making an output image copy during a recovery.
- BMC AMI Recover does not update any real-time statistics during an OUTCOPY ONLY execution.
The following table provides the columns in SYSIBM.SYSTABLESPACESTATS1 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 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, as well as 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 |
Related topic