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

Optimizer Messages (6000 through 6999)
HP NonStop SQL/MX Messages Manual—523730-004
8-2
SQL 6003
Cause. You have manually modified the metadata table, and now it contains an invalid
boundary value.
Effect. SQL/MX is unable to complete compilation.
Recovery. Undo your changes using the CLEAR option in UPDATE STATISTICS.
SQL 6007
Cause. Statistics are not available for the multicolumn join you are performing.
This message appears when the user has not updated statistics for column names and
when the rowcount in table name is more than the value of the defaults table constant
HIST_ROWCOUNT_REQUIRING_STATS. If you want to suppress this message, set
that value to a very large number, and you will see this message only for tables with
more rows than that, and for which there are no updated statistics.
Effect. None. This is a warning message.
Recovery. None.
SQL 6008
Cause. Statistics are not available for the statement you specified.
This message appears when the user has not updated statistics for column name and
when the rowcount in the table is more than the value of the defaults table constant
HIST_ROWCOUNT_REQUIRING_STATS. If you want to suppress this message, set
that value to a very large number, and you will see this message only for tables with
more rows than that, and for which there are no updated statistics.
Effect. None. This is a warning message.
Recovery. None.
6003 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS
contains invalid boundary value value for column name. If you
have manually modified the metadata table, then you should
undo your changes using the CLEAR option in UPDATE
STATISTICS.
6007 Multi-column statistics for columns names from table
name were not available; as a result, the access path chosen
might not be the best possible.
6008 Statistics for column name were not available. As a
result, the access path chosen might not be the best
possible.