BL_INDEXING_MODE= Table Option

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

Category: Bulk Loading
Requirement: Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_INDEXING_MODE= AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED

Arguments

AUTOSELECT

specifies that the load utility automatically decides between REBUILD or INCREMENTAL mode.

REBUILD

specifies that all indexes are rebuilt.

INCREMENTAL

specifies that indexes are extended with new data.

DEFERRED

specifies that the load utility does not attempt index creation. Indexes are marked as needing a refresh.

Details

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

See Also

Table Options:
Last updated: February 23, 2017