BUILDINDEX
The BUILDINDEX option specifies one or more nonpartitioned indexes (and so identifies the corresponding index spaces) to be rebuilt. The keys for the indexes must have already been extracted in RECOVER UNLOADKEYS jobs and be available in the work data sets (the unload data sets) specified in that job.
Option | Description |
|---|---|
(indexName1,indexName2, . . . . . ) | This parameter specifies each of the nonpartitioned indexes that you want to rebuild. Each index name is in the form authid.indexName. If you do not provide the authid qualifier, the qualifier is defaulted to the user ID of the user executing the utility. The keys and row IDs for all of the indexes must be already contained in the unload data sets specified in the job. You must enclose the list of qualified names in parentheses. |
ALL | BUILDINDEX(ALL) specifies that all nonpartitioned indexes on the table space are to be rebuilt and expects that the keys and row IDs are contained in the unload data sets specified in the job. |
Related topic