In this blog post, let’s learn about the error message “9217 Unable to change the audit attribute for table-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9217 Unable to change the audit attribute for table-name.
Reason for the Error
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.
Solution
See the Guardian Procedure Errors and Messages Manual file system errors for possible recovery action and resubmit
