TABLESPACE

TABLESPACE identifies one or more table spaces, partitions, or data sets for which R+/CHANGE ACCUM will accumulate log record data.

When you specify ACCUM TABLESPACE, R+/CHANGE ACCUM creates a change accumulation group in the repository. R+/CHANGE ACCUM creates a new change accumulation group each time ACCUM TABLESPACE is run, even if the table spaces in the group are identical to those in an existing group. You should use this option only when conducting a product trial or testing. You should set up groups and use ACCUM GROUP for production.

Related topics

ACCUM-syntax

Specifying partitions or data sets


Important

You cannot specify the GROUP and TABLESPACE options in the same ACCUM statement.

The databaseName.tableSpaceNamevariable represents the following objects:

  • databaseName represents the name (one to eight characters) of the database on which the named table space resides. You can select multiple databases by using the ?, %, and * wildcard characters. Use the same wildcard guidelines as described in GROUP. The default is DSNDB04. You cannot specify DSNDB01, DSNDB06, or DSNDB07 as the database name.
  • tableSpaceName represents the name (one to eight characters) of the table space for which R+/CHANGE ACCUM will accumulate log record data. This option is required. You can select multiple table spaces using the ?, *, or % wildcard characters. Use the same wildcard guidelines as described in GROUP.

DSNUM

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

Option

Description

DSNUM ALL

(Default) DSNUM ALL extracts all log record data for the table space. You must specify ALL if you used wildcards for databaseName or tableSpaceName.

DSNUM integer

This value identifies a specific partition or data set for which R+/CHANGE ACCUM extracts log record data. For a partitioned table space, integer cannot be greater than the number of partitions. For a nonpartitioned table space, integer cannot be greater than 32.

If you request a specific data set number, the ACCUM statement cannot include the INDEXES YES option.

If you set up your change accumulation groups by partition for a partition by growth table space, be aware that you must create a new group when a new partition is created.

DSNUM begin : end

Use this option to recover a range of partitions in the table space. For partitioned table spaces, begin specifies the number (from 1 through 4096) of the first partition in the range and end specifies the number (from 2 through 4096) of the last partition in the range. The two numbers are separated by a colon (:) with or without spaces. Wrapping index numbers (for example, DSNUM 4050 : 300) is not supported.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*