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 NGT Recover

NGT Recover enables real-time statistics as follows:

  • NGT Recover resets the COPY-related counters, even during a recovery to current, if it is making an output image copy during a recovery.

  • NGT 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 NGT 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 NGT 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 DB2 RECOVER utility, the DB2 RECOVER utility never updates these fields.

The 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 NGT 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