Single index specification

This section describes the single index specification.

The syntax for the single index specification is in the LOGSCAN syntax diagram in LOGSCAN-syntax.

Option

Description

INDEX creatorID,indexName

The INDEX option specifies the index to be scanned.

Value	Description
*creatorID*	Represents the qualifier creator ID for the index. The default is the user identifier for the utility.
*indexName*	Represents the name of the index. You cannot use indexes for BMCUTIL, BMCSYNC, and BMCXCOPY (tables used by BMC utilities).

Note

This option is valid for type 2 indexes only because they are the only type of index for which recovery from logs can be performed.

INDEXSPACE databaseName.indexSpaceName

The INDEXSPACE option specifies the index space to be scanned.

Value	Description
*databaseName*	Represents the name of the database containing the index space. The default is DSNDB04. The name cannot be DSNDB01, DSNDB06, DSNDB07, or any database defined with TYPE='W' in SYSIBM.SYSDATABASE.
*indexSpaceName*	Represents the name of the index space within the named database. You cannot use indexes for BMCUTIL, BMCSYNC, and BMCXCOPY (tables used by BMC utilities).

Note

This option is valid for type 2 indexes only because they are the only type of index for which recovery from logs can be performed.

DSNUM

DSNUM specifies a single data set for the specified index or the entire index.

Value	Description
DSNUM ALL	(default) DSNUM ALL specifies that R+/CHANGE ACCUM should scan all of the data sets for the index. If the index is nonpartitioned and DSNUM ALL is specified or implied, image copies made for specific data sets will only be considered if they are registered at the same log point.
DSNUM integer	Use this option when you want to scan only one partition or data set for an index. For partitioned indexes, DSNUM integer specifies the number (from 1 through 254) of a single partition of the specified index. For nonpartitioned indexes, DSNUM integer specifies the number (from 1 to 254) of a single data set for the specified index.
DSNUM begin : end	Use this option to recover a range of partitions in the space. For partitioned 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.

On this page