MODIFY ACCUM syntax

The following figure shows the MODIFY ACCUM syntax. This command is supported in the ACAMOD load module that is shipped with R+/CHANGE ACCUM.

TABLESPACE option for MODIFY ACCUM

TABLESPACE names one table space, partition, or data set for which MODIFY ACCUM is to delete repository records.

Note

MODIFY ACCUM does not include any indexes that are associated with the table space. You must run MODIFY ACCUM GROUP to delete repository records for indexes.

The databaseName.tableSpaceName variable represents the following objects:

databaseName represents the database in which the named table space is found. DSNDB04 is the default. You may not specify DSNDB01, DSNDB06, or DSNDB07.
tableSpaceName represents the table space within the named database.

DSNUM

DSNUM identifies the partitions of a partitioned table space for which MODIFY ACCUM extracts log record data. For a multi-data-set, nonpartitioned table space, this option identifies the data sets.

Option	Description
DSNUM ALL	DSNUM ALL (the default) specifies that MODIFY ACCUM extracts all log record data for the table space.
DSNUM integer	DSNUM integer identifies a specific partition or data set for which MODIFY ACCUM extracts log record data. If this is a partitioned table space, DSNUM cannot be greater than the number of partitions. If this is a nonpartitioned table space, DSNUM cannot be greater than 32.

GROUP option for MODIFY ACCUM

GROUP names one change accumulation group for which MODIFY ACCUM deletes repository records. MODIFY ACCUM deletes records for table spaces, clones, and indexes if GROUP is specified.

groupName represents the change accumulation group.

Explicit deletion criteria specification

The following options allow you to control which repository records MODIFY ACCUM deletes. You must specify one of these options if you specify the GROUP option.

TORBA X' logPoint' or TOLOGPOINT X' logPoint'

This option deletes log range records from the repository up to (but not including) the specified log point. ' logPoint' must be from 1 to 12 hexadecimal digits. TOLOGPOINT is a synonym for TORBA.

DELETE

This option deletes log range records from the repository, for which the date of creation is earlier than the date specified or calculated.

Option	Description
DELETE AGE integer	This option determines where to begin deleting repository records by subtracting the number of days specified ( integer) from the current date. MODIFY ACCUM deletes records up to (but not including) the calculated date. Replace integer with a value from 0 to 32767.
*DELETE AGE ()**	This option deletes all records for the specified table space. If GROUP is specified, all records includes those for indexes.
DELETE DATE yymmdd or yyyymmdd	This option deletes log range records that were created prior to the specified date. The date must be in the format yymmdd or yyyymmdd and cannot be a date in the future. If you use yymmdd, the year is assumed to be 20 yy when yy is less than 90; 19 yy is the assumed year when yy is greater than or equal to 90.
*DELETE DATE ()**	This option deletes all records for the specified table space. If you specify the GROUP option, the deletion includes the records for indexes.

ANALYZE

ANALYZE defines the level of output to include in reports that MODIFY ACCUM generates. You can specify ANALYZE only once in SYSIN.

Option	Description
ANALYZE YES	This is the default. If you specify ANALYZE YES, MODIFY ACCUM generates a report describing which log ranges it will delete from the repository.
ANALYZE NO	If ANALYZE NO is specified, MODIFY ACCUM reports only phase messages, errors, or warnings.
ANALYZE ONLY	ANALYZE ONLY performs as ANALYZE YES does but does not delete log ranges. This option allows you to see which log ranges exist that are not useful for recovery of specific table spaces, including indexes if you specify GROUP.