OAT and Auto Update Statistics
Posted in 2010
I am having a problem in OAT- when I click on Auto Update Statistics, it
responds with:
Error: -258
[Informix][Informix ODBC Driver][Informix]System error - invalid statement id
received by the sqlexec process. (SQLExecute[-258] at
ext\\\\pdo_informix\\\\informix_statement.c:755)
Query:
select count(unique aus_cmd_partnum), aus_cmd_dbs_partnum fromsysadmin:aus_cmd_list where aus_cmd_priority > 100000 group by
aus_cmd_dbs_partnum
I have several databases, some at 11.50.FC6 and some at 11.50.FC1. The Auto
Update Statistics seems to work on my FC6 databases, however, not on my FC1databases. fyi- I had previously upgraded all the FC1 systems to FC6 and had
to revert back due to performance problems that I did not have the time to
troubleshoot. In any case, Informix Support would not help, as OAT is not
supported by them. Does anyone know what this could be and how to correct it?
The OAT version is 2.27. Thanks