SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

SQL/MX MXCMP Messages (2000 through 2999)
HP NonStop SQL/MX Messages Manual—523730-004
4-12
Recovery. None. Report the entire message to your service provider.
SQL 2053
Cause. This is an informational message that is a result of the two-pass mechanism of
the optimizer. The optimizer created a simple plan, and then while refining that plan, an
internal error occurred, so the simple plan was not improved. The simple plan is still
valid and will work.
Effect. Your query will use the original, simple plan.
Recovery. Informational message only; no corrective action is needed. This message
will be accompanied by an assertion failure message and, possibly, CONTROL
QUERY SHAPE information. However, report the entire message, and the preceding
assertion failure message, to your service provider.
This additional information will also be helpful: the DDL for the tables involved, the
query that produced this warning, and any CONTROL QUERY SHAPE and CONTROL
QUERY DEFAULT settings in effect when the error occurred.
SQL 2054
Cause. You attempted to set the CQD HIST_NO_STATS_ROWCOUNT value as less
than the current value of CQD HIST_NO_STATS_UEC.
Effect. The current value of the HIST_NO_STATS_ROWCOUNT is retained.
Recovery. Set the value of CQD HIST_NO_STATS_ROWCOUNT greater than or
equal to the value of HIST_NO_STATS_UEC. If you want to use a smaller value,
reduce the value of CQD HIST_NO_STATS_UEC first. Note that any change in either
of the two values can have an effect on the plan quality.
SQL 2055
Cause. You specified an invalid value for the DEFAULTS attribute listed in the
message.
Effect. The operation fails.
Recovery. Correct the syntax and resubmit.
2053 Optimizer pass two assertion failure (failure-text) in
file file-name at line line-num.
2054 HIST_NO_STATS_ROWCOUNT should always be greater than or
equal to CQD HIST_NO_STATS_UEC. Present value of
HIST_NO_STATS_UEC is 'value'.
2055 The specified value 'value' for DEFAULTS attribute name
is not valid.