-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|stop|suspend|resume
rebuild rebuilds indexes in the standard way
stop stops the rebuild
This option enables a “clean” premature termination of the rebuild without all indexes being processed. However, this does not cancel the rebuild of individual indexes. 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 suspend the rebuild without terminating it. However, this does not cancel the rebuild of individual indexes. 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
CautionYou start the stop, suspend, and resume actions in parallel to a current rebuild, usually from a different shell or command prompt, for example:
brspace -c force -f tbrebuild -a suspend
...
brspace -c force -f tbrebuild -a resume
End of the caution.-e|-degree specifies the parallel degree to be used internally by the ALTER INDEX REBUILD statement 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 all|allsel|[<owner>.]<index>|
[<owner>.][<prefix>]%[<suffix>]|
[<owner>.][<prefix>]*[<suffix>]|<index_list>
where:
all or “%” means preselect
allsel or “*” means final select:
For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.
Default: none, since you must always specify indexes for rebuild
-l|-initial: specifies the initial extent size of the reorganized index
Syntax: -l|-initial <category>
<category> specifies the size of the initial extent after reorganization and is restricted to the following possible values:
1: 16 KB
2: 64 KB
3: 1 MB
4: 8 MB
5: 64 MB
6: 1 GB
Default: none
If you do not specify initial at all, the reorganized index retains the initial extent size from before the reorganization.
-m|-mode: lets you rebuild the indexes offline – that is, without the ONLINE clause of the ALTER INDEX REBUILD statement (this locks the index).
Syntax: -m|-mode online|offline
This method can be faster than an online rebuild but it locks the indexes, so make sure that your SAP system is not running at rebuild time.
Default: online
-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_list>
<owner> or <owner_list> specifies the name of the SAP owner or owners
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 table(s) to be exported
Syntax: -t|-table all|allsel|[<owner>.]<table>|
[<owner>.][<prefix>]%[<suffix>]|
[<owner>.][<prefix>]*[<suffix>]|<table_list>
where:
all or “%” means preselect
allsel or “*” means here also preselect
For more information about wildcards for preselect and select, see Selecting Objects in Segment Management with BR*Tools.
Default: none