Re: Reply: temp table locking

In article <1kavmeINNiv8@emory.mathcs.emory.edu> 71553.535@CompuServe.COM ("John R. Carter") writes: >Kamlesh (lad@remos.rutgers.edu) in writes: > > >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. Huh? I can understand not setting it to /tmp on a system where the root filesystem isn't very big. Is there a reason to specifically set it to something different for each user? Personally, I can't see anything wrong with everybody using /usr/tmp (or /usr2/tmp, or whatever). "On any sane system" (well, on many sane systems) the user directories for most people don't contain very much, and probably aren't on a very big partition. -- Bill Foote bill@pds.com MIS Director uunet!promdist!bill PDS Corp, Los Angeles, CA USA