BMCCPRS options
The following figure shows the BMCCPRS syntax.
BMCCPRS command syntax diagram
The following table lists the batch BMCCPRS options, showing the availability by object type.
Object types include the following:
- INDEX (IX)
- INDEXSPACE (IS)
- TABLE SPACE (TS)
- TABLE SPACE SET (TT)
Values in boldface are the default values.
Batch BMCCPRS options
Option name | Value | Description | Object type | |
|---|---|---|---|---|
TT, TS | IX, IS | |||
BADOBJECTRC | 0 through 8 4 (default) | Specifies the return code that BMCCPRS sets if it is unable to process a requested object due to object characteristics (unsupported objects), invalid status, object serialization, or object authorization failures. Regardless of the setting of this option, BMCCPRS processing continues. | X | X |
COLGROUP (only with TABLE) | colGrpName | Names the correlated column on which to copy statistics (for example, COL1,COL2). The colName can be 1 to 30 characters in the format col1,col2,col3 with a maximum of 80 column names. You can repeat COLGROUP colGrpName multiple times. The column list is associated with the previous TABLE option. Consider the following additional information: If you need to continue the name of the column to an additional line, the comma after the column name is required on the same line as the column name. When including multiple comma-separated column names on a single line, blanks are not allowed. Using parentheses to enclose a list of column names is optional. | X | |
COLUMN (only with TABLE) | colName ALL (default) | Names the columns on which to copy statistics (for example, COL1,COL2), or if you specify ALL, statistics are copied for all columns The colName can be 1 to 30 characters in the format col1, col2, col3 with a maximum of 80 column names. You can only specify the COLUMN keyword once for each TABLE keyword specified. The column list is associated with the previous TABLE option. Notes: Consider the following additional information:
| X | |
INDEX | Y (default) N | Tells BMCCPRS whether to copy statistics from the indexes in the table space If you also specify PARTITION, BMCCPRS will only process indexes with a matching partition. | X | |
MSGLEVEL | 0 (default) 1 | Specifies normal messaging (0) or additional informational messages about progress, timestamps, and default options settings (1) | X | X |
PARTITION | 1 through 4096 | Specifies a partition on which to collect statistics You can repeat PARTITION n multiple times. If you omit PARTITION, BMCCPRS collects statistics for all partitions unless you use an object set to limit partitions. | X | X |
REPORT | Y (default) N | Tells BMCCPRS whether to print a report of the copied or updated statistics | X | X |
TABLE | owner.tableName ALL (default) | Specifies the table on which to copy column statistics Specify a table name of up to 257 characters in the format owner.tableName with a maximum of 128 characters for owner, 1 character for period, and 128 characters for tableName, or specify ALL. All columns of all tables associated with the table spaces are processed if you specify ALL. You can repeat TABLE owner.tableName multiple times. | X | |