Neoview Messages Manual (Volume 1) (R2.5)

10 UPDATE STATISTICS Messages (9200 Through 9218)
SQL 9200
9200 UPDATE STATISTICS for table catalog-name.schema-name.table-name
encountered an error (error-num) from statement-name.
catalog-name
is the name of the catalog for the table that was the subject of the
UPDATE STATISTICS operation.
schema-name
is the name of the schema for the table that was the subject of the
UPDATE STATISTICS operation.
table-name
is the name of the table that was the subject of the UPDATE STATISTICS
operation.
error-num
is the number (in parentheses) of the primary error that prompted SQL
9200. This error number is not always issued, and the message text
omits it if the error number is not present.
statement-name
is the name of the SQL statement that is causing the error.
Cause UPDATE STATISTICS encountered an error from the SQL statement
statement-name.
Effect The operation fails.
Recovery Depending on the statement that caused the error, other error messages will appear
with this one. Use the other error messages to diagnose and correct the problem.
SQL 9201
9201 Unable to DROP object name.
Cause UPDATE STATISTICS encountered an error during a DROP of the object name.
Effect The HP Neoview database software is unable to continue processing.
Recovery Resubmit the statement. If this does not correct the problem, stop and restart the
Neoview database. If this does not correct the problem, contact the GMCSC.
SQL 9202
9202 UPDATE STATISTICS has located previously generated histograms that
are not being regenerated. This may affect the plans that will be
generated. Missing column lists are column-list.
Cause UPDATE STATISTICS has located previously generated histograms that are not being
regenerated.
Effect Processing continues without interruption.
Recovery Remove or replace previously generated histograms by performing either one of
these two recovery actions:
• Re-execute the same UPDATE STATISTICS command, but also include the column-list
from the message.
• Perform UPDATE STATISTICS FOR the table. Then re-execute UPDATE STATISTICS
with the column lists in which you are interested.
SQL 9203
9203 Column names must be unique when specified in column list: (name).
Cause You specified a non unique column name in the specified column list.
Effect The HP Neoview database software is unable to continue processing.
225