REBUILD Control Statement

The REBUILD statement rebuilds an index by reconstructing it.
cafrdb220
The REBUILD control statement rebuilds an index by reconstructing it. This statement supports the use of wildcards with index names.
This control statement has the following syntax:
REBUILD {INDEX {(ALL) DATABASE {
dbname
}}
| {(ALL) TABLESPACE {[
dbname
.]
tsname
} [DSNUM
int
]} | {([
creator
.]
ixname
[DSNUM
int
]) [TABLESPACE {[
dbname
.]
tsname
}]} | {([
creator
.]
ixname
) [TABLESPACE {[
dbname
.]
tsname
}] [DSNUM
int
]} | {([
creator
.]
ixname1
[DSNUM
int
],...,
ixnameN
[DSNUM
int
]) [TABLESPACE {[
dbname
.]
tsname
}]} | {([
creator
.]
ixname1
,...,
ixnameN
) [TABLESPACE {[
dbname
.]
tsname
}] [DSNUM
int
]} [
Index Options
] [
REBUILD Global Options
]} | {INDEX LIST {
listdef-name
} [
Index Options
] [
REBUILD Global Options
]} | {INDEX OBJ-LIST [
creator-id.
]
obj-list-name
[
Index Options
] [
REBUILD Global Options
]}
To apply the same DSNUM
int
value to all the indexes inside parentheses, specify DSNUM
int
outside the parentheses. If you specify DSNUM
int
for any indexes inside parentheses, do
not
specify this keyword at the end of the statement.
Index Options
You can include the following index options in the REBUILD control statement:
[ALTERNATE [NO|YES]] [RBALRSN_CONVERSION {NONE|BASIC|EXTENDED}]
REBUILD Global Options
You can include the following global options in the REBUILD control statement:
[ABEND-TASK] [ALLMSGS] [CHECK-LIMITKEYS {
NO
|YES}] [CLONE] [DMS/OS] [EDITPROC [
PROBLEM
|SUPERVISOR]] [HISTORY {
NO
|YES}] [IDCAMS-CATALOG [
YES
|NO]] [KEEP-SIMULATION-SHADOWS [
NO
|YES]] [MAXTASKS
int
] | [PARALLEL
int
] [NO-SYSCOPY-ROW] [PREVIEW {
NO
|YES}] [RENAME-CONTROL [
USER
|AUTO] [SHRLEVEL {
REFERENCE
|CHANGE [DEADLINE {
NONE
|
timestamp
|CURRENT_DATE [
constant
]|CURRENT_TIMESTAMP [
constant
]}] [LONGLOG {
CONTINUE
|TERM DELAY [
1200
|
int
]}] [MAXRO {
int
|DEFER}] [TERM-LIMIT
int
]}] [S-IOP [
NO
|YES]] [SMS-DATACLASS {
NO
|YES}] [SMS-GENERIC {
NO
|YES}] [SMS-MGMTCLASS {
NO
|YES}] [SMS-STORCLASS {
NO
|YES}] [SORTDEVT
device-type
] [SORTFLAG [
ALL
|CRITICAL|NONE] [SORTNUM
int
] [SORTSIZE [
4M
|MAX|
n
M|
n
K]] [SPACE-DEFN [
YES
|NO]] [STARTUP-ACCESS {
RESET
|RW|RO|FORCE|STOP}] [STATS-OPTIONS [
COLCARD-ALL
|COLCARD-INDEXED]] [STOP-LIMIT
int
] [UPDATE-CATSTATS [
NONE
|ALL]]