I am running Informix 11 and receiving error 229 "Could not open or create a temporary file."
I do not receive any ISAM error (not sure why this is).
I made sure I do not have any space issues (and no permission issues I could see, but I am the first to admit that I am not a DBA). What is odd is that this was only affecting queries that involved creating temp tables but has grown to include statements that were working before and don't use temp tables at all (although they do group by more than 4 columns).
Attached is the onstat output. I am at a loss for what to check next. Any help is appreciated! Thanks!
was the onstat output generated when the problem occured or afterwards?
Anyway, please check that you have "cvp_temp_dbspace" entered in your onconfig under DBSPACETEMP (you will need to restart the database server to make the change happen).
Otherwise you may be receiving this error because the server will default to DBTEMP (which may be c:\temp or %TEMP%, not sure, I am no windows informix), see "onstat -g env".
Depending on what exactly you are doing, the temp table may also be generated in the dbspace where the database resides or the rootdbs. Maybe you can elaborate on that a little more.
By the way, you are using 10.00.TC10, not Version 11.