Supporting real-time statistics in BMC AMI Copy
BMC AMI Copy
updates the Db2 real-time statistics tables, SYSIBM.TABLESPACESTATS and SYSIBM.INDEXSPACESTATS.
The following table provides the columns in SYSIBM.TABLESPACESTATS and SYSIBM.INDEXSPACESTATS that BMC AMI Copy updates.
Columns updated by BMC AMI Copy for real-time statistics
Column name | Updated value |
---|---|
UPDATESTATSTIME | Timestamp of update |
COPYLASTTIME | Timestamp |
COPYUPDATEDPAGES | 0 |
COPYCHANGES | 0 |
COPYUPDATELRSN | Null |
COPYUPDATETIME | Null |
For table spaces, BMC AMI Copy resets the COPYUPDATEDPAGES column every time a copy is made and HPGCLRSN is updated, except for CUMULATIVE YES incremental copies. For CUMULATIVE YES incremental copies, COPYUPDATEDPAGES represents the total number of pages updated since the last full copy. For index spaces, BMC AMI Copy resets the COPYUPDATEDPAGES column every time a full copy is made and HPGCLRSN is updated. HPGCLRSN is updated for all spaces when RESETMOD YES is specified. HPGCLRSN is only updated for large spaces when RESETMOD NO is specified.
BMC AMI Copy does not update the statistics of the real-time statistics tables when you are using SHRLEVEL REFERENCE to make the copy of the statistics tables.
Support for real-time statistics in BMC AMI Copy does not include support by the BMC AMI Copy MODIFY command.