Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Copy for Db2 13.1.

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.


 

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