Data Set Options for Relational Databases

BL_INDEXING_MODE= Data Set Option

Indicates which scheme the DB2 load utility should use for index maintenance.

Default value:	AUTOSELECT
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under UNIX and PC Hosts

Syntax

BL_INDEXING_MODE=AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED

AUTOSELECT: The load utility automatically decides between REBUILD or INCREMENTAL mode.
REBUILD: All indexes are rebuilt.
INCREMENTAL: Indexes are extended with new data
DEFERRED: The load utility does not attempt index creation if this mode is specified. Indexes are marked as needing a refresh.

To specify this option, you must first set BULKLOAD=YES.

For more information about using the values for this option, see the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.