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,
round(((complete_date-rec_date)*24*60+(floor(complete_time/10000)-floor(rec_time/10000))*60+(mod(floor(complete_time/100),100)-mod(floor(rec_time/100),100))+(mod(complete_time,100)-mod(rec_time,100))/60),1) rec_complete
From rec_data
WHERE rec_date>='06/01/2011' AND rec_date<='06/09/2011'
INTO TEMP tmp_rec_june WITH NO LOG;

Hi,

What is the message on online.log of that informix server?

09:33:42 Logical Log 100623 Complete, timestamp: 0xb3ae5150.
09:33:42 Logical Log 100623 - Backup Started
09:33:43 Logical Log 100623 - Backup Completed
09:33:53 stack trace for pid 11524 written to /usr2/informix_11FC2/tmp/af.7dae14c1
09:33:53 stack trace for pid 11582 written to /usr2/informix_11FC2/tmp/af.7def14c1
09:33:53 Assert Failed: Memory free block header corruption detected in mt_shm_malloc_segid 3
09:33:53 IBM Informix Dynamic Server Version 11.10.FC2
09:33:53 Who: Session(92635, user1255@rms01, 22685, 0x9da0ebf0)
Thread(96720, sqlexec, 85f7ca48, 3)
File: mtshpool.c Line: 3494
09:33:53 Results: Unable to repair pool
09:33:53 Action: Please notify IBM Informix Technical Support.
09:33:53 stack trace for pid 11552 written to /usr2/informix_11FC2/tmp/af.7db814c1
09:33:53 Assert Failed: Memory block header corruption detected in mt_shm_free 1
09:33:53 IBM Informix Dynamic Server Version 11.10.FC2
09:33:53 Who: Session(79354, user1591@rms01, 12935, 0x7a84f388)
Thread(82202, sqlexec, 6ecbfbc8, 4)
File: mtshpool.c Line: 3349
09:33:53 Results: Unable to repair pool
09:33:53 Action: Please notify IBM Informix Technical Support.
09:33:53 stack trace for pid 11553 written to /usr2/informix_11FC2/tmp/af.450214c1
09:33:53 Recursive Exception - Server exiting
09:33:53 ERROR: Exception recursion in afhandler (thread 96720).
09:33:53 Recursive Exception - Server exiting
09:33:53 Recursive Exception - Server exiting
09:33:53 See Also: /usr2/informix_11FC2/tmp/af.450214c1, shmem.450214c1.0, gcore.450214c1.0.11553
09:33:53 stack trace for pid 12160 written to /usr2/informix_11FC2/tmp/af.3f314c1
09:33:53 Fatal error in ADM VP at mt.c:13388
09:33:53 Unexpected virtual processor termination, pid = 11552, exit = 0x100

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?

We opened a ticket with IBM. They haven't found the real cause yet.
Thanks.

You are welcome