Multiple index specification

This section describes the multiple index specification.

The syntax for the multiple 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 for the 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).

INDEX (ALL) TABLESPACE databaseName.tableSpaceName

(ALL) TABLESPACE specifies that R+/CHANGE ACCUM is to scan all indexes for the named table space. The parentheses around ALL are optional.

TABLESPACE specifies the table space from which R+/CHANGE ACCUM is to scan all indexes.

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

INDEXSPACE databaseName.indexSpaceName

The INDEXSPACE option specifies indexes 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).

Related topic

LOGSCAN syntax

Comments