Supporting real-time statistics in BMC AMI Copy


Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

updates.

Columns updated by

Some content is unavailable due to permissions.

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,

Some content is unavailable due to permissions.

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,

Some content is unavailable due to permissions.

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.

Some content is unavailable due to permissions.

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

Some content is unavailable due to permissions.

does not include support by the

Some content is unavailable due to permissions.

MODIFY command.


 

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