RE: Multiple informix installations.

Out of interest, what makes you think that a database server is installed on the machine you are using? Could it be you are using standard engine instead of IDS [See if oninit program is in $INFORMIXDIR/bin]. For standard engine look for $INFORMIXDIR/bin/sqlexec. Run the following command to see if IDS is currently running: Ps -ef |grep oninit. This will show you that the server is running. I presume you have programs that run against the database. Check the user environment for one of these programs to see how its set. Check for the configuration variables mentioned in other responses. Mark -----Original Message----- From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] On Behalf Of TBP Sent: Tuesday, February 08, 2005 4:00 PM To: informix-list@iiug.org Subject: Re: Multiple informix installations. Nuno Paquete wrote: > Hi, > Thanks a lot for the answer. > >>It may sound real rude but i think you need to go on an Informix DBA >>training course. > > Perhaps you're wright, but I've been reading the manuals (from IBM website) > and the sequence for starting and using the server is: > - oninit (returns: "Message 12759 not found.") > - onstat (returns: "GLS initialization failed, error -23101") > > Please help me if this is not wright. All I want to do is to start using the > database. > I repeat, the database is running, I'm sure of that because the software > that uses it (on windows machines) works perfectly, but I want to make some > queries to the database, see the relationships between tables, and so on. > > >>INFORMIXDIR >>INFORMIXSERVER >>ONCONFIG >>PATH >>INFORMIXSQLHOSTS > > > I've seen this variables and here is the result: > > [/informix]echo $INFORMIXDIR > /informix > [/informix]echo $INFORMIXSERVER > > [/informix]echo $ONCONFIG > > [/informix]echo $INFORMIXSQLHOSTS > > [/informix]echo $PATH > /informix/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/informix/bin:/usr/bin/X1 1:/sbin:. > > As you can see, not all the variables are configured. > Please help me!! Show me what I should do! > I've been following the instructions of the manuals but I'm not getting > success!! > > Thanks in advance. > > Right, so you have the informix product installed in the following directory (or more specifically you have $INFORMIXDIR set to) : /informix $INFORMIXSQLHOSTS isn't compulsory, the default location for the sqlhosts file is $INFORMIXDIR/etc/sqlhosts have a look in here for clues as to what your $INFORMIXSERVER values could be :D You will have one or more lines per Informix Server (each server can have several connection protocols). Then you need to have a $ONCONFIG which is the configuration file for the $INFORMIXSERVER, this is also located in the $INFORMIXDIR/etc directory, but could be any name at all (however it is general practice to name it onconfig.<servername>. What userid are you doing this as? You may have a "default" environment if you su - informix. If you want some more clues post the $INFORMIXDIR/etc/sqlhosts file and also ls -latr /INFORMIXTMP. sending to informix-list

Hi Mark, Thanks for the answer. > Out of interest, what makes you think that a database server is > installed on the machine you are using? Because I know it is!! > Run the following command to see if IDS is currently running: > > Ps -ef |grep oninit. This will show you that the server is running. [/informix/etc]ps -ef | grep oninit root 11356 11872 0 07:09:28 - 0:01 /informix/bin/oninit root 11872 1 11 07:09:25 - 24:16 /informix/bin/oninit root 12648 11356 0 07:09:29 - 0:00 /informix/bin/oninit root 13184 11356 0 07:09:28 - 0:00 /informix/bin/oninit root 13438 11356 1 07:09:28 - 10:57 /informix/bin/oninit root 13682 11356 0 07:09:30 - 0:00 /informix/bin/oninit root 13932 11356 0 07:09:31 - 0:20 /informix/bin/oninit ..... > > I presume you have programs that run against the database. Check the > user environment for one of these programs to see how its set. [/home/Carlos]ls 4js.profile fglserver.var [/home/Carlos]cat fglserver.var 192.168.1.15:0 [/home/Carlos]cat 4js.profile #=============================================================== #*** INFORTRANS *** *** Utilizador *** #=============================================================== #====================== DIRECTORIA INSTALACAO ================== #TRADM=`grep "^trans4js:" /etc/passwd | cut -d: -f6` TRADM=/transitos #====================== MODO =================================== MODE4GL=4JS #MODE4GL=RDS #MODE4GL=4GL export MODE4GL TRADM #====================== PROFILE ================================ trap : 2 if [ "$TRANSIT" = "" ] then TRANSIT=$TRADM export TRANSIT fi . $TRANSIT/bin/PROFILE.usr AMADM=$GTLIB export AMADM echo $FGLSERVER > $HOME/fglserver.var $GTSAI $TRSAI #=============================================================== Is this information important?? Thank you very much.