Re: DBTEMP
Posted in 1998
Hi Bill, I do not have any manual here. But I think the Informix Training Manuals said: "if you do not set DBSPACETEMP the temporary objects will be stored as in version 5.x". This would mean, DBTEMP will be preferred over "/tmp" for temporary files (not tables). Bye Stefan Bill Weaver wrote: > > I'm running Online Dynamic Server version 7.22. I have a system that I inherited > and in the environment, the DBTEMP variable is set to a particular file system. > This environment variable is not listed in the System Admin manuals so it would > seem that 7.22 doesn't utilize it. You can find reference to it in the SQL > Reference manual however and it states there that it only is applicable to SE > which I am not running. HOWEVER, I am getting some temporary files in the file > system named by DBTEMP (PSORT_DBTEMP doesn't reference it nor does any other > environment variable)! If this variable "isn't used" by Online, then why are > they appearing and what are they (they all begin with prefixes "en" and "f1"? Is > it safe to unset this variable and not use it at all? If so, will it use the > temporary spaces I already have defined? In addition to Online, we also utilize > version 6.04 of SQL and I4GL. Could one of these be using it? > -------------------------------------------------------- > Name: Bill Weaver > E-mail: Bill Weaver <billw@fscorp.com> > Date: 01/15/98 > Time: 11:16:28 > > This message was sent by Z-Mail Pro - from NetManage > NetManage - delivers Standards Based IntraNet Solutions > --------------------------------------------------------