Manualshelf

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

ManualsBrandsHP ManualsSoftwareHP Neoview Release 2.4 Software
211212213214215216217218219220
10 UPDATE STATISTICS Messages (9200 Through 9218)
SQL 9200
9200 UPDATE STATISTICS encountered an error from statement name.
Cause UPDATE STATISTICS encountered an error from the HP Neoview database statement
name.
Effect The operation fails.
Recovery Other error messages will appear with this one, depending on what statement
caused the error. Use them 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.
Recovery Correct the syntax and resubmit.
SQL 9204
9204 Invalid option option specified. Value must be range.
Cause You specified an invalid option for UPDATE STATISTICS. The value range specifies
the valid range for this option.
Effect The HP Neoview database software is unable to continue processing.
Recovery Correct the syntax and resubmit.
211