Re: DATABASE SERVER TERMINATED UNEXPECTEDLY (2)

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