Unanswered: INTO TEMP clause caused the database crash
INformix IDS 11.10.
I ran the following script. The database just shutdown itself.
The total records of the query should be 8000.
Do you think is the Temprory DBSPACE problem?
Select rid, rec_year, rec_num, rec_date,
WHERE rec_date>='06/01/2011' AND rec_date<='06/09/2011'
INTO TEMP tmp_rec_june WITH NO LOG;
It seams you are having some problems with space for memory with your server. Or those calculations are to much extensive and there is't enough space or your shared memory is not well configured.
Did you try FAQS at IBM informix site for that version?