How COPY affects real-time statistics

When a COPY job starts, Db2 externalizes all in-memory statistics to the real-time statistics tables. Statistics are gathered for a full image copy or an incremental copy, but not for a data set copy.

The table below shows how running COPY on a table space or table space partition affects the SYSTABLESPACESTATS statistics.

Table 1. Changed SYSTABLESPACESTATS values during COPY
Column name During UTILINIT phase After COPY phase
COPYLASTTIME Current timestamp1 Timestamp of the start of COPY phase
COPYUPDATEDPAGES Actual value1 Actual value2
COPYCHANGES Actual value1 Actual value2
COPYUPDATELRSN Actual value1 Actual value3
COPYUPDATETIME Actual value1 Actual value3
Notes:
  1. Db2 externalizes the current in-memory values.
  2. This value is 0 for SHRLEVEL REFERENCE, or the actual value for SHRLEVEL CHANGE.
  3. This value is null for SHRLEVEL REFERENCE, or the actual value for SHRLEVEL CHANGE.

The table below shows how running COPY on an index affects the SYSINDEXSPACESTATS statistics.

Table 2. Changed SYSINDEXSPACESTATS values during COPY
Column name During UTILINIT phase After COPY phase
COPYLASTTIME Current timestamp1 Timestamp of the start of COPY phase
COPYUPDATEDPAGES Actual value1 Actual value2
COPYCHANGES Actual value1 Actual value2
COPYUPDATELRSN Actual value1 Actual value3
COPYUPDATETIME Actual value1 Actual value3
Notes:
  1. Db2 externalizes the current in-memory values.
  2. This value is 0 for SHRLEVEL REFERENCE, or the actual value for SHRLEVEL CHANGE.
  3. This value is null for SHRLEVEL REFERENCE, or the actual value for SHRLEVEL CHANGE.