Re: DATABASE SERVER TERMINATED UNEXPECTEDLY (2)

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. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+