Error -229 cannot open or create a temporary file

--------------F12EB7EAE3F35812F39D06F8 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Greetings, We have Informix 5.0 running on a Unix/Sun machine. Yesterday we began getting calls that users were getting SQL statement error number -229. > > Could not open or create a temporary file. > > SYSTEM error number -162. > > ISAM err: BlobSpace does not exist. when they ran a 4GL or ISQL application. Looked in the message log and could not see anything out of the normal. ALso checked the temporary space --- plenty of room. The only thing that gave an information was tbcheck which looked like the system catalog tables were corrupt. We did a restore and everything was back to normal. Can anyone shed some light on what possibly could have caused all this? Anything to do to prevent? TIA, Maria -- ----------------------------------------------------- Maria L. Wilson Computer Sciences Corporation NASA Langley Research Center 3217 N. Armstead Ave. Hampton, Va 23666 email: m.l.wilson@larc.nasa.gov phone: 757-766-8265 fax: 757-766-2571 ----------------------------------------------------- --------------F12EB7EAE3F35812F39D06F8 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Greetings, <P>&nbsp;&nbsp;&nbsp; We have&nbsp; Informix 5.0 running on a Unix/Sun machine.&nbsp; Yesterday we began getting calls that users were getting SQL statement error number -229. <BR>> > Could not open or create a temporary file. <BR>> > SYSTEM error number -162. <BR>> > ISAM err: BlobSpace does not exist. <BR>when they ran a 4GL or ISQL application.&nbsp; Looked in the message log and could not see anything out of the normal.&nbsp; ALso checked the temporary space --- plenty of room. <P>The only thing that gave an information was tbcheck which looked like the system catalog tables were corrupt.&nbsp; We did a restore&nbsp; and everything was back to normal. <P>Can anyone shed some light on what possibly could have caused all this?&nbsp;&nbsp; Anything to do to prevent? <P>TIA, <BR>Maria <PRE>--&nbsp; ----------------------------------------------------- Maria L. Wilson&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Computer Sciences Corporation NASA Langley Research Center 3217 N. Armstead Ave.&nbsp; Hampton, Va 23666 email: m.l.wilson@larc.nasa.gov phone: 757-766-8265&nbsp; fax:&nbsp;&nbsp; 757-766-2571 -----------------------------------------------------</PRE> &nbsp;</HTML> --------------F12EB7EAE3F35812F39D06F8--