UPDATE STATISTICS messages (9200 through 9225)
SQL 9200
9200 UPDATE STATISTICS encountered an error from statement name.
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
9201 Unable to DROP object name.
Cause
UPDATE STATISTICS encountered an error during a DROP of the object name.
Effect
NonStop SQL/MX is unable to continue processing.
Recovery
Resubmit the statement. If this does not correct the problem, stop and restart NonStop SQL/MX. If this does not correct the problem, report the entire message to your service provider.
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 nonunique column name in the specified column list.
Effect
NonStop SQL/MX 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
NonStop SQL/MX is unable to continue processing.
Recovery
Correct the syntax and resubmit.
SQL 9205
9205 UPDATE STATISTICS is not supported for object name.
Cause
You attempted to run UPDATE STATISTICS against an object that is not supported.
Effect
NonStop SQL/MX is unable to continue processing.
Recovery
Correct the syntax and resubmit.
SQL 9206
9206 You are not authorized to read/write object name. Verify that you have the necessary access privileges.
Cause
NonStop SQL/MX could not perform an UPDATE STATISTICS statement because you are not authorized to perform this operation against this table. You must either own the object name or be the super ID.
Effect
NonStop SQL/MX is unable to continue processing.
Recovery
Resubmit after checking the table location and access privileges.
SQL 9207
9207 The specified SAMPLE option generated an empty sample set. Modify the SAMPLE option and resubmit.
Cause
The SAMPLE option you specified generated an empty sample set.
Effect
NonStop SQL/MX is unable to continue processing.
Recovery
Modify the SAMPLE option and resubmit.
SQL 9208
9208 Column definitions could not be accessed.
Cause
An UPDATE STATISTICS statement was unable to access column definitions.
Effect
The operation fails.
Recovery
Resubmit the statement. If this does not correct the problem, stop and restart NonStop SQL/MX. If this does not correct the problem, report the entire message to your service provider.
SQL 9209
9209 Column name does not exist in object name.
Cause
You tried to access column name, which does not exist in object name.
Effect
The operation fails.
Recovery
Check the column name and resubmit.
SQL 9210
9210 One of the column data types is not supported by UPDATE STATISTICS. You must exclude this column from the column list in UPDATE STATISTICS.
Cause
You attempted to perform UPDATE STATISTICS on a column whose data type does not support this operation.
Effect
The operation fails.
Recovery
Exclude this column from the column list and resubmit.
SQL 9212
9212 Cardinality statistics will be more accurate if you use the SET ROWCOUNT option in the SAMPLE clause.
Cause
The SET ROWCOUNT option was not used in the SAMPLE clause.
Effect
Processing continues without interruption.
Recovery
Provide SET ROWCOUNT option and resubmit for more accurate statistics.
SQL 9213
9213 If you intend to update histogram statistics for columns, you must specify a column list in the statement.
Cause
You attempted to perform UPDATE STATISTICS and did not specify a column list.
Effect
Processing continues without interruption.
Recovery
Correct your syntax to specify the column list and resubmit.
SQL 9214
9214 Object name could not be created.
Cause
UPDATE STATISTICS encountered an error during a CREATE of the object name.
Effect
NonStop SQL/MX is unable to continue processing.
Recovery
Resubmit the statement. If this does not correct the problem, stop and restart NonStop SQL/MX. If this does not correct the problem, report the entire message to your service provider.
SQL 9215
9215 UPDATE STATISTICS encountered an internal error (from location with return value=errorcode). Details: otherdetails.
Cause
UPDATE STATISTICS received an internal error at the location with error code errorcode implying otherdetails.
Effect
The operation fails.
Recovery
Do not attempt recovery. Contact your service provider.
SQL 9217
9217 Unable to change the audit attribute for table-name.
Cause
The audit attribute of the sample table could not be turned off during the UPDATE STATISTICS operation. The attribute is turned off when the table is empty and contains no indexes. This enables UPDATE STATISTICS to use Side-tree inserts for better performance. The attribute is turned back on after the UPDATE STATISTICS operation is complete.
Effect
The operation fails.
Recovery
See the Guardian Procedure Errors and Messages Manual file system errors for possible recovery action and resubmit.
SQL 9218
9218 Unable to delete all records from the table table-name.
Cause
The data in the sample table could not be deleted. When the SAMPLE clause is specified, the UPDATE STATISTICS command populates the sample table with some temporary records. At the end of the operation, these records are deleted.
Effect
The sample table is not empty. This has no effect on the statistics that have already been collected. If the sample table is used again before all the records are deleted, the UPDATE STATISTICS command will return an error 9219.
Recovery
Execute either a DELETE statement or a PURGEDATA command on the table.
SQL 9219
9219 Sample table table-name is not empty. Only empty table can be used as the sample table.
Cause
The user-specified sample table has some data records in it and is not empty. If the sample table is not empty, the UPDATE STATISTICS command might not be able to populate it. This could also corrupt the statistics collected by the command.
Effect
The operation fails.
Recovery
Execute either a DELETE statement or a PURGEDATA command on the table and resubmit.
SQL 9220
9220 Sample table table-name cannot have index or trigger on it.
Cause
The user-specified sample table has either an index or a trigger or both. An index on the sample table might prevent the use of Side-tree inserts for populating the sample table and degrade performance. A trigger could modify the inserted data in an undesirable way, besides degrading performance.
Effect
The operation fails.
Recovery
Drop all the indexes and triggers on the sample table and resubmit.
SQL 9221
9221 The specified table table-name is not a SQL/MX table.
Cause
Either the table for which the statistics have to be collected, or the user-specified sample table, is not a SQL/MX table - it is either a SQL/MP table or some other object such as, index or a view. The USING SAMPLE TABLE clause is supported for SQL/MX tables only.
Effect
The operation fails.
Recovery
Specify a SQL/MX table name. For running the UPDATE STATISTICS command on a SQL/MP table, do not use the USING SAMPLE TABLE clause.
SQL 9222
9222 The statement will have no effect because no histograms are available for the table.
Cause
The UPDATE STATISTICS statement with EXISTING COLUMN[S] or NECESSARY COLUMN[S] option is submitted when there are no statistics available for the table.
Effect
The operation completes with warnings.
Recovery
Generate statistics at least once on the table, and then use the EXISTING COLUMN[S] or NECESSARY COLUMN[S] to regenerate the statistics.
SQL 9223
9223 The statement will have no effect because no histograms need to be updated.
Cause
The UPDATE STATISTICS statement with NECESSARY COLUMN[S] option is submitted when there are no column combinations for which statistics need to be updated.
Effect
The operation completes with warnings.
Recovery
The NECESSARY COLUMN[S] option must be used to regenerate the statistics when the data in the table is changed considerably since the execution of earlier UPDATE STATISTICS command.
SQL 9224
9224 The NECESSARY clause is only allowed on tables of schema version 3000 or higher.
Cause
The UPDATE STATISTICS or SHOWSTATS command with NECESSARY COLUMN[S] option is used on a table with schema version lower than 3000.
Effect
The operation fails.
Recovery
Use NECESSARY COLUMN[S] option on a table with schema version 3000 or higher.
SQL 9225
9225 No histogram data is available for columns column-list.
Cause
Histograms for the specified columns in the column-list are not available.
Effect
Processing continues.
Recovery
Run UPDATE STATISTICS command with column-list, and then rerun the SHOWSTATS command.
SQL 9226
9226 The SAMPLE clause is ignored when specified with NECESSARY clause.
Cause
Sampling option is specified along with NECESSARY COLUMN[S] option of UPDATE STATISTICS command.
Effect
The operation succeeds. This is a warning message only.
Recovery
None.