While addressing speed issues I did a dbexport/import and was running update statistics and received an Informix error -407. This is standard engine 7 (7.23C1).
The exact line was "update statistics medium for table 'table-name' distributions only;"
If I run a the command "update statistics" by itself it will run correctly. My understanding is that the standard "update statistics" is only recommended for older versions of the standard engine. Any input on what is causing the -407 error?