Multiple INFORMIXDIR

Hi, Can i have more d'un one INFORMIXDIR in a the same machine? We are running IDS 7.30 UC7 under AIX 4.3.3 and IDS 7.31.UD6 under AIX 5.1 Tanks for helping. sending to informix-list

"Hamid HABZI" <HHABZI@bmcebank.co.ma> wrote in message news:bttvdv$tv8$1@terabinaries.xmission.com... > > Hi, > Can i have more d'un one INFORMIXDIR in a the same machine? > We are running IDS 7.30 UC7 under AIX 4.3.3 and IDS 7.31.UD6 under AIX 5.1 I'm not *quite* sure what you're asking, as you can't (to my knowledge) run multiple versions of AIX on the same server (unless you're deploying partitions or something similar). But, if you are asking if you can have multiple INFORMIXDIRs, and thereby multiple versions of Informix, on any one system than the answer is yes, this is a quite acceptable technique.

Yes. I've seen testing servers that had many $INFORMIXDIR directories, ... along with multiple $ORACLE_HOME directories. This is also OK with Informix support. Hope this information helps. Brice Avila Minneapolis, Minnesota Hamid HABZI <HHABZI@bmcebank.co.ma> wrote in message news:<bttvdv$tv8$1@terabinaries.xmission.com>... > Hi, > Can i have more d'un one INFORMIXDIR in a the same machine? > We are running IDS 7.30 UC7 under AIX 4.3.3 and IDS 7.31.UD6 under AIX 5.1 > Tanks for helping. > > > sending to informix-list

"Brice Avila" <briceavila@hotmail.com> wrote in message news:c46e3ec5.0401120825.430fa369@posting.google.com... > Yes. I've seen testing servers that had many $INFORMIXDIR directories, > ... along with multiple $ORACLE_HOME directories. This is also OK with > Informix support. Hope this information helps. Indeed, I have some sites where we do this in production. This is necessary where application considerations dictate that an older version of IDS must be used. In one example, the customer has deployed an elderly version of Business Objects which requires a v7 repository, whilst the rest of the estate is v9.

On Mon, 12 Jan 2004 11:53:53 -0500, Five Cats wrote: > In message <btuihr$bfhem$1@ID-162943.news.uni-berlin.de>, Neil Truby > <neil.truby@ardenta.com> writes >>"Brice Avila" <briceavila@hotmail.com> wrote in message >>news:c46e3ec5.0401120825.430fa369@posting.google.com... >>> Yes. I've seen testing servers that had many $INFORMIXDIR directories, ... >>> along with multiple $ORACLE_HOME directories. This is also OK with >>> Informix support. Hope this information helps. >> >>Indeed, I have some sites where we do this in production. This is necessary >>where application considerations dictate that an older version of IDS must >>be used. In one example, the customer has deployed an elderly version of >>Business Objects which requires a v7 repository, whilst the rest of the >>estate is v9. > > I found that V7 of IDS put some links in /usr/bin (or similar) back to > $INFORMIXDIR - I believe there is a work-around for this to allow multiple > versions but can't remember what it is. Just do not rely on the links. Set LD_LIBRARY_PATH to: LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools Art S. Kagel

Art S. Kagel wrote: > On Mon, 12 Jan 2004 11:53:53 -0500, Five Cats wrote: >>Neil Truby <neil.truby@ardenta.com> writes: >>>"Brice Avila" <briceavila@hotmail.com> wrote: >>>>Yes. I've seen testing servers that had many $INFORMIXDIR directories, ... >>>>along with multiple $ORACLE_HOME directories. This is also OK with >>>>Informix support. Hope this information helps. >>> >>>Indeed, I have some sites where we do this in production. This is necessary >>>where application considerations dictate that an older version of IDS must >>>be used. In one example, the customer has deployed an elderly version of >>>Business Objects which requires a v7 repository, whilst the rest of the >>>estate is v9. >> >>I found that V7 of IDS put some links in /usr/bin (or similar) back to >>$INFORMIXDIR - I believe there is a work-around for this to allow multiple >>versions but can't remember what it is. > > Just do not rely on the links. Set LD_LIBRARY_PATH to: > LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/tools Unfortunately, that only works for the regular executables - client programs like SQLCMD - and those do not use the libraries in /usr/lib anyway. The libraries under /usr/lib are for the optical storage manager, ON-Bar backups, and the custom function libraries for the HPL. Setuid root executables do not use LD_LIBRARY_PATH (too much danger of an imposter supplying a library that does what they want it to do and not what the application expects it to do). Additionally, the libraries are mostly loaded explicitly by absolute pathname - /usr/lib/iosm07a.so - and not using a relative pathname - iosm07a.so - so LD_LIBRARY_PATH wouldn't help even if a non-SUID root program was running. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/

Hamid HABZI wrote: > Can i have more d'un one INFORMIXDIR in a the same machine? Yes. I've posted discussions on the subject several times in the past. Try Googling for setixd - April and August 2002 for two such threads. Multiple residency is another plausible term for it. > We are running IDS 7.30 UC7 under AIX 4.3.3 and IDS 7.31.UD6 under AIX 5.1 But not on the same machine at the same time? I have 7.31, 9.21, 9.30, 9.40 all installed (and usually 3 of the 4 running) on my Solaris box. Unix boxes are equivalent for this purpose. The story on Windows might be different - I'd defer to those who use it (IDS on Windows) for real. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/