HP NonStop SQL/MX, Messages Manual

Page: 307 / 752

UPDATE STATISTICS Messages (9200 through
9221)
HP NonStop SQL/MX Messages Manual — 640324-001
11- 5
SQL 9217
where,
table-name
is the name of a SQL/MX table.
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
where,
table-name
is the name of a SQL/MX table.
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
where,
table-name
is the name of a SQL/MX 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.
9217 Unable to change the audit attribute for table-name .
9218 Unable to delete all records from the table table-name .
9219 Sample table table-name is not empty. Only empty table
can be used as the sample table.