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

HP NonStop SQL/MX Messages Manual—523730-004
11-1
11
UPDATE STATISTICS and Executor
Sort Messages (9200 through 10049)
SQL 9200
Cause. UPDATE STATISTICS encountered an error from the SQL/MX 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
Cause. UPDATE STATISTICS encountered an error during a DROP of the object
name.
Effect. SQL/MX is unable to continue processing.
Recovery. Resubmit the statement. If this does not correct the problem, stop and
restart SQL/MX. If this does not correct the problem, report the entire message to your
service provider.
SQL 9202
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:
•
Reexecute the same UPDATE STATISTICS command, but also include the
column-list from the message.
9200 UPDATE STATISTICS encountered an error from statement
name.
9201 Unable to DROP object name.
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.