In this blog post, let’s learn about the error message “9219 Sample table table-name is not empty. Only empty table can be used as the sample table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
9219 Sample table table-name is not empty. Only empty table can be used as the sample table.
Reason for the Error
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.
Solution
Execute either a DELETE statement or a PURGEDATA command on the table and resubmit
