Indicates which scheme the DB2 load utility should use for index maintenance.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | AUTOSELECT |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | DB2 under UNIX and PC Hosts |
| See: | BULKLOAD= data set option |
Table of Contents
The load utility automatically decides between REBUILD or INCREMENTAL mode.
All indexes are rebuilt.
Indexes are extended with new data.
The load utility does not attempt index creation if this mode is specified. Indexes are marked as needing a refresh.
For more information about using the values for this option, see the IBM DB2 Universal Database Data Movement Utilities Guide and Reference.