BL_INDEXING_MODE= Table Option

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

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC
Syntax
Arguments
Details
See Also

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:
BULKLOAD= Table Option
Copyright © SAS Institute Inc. All rights reserved.