264: Could not write to a temporary file.

I am runing a big query on IDS 10 select min(ds_start_dt) from inv_gvar where ingest_dt < "2006-08-01 00:00:00" and ds_start_dt>"1970-03-23 00:00:00.000" inv_gvar is a view. After a while, it reports 264: Could not write to a temporary file. 131: ISAM error: no free disk space then , I setup DBTEMP, export DBTEMP=/dbbackup/tmp-links it still reports same error. /dbbackup/tmp-links has lots of space and I watch it did not use it. What should I do? Thanks, Quman

Hi, one thing: It could be that informix creates a temporary table rather than temporary files. In this case, the DBSPACETEMP var should be used (or a preset tempdbs). Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Quman Sent: Friday, August 04, 2006 9:34 PM To: ids@iiug.org Subject: 264: Could not write to a temporary file. [7222] I am runing a big query on IDS 10 select min(ds_start_dt) from inv_gvar where ingest_dt < "2006-08-01 00:00:00" and ds_start_dt>"1970-03-23 00:00:00.000" inv_gvar is a view. After a while, it reports 264: Could not write to a temporary file. 131: ISAM error: no free disk space then , I setup DBTEMP, export DBTEMP=/dbbackup/tmp-links it still reports same error. /dbbackup/tmp-links has lots of space and I watch it did not use it. What should I do? Thanks, Quman **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

Run ondtat -d and monitor the free space of tempspace if br runninbg out of space Thank You Jeffrey J Wain ----- Original Message ---- From: Quman <yquman@gmail.com> To: ids@iiug.org Sent: Friday, August 4, 2006 3:34:27 PM Subject: 264: Could not write to a temporary file. [7222] I am runing a big query on IDS 10 select min(ds_start_dt) from inv_gvar where ingest_dt < "2006-08-01 00:00:00" and ds_start_dt>"1970-03-23 00:00:00.000" inv_gvar is a view. After a while, it reports 264: Could not write to a temporary file. 131: ISAM error: no free disk space then , I setup DBTEMP, export DBTEMP=/dbbackup/tmp-links it still reports same error. /dbbackup/tmp-links has lots of space and I watch it did not use it. What should I do? Thanks, Quman ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

Hi, By default, if there are no temp dbspaces defined, informix will use /tmp (at least at my experience). DBTEMP can be set on the client-side, and must point to a dir on the server, which - must be writable by informix ! - should have enough space The better way is to create one or more temp dbspaces and set these in onconfig. Look in /tmp on the server if the temp files are created there. If this occurs, the DBTEMP was ignored, maybe because of permission problems. Marcus -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Quman Sent: Friday, August 04, 2006 9:34 PM To: ids@iiug.org Subject: 264: Could not write to a temporary file. [7222] I am runing a big query on IDS 10 select min(ds_start_dt) from inv_gvar where ingest_dt < "2006-08-01 00:00:00" and ds_start_dt>"1970-03-23 00:00:00.000" inv_gvar is a view. After a while, it reports 264: Could not write to a temporary file. 131: ISAM error: no free disk space then , I setup DBTEMP, export DBTEMP=/dbbackup/tmp-links it still reports same error. /dbbackup/tmp-links has lots of space and I watch it did not use it. What should I do? Thanks, Quman **************************************************************************** *** Forum Note: Use "Reply" to post a response in the discussion forum.

HI, Interesting! when I did export DBSPACETEMP=/dbbackup/tmp-links, it finished! I watched , this time, it did NOT use either DBSPACETEM specified in onconfig file or the one I just set up as ENV variable. Do not know why. Very curious! Taank you all and have great weekend! Quman On 8/4/06, Marcus Haarmann <marcus.haarmann@midoco.de> wrote: > > > Hi, one thing: > It could be that informix creates a temporary table rather than temporary > files. > In this case, the DBSPACETEMP var should be used (or a preset tempdbs). > > Marcus > > -----Original Message----- > From: ids-bounces@iiug.org [mailto: ids-bounces@iiug.org] On Behalf Of > Quman > Sent: Friday, August 04, 2006 9:34 PM > To: ids@iiug.org > Subject: 264: Could not write to a temporary file. [7222] > > I am runing a big query on IDS 10 > > select min(ds_start_dt) from inv_gvar > where ingest_dt < "2006-08-01 00:00:00" > and ds_start_dt>"1970-03-23 00:00:00.000" > > inv_gvar is a view. > > After a while, it reports > > 264: Could not write to a temporary file.> > 131: ISAM error: no free disk space> > then , I setup DBTEMP, > > export DBTEMP=/dbbackup/tmp-links > > it still reports same error. > > /dbbackup/tmp-links has lots of space and I watch it did not use it. > > What should I do? > > Thanks, > Quman > > > **************************************************************************** > *** > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >