Reply: temp table locking

Kamlesh (lad@remos.rutgers.edu) in writes: > I have the problem of the temp table locking. A user will not be able > to enter the databse sometimes, and this locks most of the users. Look at the global environment variable DBTEMP. If it is not set it will point to /tmp - which is bad news for any sane system. All users should set this to their very own $HOME/tmp, and this space should be big enough to hold all the temporary data that Informix needs to write out from time to time. When the temp directory space gets full, Informix does weird things on different systems, and hanging is one of them that's fairly common. Restarting Informix and noting that everything is fine for a while is a real good clue that DBTEMP is pointing to a sparse disk space - like /tmp. ------------------------------------------------------------------------- John R. Carter, Sr. 71553.535@compuserve.com Informix programmer/analyst -------------------------------------------------------------------------