Arguments
- db_instance_name
- Specifies the name of the DB2® instance. Enter a text string with a maximum of 60 bytes.
- db_name
- Specifies the name of the database. This is the name the database was given when created. Enter a text string with a maximum of 60 bytes.
- table_schema
- Specifies the qualifier for the table name. For example, if the qualified name of a table is USERID.TABLE1, the schema is USERID.
- table_name
- Specifies the unqualified table name. For example, if the qualified name of a table is USERID.TABLE1, the name is TABLE1.
- dist_switch
- Enter Yes or No to indicate whether you want distribution statistics calculated.
- index_switch
- Enter one of the following responses:
- Yes
- Updates statistics on the indexes.
- No
- Does not update statistics on the indexes.
- Index
- Specifies to update statistics on a specific index that is defined in the index-schema and index-name variables.
- index_only_switch
- Enter Yes or No to indicate whether you want to update statistics
on the indexes only.
If the index argument is Yes and index_only_switch is No, statistics on both the table and its indexes are updated.
If index is No and index_only_switch is No, statistics on the table only are updated.
- detail_switch
- Enter Yes or No to indicate whether you want extended index statistics calculated when you are updating statistics on the indexes.
- share_switch
- Enter Change or Reference to indicate how other users can access
the table while statistics are calculated:
- Change
- Other users can read from and write to the table while statistics are calculated.
- Reference
- Other users can only read from the table while statistics are calculated.
- index_schema
- Specifies the qualifier for the index name. This variable is required if you specify the Index parameter for the index argument.
- index_name
- Specifies the unqualified index name. This variable is required if you specify the Index parameter for the index argument.