Re: DBTEMP setting in informix.ini

Posted in 1997

"Billy Wheeler" — 9 Aug 1997 08:48:22 -0400 — source: Informix-list mailing list archive (1991-1998)

On 9 Aug 97 at 10:26, INFODATA wrote: > It does seem that any value specified for DBTEMP in informix.ini is > not being respected and instead the default /tmp is being used. > > Is there any place I'm going wrong ?? There are some things which you can investigate: 1. Rewrite the queries to avoid the sort, or create useful indexes. 2. I read the NewEra/SetNet help files, which said: "Specifies the directory on the client computer that the ESQL/C processor uses to store temporary files (also called swap files)." To my mind, this means that the SetNet setting has no effect on the server-side DBTEMP. 3. In order to affect the server-side values, you should make sure that the correct DBTEMP is specified at the time you start the server-side sqlexecd program. HTH. -- Ciao, Billy Nose to the ear in Johannesburg, Murder Capital of the World.