Re: DATABASE SERVER TERMINATED UNEXPECTEDLY (2)

In article <53al2o$pob@nic.florin.ru>, Igor Shcherbakov <sig@florin.ru> writes >In article <32592A9E.7D02@west.co.za>, marks@west.co.za says... ># >#Innar Vainre wrote: ># Has anyone been having this problem with INFORMIX 5.01. ># Query1 is always crash the INFORMIX and I get the message ># ERROR -457:DATABASE SERVER TERMINATED UNEXPECTEDLY. ># I checked the tables indexes (tbcheck -cI <tbl.name>) and ># tblspaces (tbcheck -cd <tbl.name>) and found that index and table ># self was OK. ># >#Try using SET EXLPAIN ON to examine the query path. It sounds as though >#it might be creating a temp table for the order by. If so, I can only >#imagine it is filling the rootdbs. >#>Look at creating an index for the group and order by. >#>Cheers, >#Mark. > > >We have encountered with the same problem using dynamic Informix-SQL for >OnLine 7.11 UC1. For example, such SQL-statement as "OPEN CURSOR ... >USING ...." can cause error -457. We have had no problems when we have >changed all "dangerous" dynamic SQL-statement to static SQL. > >Cheers, >Igor > Check in your online.log (use tbstat -c | grep MSGPATH to get the where it is. This should give more info. -- David Williams