How to set up temporary space per session
Roger Vilca on Informix 11.50 (HP-UX) wanted a per-session temporary space, since an application filled the DBSPACETEMP dbspaces; PSORT_DBTEMP did not work. John Miller III and Paul Watson said DBSPACETEMP can be set as an environment variable before connecting. Roger noted the dbspaces must already be registered in the onconfig file. No on-the-fly directory option was offered.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I have an application that creates large temporary tables, causing temporary dbspaces are full. This hurts the entire instance. At the moment it is not possible to change the application. One solution would be to increase the size and / or amount of the temporary dbspaces, but this causes an unnecessary expense in the instance space. The other solution might be of (while modifying the application) is to use a directory in which to write these temporary tables. The question is: IS there a way set up the temporary space for a particular session using a disk directory. I tried with PSORT_DBTEMP, but it does not work. Currently, the instance run on Informix 11.50 running on hp-ux The parameter in the onconfig file DBSPACETEMP is tmp1: tmp2: tmp3: tmp4 Please, provide me any clues according your experience. Thanks in advance, Roger
DBSPACETEMP is also an environment variable that you can set = before connecting to the server. You should try using this environ= ment variable. John F. Miller III STSM, Lead Architectmiller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) -----ids-bounces@iiug.org wrote: -----= >To: ids@iiug.org >From: "ROGER VILCA" >Sent= by: ids-bounces@iiug.org >Date: 08/23/2013 06:29PM >Subject: H= ow to set up temporary space per session [31253] > >Hi, I ha= ve an application that creates large temporary tables, >causing tempo= rary dbspaces are full. This hurts the entire >instance. At the mo= ment it is not possible to change the >application. One solution woul= d be to increase the size and / or >amount of the temporary dbspaces= , but this causes an unnecessary >expense in the instance space. Th= e other solution might be of (while >modifying the application) is to= use a directory in which to write >these temporary tables. The que= stion is: IS there a way set up the >temporary space for a particula= r session using a disk directory. I >tried with PSORT=5FDBTEMP, but= it does not work. Currently, the >instance run on Informix 11.50 r= unning on hp-ux The parameter in the >onconfig file DBSPACETEMP is t= mp1: tmp2: tmp3: tmp4 Please, provide >me any clues according your = experience. Thanks in advance, Roger >*****************************= **************************************** >********** Forum Note: U= se "Reply" to post a response in the >discussion forum. =
True, but I have noticed that you need register previously the temporary dbspace in onconfig file, I thought there was some way to make the settings "on the fly", by session. Roger
If the spaces exist then you should be able to set DBSPACETEMP in the calling environment Cheers Paul > -----Original Message----- > From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of > ROGER VILCA > Sent: Tuesday, August 27, 2013 5:00 PM > To: ids@iiug.org > Subject: Re: How to set up temporary space per session [31270] > > True, but I have noticed that you need register previously the temporary > dbspace in onconfig file, I thought there was some way to make the settings > "on the fly", by session. > > Roger > > > ********************************************************** > ********************* > Forum Note: Use "Reply" to post a response in the discussion forum.