Neoview Messages Manual (R2.3)

7 Optimizer Messages (6000 Through 6999)
SQL 6000
6000 Internal error in the query optimizer.
Cause The optimizer received an internal error during query optimization.
Effect The operation fails.
Recovery Do not attempt recovery. HP support will perform recovery operations in response
to an automatically generated dial-out message about this condition.
SQL 6001
6001 DISTINCT aggregates can be computed for only one column per table
expression.
Cause You attempted to compute DISTINCT aggregates for more than one column.
Effect DISTINCT aggregates can be computed only for one column per table expression.
Recovery Correct syntax and resubmit.
SQL 6002
6002 The metadata table HISTOGRAMS or HISTOGRAM_INTERVALS contains
invalid values. If you have manually modified the metadata table, then
you should undo your changes using the CLEAR option in UPDATE STATISTICS.
Cause You have manually modified the metadata table, and now it contains invalid values.
Effect The HP Neoview database software is unable to complete compilation.
Recovery Undo your changes using the CLEAR option in UPDATE STATISTICS.
SQL 6003
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 and regenerate the statistics.
Cause You have manually modified the metadata table, and now it contains an invalid
boundary value.
Effect The HP Neoview database uses default histograms to compile the query. Therefore,
these might not be the best plans generated.
Recovery Undo your changes by using the CLEAR option in UPDATE STATISTICS and
regenerate the statistics.
SQL 6004
6004 The metadata table HISTOGRAM_INTERVALS for column clumn does not
have intervals intervale_number #1 and interval_number #2 in order. If
you have manually modified the metadata table, then you should undo
your changes using the CLEAR option in UPDATE STATISTICS and regenerate
the statistics.
Cause You manually modified the metadata table and it now contains an invalid boundary
value.
Effect The HP Neoview database uses default statistics to generate plans. Therefore, these
might not be the best plans generated.
161