INDEP INTABLESPACE

The variables are defined as follows:

• vcat is the ICF catalog name.
• databaseName.tableSpaceName is the name of the database and space containing the data set being rebuilt.
• p corresponds to the value that is used by Db2 for this node.
• znnn is the data set number.

z represents the letter A, B, C, D, or E. These letters correspond to the first digit—0, 1, 2, 3, or 4—of the partition number. nnn represents the rest of the partition number. znnn represents the partitions numbers as follows:

• A001 through A999 for partitions 1 through 999
• B000 through B999 for partitions 1000 through 1999
• C000 through C999 for partitions 2000 through 2999
• D000 through D999 for partitions 3000 through 3999
• E000 through E096 for partitions 4000 through 4096

If you specify a RECOVER TABLESPACE command (for the table space associated with this index) by using INDEP OUTSPACE in the same SYSIN stream as this REBUILD INDEX command and you also specify INDEP INTABLESPACE, any data set name used must be the same as the name used with INDEP OUTSPACE in the RECOVER TABLESPACE command. If you do not include a data set name, BMC AMI Recover assumes the data set that is named in INDEP OUTSPACE. If you also do not specify INDEP INTABLESPACE, BMC AMI Recover still uses the independent table space data set that is named in the RECOVER TABLESPACE command to extract the keys.

When you use INDEP INTABLESPACE, you must specify it immediately after the TABLESPACE specification, as shown in REBUILD-INDEX-syntax.

For information about using redirection with multiple BMC AMI Recover commands, see Recovering to a non-DB2 data set.