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