Confirm
Noconfirm
Specify the Confirm qualifier with the Update qualifier to
gain more control over the update function. When you specify
the Confirm qualifier, you are asked whether the update should
be performed for each selected table or index whose stored
cardinality value is different from its actual cardinality value.
You can respond with YES, NO, QUIT, or an alternative value for
the stored cardinality.
Specifying YES means that you want to update the stored
cardinality with the actual cardinality value. Specifying NO
means that you do not want to update the stored cardinality
value. Specifying QUIT aborts the RMU Analyze Cardinality
command, rolls back any changes you made to stored cardinalities,
and returns you to the operating system prompt. Specifying an
alternative value updates the stored cardinality value with the
alternative value.
When you specify the Noconfirm qualifier, you are not given the
option of updating stored cardinality values with an alternative
value of your own choosing. Instead, the stored cardinality
values that differ from the actual cardinality values are
automatically updated with the actual cardinality values.
The default is the Noconfirm qualifier.
The Confirm and Noconfirm qualifiers are meaningless and are
ignored if they are specified without the Update qualifier.