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.

Related topics

Gathering-statistics-with-the-COPY-RUNSTATS-option

Statistics-collection

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.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*