-f idrebuild

This BRSPACE function  rebuilds indexes. For more information, see Rebuilding Indexes with BR*Tools.

Function options:

·        -a|-action: specifies the action for the index rebuild

Syntax: -a|-action rebuild|check|cleanup|stop|suspend|resume

Ў        reorg rebuilds indexes in the standard way

Ў        stop stops the rebuild

This option enables a "clean" premature termination of the reorganization without all indexes being processed. However, the rebuild of individual indexes is not cancelled in this case. Instead, the process is terminated before the next index is processed. Therefore this action can take a long time.

Ў        suspend suspends the rebuild

This option lets you pause the rebuild without terminating it. However, the reorganization of individual indexes is not cancelled in this case. Instead, the process is terminated before the next index is processed. Therefore this action can take a long time.

Ў        resume resumes the rebuild

This option lets you resume the rebuild that was paused with the suspend option.

Default: rebuild

You start the stop, suspend, and resume actions in parallel to a current rebuild, usually from a different shell or DOS window, for example:

brspace -c force -f tbrebuild -a suspend

...

brspace -c force -f tbrebuild -a resume

·        -e|-degree: specifies the parallel degree to be used internally by the ALTER INDEX REBUILDstatement for the rebuild of individual indexes. It is reset to the old value by BRSPACE after the rebuild has finished.

Syntax: -e|-degree <degree>

Default: the parallel degree of the current index

·        -i|-index: specifies the indexes to be rebuilt

Syntax: -i|-index [<owner>.]<index>|[<owner>.]<prefix>%|%|
[<owner>.]<prefix>*|*|<index_list>

Wildcards: “%” means preselect, “*” means final select

For more information on wildcards for preselect and select, see “Selecting Objects” in Segment Management with BR*Tools.

Default: none, since you must always specify indexes for rebuild

·        -n|-newts: specifies that the indexes are rebuilt to a new tablespace

Syntax: -n|-newts <tablespace>

<tablespace> specifies the name of the new tablespace

Default: current tablespace that the indexes are located in

·        -o|-owner: defines the SAP owner of the tables – useful for Multiple Components in One Database (MCOD) configurations

Syntax: -o|-owner <owner>

<owner> specifies the name of the SAP owner

Default: no default in MCOD, otherwise the single SAP owner

·        -p|-parallel: specifies parallel processing for the rebuild

Syntax: -p|-parallel <threads>

<threads> specifies the number of processing threads running in parallel

Default: 1, that is, no parallel processing

·        -s|-tablespace: specifies the tablespace of the indexes to be rebuilt

Syntax: -s|-tablespace <tablespace>|<tablespace list>

<tablespace> or <tablespace list> specifies the tablespace name(s)

Default: none

·        -t|-table: specifies the tables of the indexes to be rebuilt

Syntax: -t|-table [<owner>.]<table>|[<owner>.]<prefix>%|%|

[<owner>.]<prefix>*|*|<table_list>]

Wildcards: “%” and “*” mean preselect

For more information on wildcards for preselect and select, see “Selecting Objects” in Segment Management with BR*Tools.

Default: none