Not exactly, but it is possible to override the engine value for each user
by setting the appropriate environment variable.

--
Neil Truby t:01932 724027
Director m:07798 811708
Ardenta Limited e:neil.truby (AT) ardenta (DOT) com

"bil" <bil.gates (AT) microsoft (DOT) com> wrote

some of my jobs are very faster with OPTCOMPIND at 0 and others are faster
with OPTCOMPIND at 2.

is it possible to dynamically change this value ???

With IDS 9.40.UC3, you should have the facility of setting the OPTCOMPIND
dynamically, using a SQL like SET OPTCOMPIND <>

You could wait till then!

Thanks and Regards,
Abhi.
--------------------------------------------------------------------
There are 10 kinds of people,,,,,
..... those who understand binary notations, and those who don't.
--------------------------------------------------------------------





"bil" <bil.gates (AT) microsoft (DOT) com>
Sent by: owner-informix-list (AT) iiug (DOT) org
09/12/2003 07:49 AM
Please respond to "bil"

To: informix-list (AT) iiug (DOT) org
cc:
Subject: OPTCOMPIND


some of my jobs are very faster with OPTCOMPIND at 0 and others are
faster
with OPTCOMPIND at 2.

is it possible to dynamically change this value ???




sending to informix-list

With IDS 9.40.UC3, you should have the facility of setting the OPTCOMPIND
dynamically, using a SQL like SET OPTCOMPIND <>

You could wait till then!

Thanks and Regards,
Abhi.
--------------------------------------------------------------------
There are 10 kinds of people,,,,,
.... those who understand binary notations, and those who don't.
--------------------------------------------------------------------





"bil" <bil.gates (AT) microsoft (DOT) com>
Sent by: owner-informix-list (AT) iiug (DOT) org
09/12/2003 07:49 AM
Please respond to "bil"

To: informix-list (AT) iiug (DOT) org
cc:
Subject: OPTCOMPIND


some of my jobs are very faster with OPTCOMPIND at 0 and others are
faster
with OPTCOMPIND at 2.

is it possible to dynamically change this value ???




sending to informix-list
sending to informix-list

When will that be? (9.40.uc3 release)

Andy Bent

-----Original Message-----
From: Abhishek Mathur [mailto:abhishek (AT) us (DOT) ibm.com]
Sent: Monday, September 15, 2003 10:58 AM
To: bil
Cc: informix-list (AT) iiug (DOT) org; owner-informix-list (AT) iiug (DOT) org
Subject: Re: OPTCOMPIND



With IDS 9.40.UC3, you should have the facility of
setting the OPTCOMPIND
dynamically, using a SQL like SET OPTCOMPIND <>


You could wait till then!


Thanks and Regards,
Abhi.
--------------------------------------------------------------------
There are 10 kinds of people,,,,,
..... those who understand binary notations, and those
who don't.
--------------------------------------------------------------------






"bil" <bil.gates (AT) microsoft (DOT) com>
Sent by: owner-informix-list (AT) iiug (DOT) org
09/12/2003 07:49 AM
Please respond to "bil"
*
******* To:**** informix-list (AT) iiug (DOT) org
******* cc:
******* Subject:******* OPTCOMPIND



some of my jobs are very faster with OPTCOMPIND at 0*
and others are
faster
with OPTCOMPIND at 2.


is it possible to dynamically change this value ???





sending to informix-list

sending to informix-list

The release of IDS 9.40.UC3 should be around 12/09/2003 - EGA (Electronic
General Availability), and 12/22/2003 (GA).

Thanks and REgards,
Abhi.
--------------------------------------------------------------------
There are 10 kinds of people,,,,,
..... those who understand binary notations, and those who don't.
--------------------------------------------------------------------





abent (AT) aetinc (DOT) com
09/15/2003 11:31 AM

To: informix-list (AT) iiug (DOT) org
cc: Abhishek Mathur/Lenexa/IBM@IBMUS
Subject: Re: FW: OPTCOMPIND


When will that be? (9.40.uc3 release)

Andy Bent

-----Original Message-----
From: Abhishek Mathur [mailto:abhishek (AT) us (DOT) ibm.com]
Sent: Monday, September 15, 2003 10:58 AM
To: bil
Cc: informix-list (AT) iiug (DOT) org; owner-informix-list (AT) iiug (DOT) org
Subject: Re: OPTCOMPIND



With IDS 9.40.UC3, you should have the facility of
setting the OPTCOMPIND
dynamically, using a SQL like SET OPTCOMPIND <>


You could wait till then!


Thanks and Regards,
Abhi.
--------------------------------------------------------------------
There are 10 kinds of people,,,,,
..... those who understand binary notations, and those
who don't.
--------------------------------------------------------------------






"bil" <bil.gates (AT) microsoft (DOT) com>
Sent by: owner-informix-list (AT) iiug (DOT) org
09/12/2003 07:49 AM
Please respond to "bil"

To: informix-list (AT) iiug (DOT) org
cc:
Subject: OPTCOMPIND



some of my jobs are very faster with OPTCOMPIND at 0
and others are
faster
with OPTCOMPIND at 2.


is it possible to dynamically change this value ???





sending to informix-list


sending to informix-list