Re: How can I start Informix SE

On Wed, 16 Sep 1998, Walter S. Tyszka wrote: > On 09/16/1998 Angel wrote: > > I am not new to informix, but I have been working with old online v > > 5.01.UD2. Now Informix has reelase informix SE for linux, and I'd like to > > test it. I have installed all the packages, but there is no tbinit to start > > the database, and dbaccess say something about some environment variable > > that I don't know. This informix came without documentation, so where can I > > get documentation for Informix SE administration, I think the other things > > will be similar to informix online. > > I do not have any first hand experience with Informix SE for linux, but I > doubt that it is much different from Informix SE for any other platform. Correct. > The Informix SE product does not need "started". The tbinit program is only > used with the Informix OnLine Engine products. Also correct. > The following environment variables must be set and exported in order for > Informix SE to work correctly: > > INFORMIXDIR specifies the directory in which the Informix products are loaded. > example: INFORMIXDIR=/usr/informix > PATH specifies the path to find executables. > example: PATH=$PATH:$INFORMIXDIR/bin > DBPATH specifies the path to the database.dbs directory. > example: DBPATH=/usr/db Correct. > SQLEXEC specifies which engine to use (sqlexec for SE, sqlturbo for OE) > example: SQLEXEC=$INFORMIXDIR/lib/sqlexec This only applies to version 5.x and earlier versions. With 6.x and later versions of the software, and specifically with the software available on Linux, there is a different critical environment variable, and that is INFORMIXSERVER, which specifies an entry in the sqlhosts file. There is an auxilliary, non-critical environment variable, INFORMIXSQLHOSTS, which specifies the name of the sqlhosts file if the default, $INFORMIXDIR/etc/sqlhosts, is not correct. You should get some output from: grep "^$INFORMIXSERVER[ ]" ${INFORMIXSQLHOSTS:-$INFORMIXDIR/etc/sqlhosts} # ^^^^^ # blank, tab The notation assumes you've got INFORMIXDIR set; if not, the reference to $INFORMIXDIR shoudl be reworked to ${INFORMIXDIR:-/usr/informix}, but it is better to set $INFORMIXDIR (IMNSHO). For SE, that should normally list seipcpip in the second column, and the machine name returned by hostname in the thrid column, and the fourth column should be sqlexec unless you want to execute some other program. Note that for the seipcpip protocol, the 'service' name is the name of an executable, located in $INFORMIXDIR/lib unless you specify an absolute pathname. Yours, Jonathan Leffler (jleffler@informix.com) #include <witticism.h> Guardian of DBD::Informix v0.60 -- http://www.perl.com/CPAN Informix IDN for D4GL & Linux -- http://www.informix.com/idn