Re: DBSPACETEMP (<<< sigh >>>)

Does it happen if you specify comma as delimiter ? If you go to onmonitor and specify colon it gives error. So, it seems "," is the correct delimiter. Try and pl. inform me about the result. Alkesh Vipani. ----- Original Message ----- From: "Mister Creosote" <glynb@my-deja.com> To: <informix-list@iiug.org> Sent: Monday, February 14, 2000 6:50 AM Subject: DBSPACETEMP (<<< sigh >>>) > We are experiencing some strange behaviour regarding our use of the > $ONCONFIG/UNIX Environment parameter DBSPACETEMP. I have followed > earlier discussions with interest (thanks, Art, for your > succinct "pecking order" clarification), but am still surprised at the > results we are finding, as follows :- We have 3 temp dbspaces defined > as tempdbs1, tempdbs2, and tempdbs3. There was some confusion as to > which separator to use in the $ONCONFIG file, but I believe EITHER a > comma or colon will suffice (as per Informix Unleashed) (experiments > with both would appear to confirm this but I am open to an "official" > line). We plumped for a colon as follows :- > > DBSPACETEMP tempdbs1:tempdbs2:tempdbs3 # Default temp dbspaces > > WITHOUT the UNIX environment parameter set, my understanding is that > the engine will use the above dbspaces in round-robin mode (exactly > what we are trying to achieve). However, when running one of our I4GL > programs (that just happens to have a report section specifying "order > external by"), we are finding that the sort is not operating correctly. > If we set the UNIX environment variable as follows :- > > DBSPACETEMP=tempdbs1;export DBSPACETEMP > > then rerun the same program, all is sweetness and light. > Experimentation has shown that this program only operates correctly if > a single temp dbspace is defined in the UNIX environment variable, be > it tempdbs1, tempdbs2 or tempdbs3. > > The bizarre thing about the above is that running "onstat -g iof" > whilst running the above program shows that whichever dbspaces are > defined in the UNIX environment variable DO have some activity. > > It's almost as though the engine is having problems gathering together > the results spread across the 3 dbspaces, but I am merely guessing here. > > As ever, any thoughts, comments (even the Clown's !) much appreciated. > > Regards > > Mr Creosote > > Informix Dynamic Server 7.31.UC2 > INFORMIX-4GL Version 7.20.UD7 > INFORMIX-SQL Version 7.20.UE2 > SCO OpenServer 5.0.4 > > -- > "Just a waffer thin mint?" > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

In article <889kan$j0n$1@news.xmission.com>, Alkesh Vipani <alkesh.vipani@wcom.com> wrote: > > Does it happen if you specify comma as delimiter ? If you go to onmonitor > and specify colon it gives error. So, it seems "," is the correct delimiter. > Try and pl. inform me about the result. > Alkesh Vipani. Thanks for the input, Alkesh. I have set the delimiter to comma in both $ONCONFIG and the UNIX Environment variable, but the result is the same. There IS activity on all 3 temp dbspaces but the sort within the I4GL program fails to work correctly. I'm starting to think this is more a 4GL-oriented problem rather than the engine per se. Regards Mr Creosote > ----- Original Message ----- > From: "Mister Creosote" <glynb@my-deja.com> > To: <informix-list@iiug.org> > Sent: Monday, February 14, 2000 6:50 AM > Subject: DBSPACETEMP (<<< sigh >>>) > > > We are experiencing some strange behaviour regarding our use of the > > $ONCONFIG/UNIX Environment parameter DBSPACETEMP. I have followed > > earlier discussions with interest (thanks, Art, for your > > succinct "pecking order" clarification), but am still surprised at the > > results we are finding, as follows :- We have 3 temp dbspaces defined > > as tempdbs1, tempdbs2, and tempdbs3. There was some confusion as to > > which separator to use in the $ONCONFIG file, but I believe EITHER a > > comma or colon will suffice (as per Informix Unleashed) (experiments > > with both would appear to confirm this but I am open to an "official" > > line). We plumped for a colon as follows :- > > > > DBSPACETEMP tempdbs1:tempdbs2:tempdbs3 # Default temp dbspaces > > > > WITHOUT the UNIX environment parameter set, my understanding is that > > the engine will use the above dbspaces in round-robin mode (exactly > > what we are trying to achieve). However, when running one of our I4GL > > programs (that just happens to have a report section specifying "order > > external by"), we are finding that the sort is not operating correctly. > > If we set the UNIX environment variable as follows :- > > > > DBSPACETEMP=tempdbs1;export DBSPACETEMP > > > > then rerun the same program, all is sweetness and light. > > Experimentation has shown that this program only operates correctly if > > a single temp dbspace is defined in the UNIX environment variable, be > > it tempdbs1, tempdbs2 or tempdbs3. > > > > The bizarre thing about the above is that running "onstat -g iof" > > whilst running the above program shows that whichever dbspaces are > > defined in the UNIX environment variable DO have some activity. > > > > It's almost as though the engine is having problems gathering together > > the results spread across the 3 dbspaces, but I am merely guessing here. > > > > As ever, any thoughts, comments (even the Clown's !) much appreciated. > > > > Regards > > > > Mr Creosote > > > > Informix Dynamic Server 7.31.UC2 > > INFORMIX-4GL Version 7.20.UD7 > > INFORMIX-SQL Version 7.20.UE2 > > SCO OpenServer 5.0.4 > > > > -- > > "Just a waffer thin mint?" > > > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.