USE-CHANGE-ACCUM—Read Changes from the Change-Accum Log

The USE-CHANGE-ACCUM keyword specifies whether to read the change accumulation log during a recovery.
cafrdb2
The USE-CHANGE-ACCUM keyword specifies whether to read the change accumulation log during an object recovery. If you do not use the change accumulation log, the Db2 log is used.
The change accumulation log contains information only for the objects that you specify. The change accumulation log takes less time to read than the Db2 archive log, which contains changes to all objects in the subsystem.
USE-CHANGE-ACCUM is not valid with REBUILD INDEX.
This keyword has the following format:
USE-CHANGE-ACCUM [
NO
|YES]
  • NO
    Reads the Db2 log file instead of the change accumulation file. This value is the default.
    Specifying NO decreases performance because the Db2 logs contain changes to all tablespaces and indexspaces in the system.
  • YES
    Reads the change accumulation log instead of the Db2 log file for changes to the tablespace or indexspace.
    YES cannot be used to recover system catalogs and directories. YES is also not valid with SORTLOG NO, SORTLOG CONCURRENT, FROMRBA, and LOGONLY.
More information: