Re: SQL Error: 229

gzhao@bbt.com (Guochun Zhao) writes: >Informix (v5.0) gave me an error when it runs a 4GL program. >The error message is: >SQL statement error number -229. >COuld not open or create a temporary file. >SYSTEM error number -22. >Invalid argument >I checked the permission of /tmp which $DBTEMP is set to and >the /tmp has permission 777. Strage enough, if we login on the >machine where the database locally resides, we don't get >above error. The error occur only for remote hosts. I checked >I-NET daemon process and it seems to be just fine. I can run >isql on remote host and get the database. I've run into this on several occasions. The problem isn't with the DBTEMP for your applications, it's with the value of DBTEMP when you start up I-Star. Remember, when sqlexecd is started it reads its execution environment AT THAT POINT. INFORMIXDIR, SQLEXEC, TBCONFIG, etc are all read when sqlexecd is executed by root. Most likely you have DBTEMP set to a non-readable/writable or non-existent directory. The error will most likely be intermittent since I-Star will only run into the problem when it needs to create a temp file. Troy ============================================================================== Troy L. Hewitt, CSE INFORMIX-Federal Client Services Washington, D.C. (703) 524-3600 e-mail: troy@informix.com ------------------------------------------------------------------------------ All opinions expressed are my own and not those of Informix Software, Inc. ==============================================================================