Space announcement

   

This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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 a 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

COPYLASTTIME1

Timestamp

COPYUPDATEDPAGES1

0

COPYCHANGES1

0

COPYUPDATELRSN1

Null

COPYUPDATETIME1

Null

1 This field is updated by the BMC AMI Recover RECOVER command only when an output image copy is made during a 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


Was this page helpful? Yes No Submitting... Thank you

Comments