Re: Connecting to new database within Informix Instance

I thought there would be a way of resolving this problem without the need to change environments and running a seperate "oninit" "Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message news:<c11njt$jlq$1@terabinaries.xmission.com>... > Hi howie. > > It seems no problem for me.(contains /etc/serivces) > > What host are you encountering -930 error ? > i.e) oninit under arcdb ? > OR > oniint under baan ? > if baan, delete arcdb from DBSERVERALIASES. > try the following. > % setenv INFORMIXSERVER baan> > Here is my configuration. > > hostname : cspc08 > sqlhosts > [~/conf]% cat $INFORMIXDIR/etc/sqlhosts > tsutoo930uc3 onsoctcp cspc08 tsutoo930uc3 > tsutoo731ud6_tcp onsoctcp guntank 32488 > tsutoo940uc2_tcp onsoctcp cspc08 32445> > I use tsutoo930uc3(DBSERVERNAME) on cspc08 > So I execute oninit command as following environment. > > INFORMIXDIR=/usr/local/informix/ids930uc3 > PATH=$INFORMIXDIR/bin:$PATH > INFORMIXSERVER=tsutoo930uc3 > > % oninit> > hostname : guntank > % cat $INFORMIXDIR/etc/sqlhosts> tsutoo731ud6_tcp ontlitcp guntank 32488> > I use tsutoo731ud6_tcp(DBSERVERNAME) on guntank > So I execute oninit command as following environment. > > INFORMIXDIR=/usr/local/informix/ids731ud6 > PATH=$INFORMIXDIR/bin:$PATH > INFORMIXSERVER=tsutoo731ud6_tcp > > % oninit> > Regards. > > -- > Tsutomu Ogiwara from Tokyo Japan. > ICQ#:168106592 > > > > > > >From: howie_lfc@hotmail.com (howie) > >Reply-To: howie_lfc@hotmail.com (howie) > >To: informix-list@iiug.org > >Subject: Re: Connecting to new database within Informix Instance > >Date: 18 Feb 2004 09:03:21 -0800 > > > >arcdb has now been added to the /etc/hosts file under the "baan" entry. > >and I am now able to ping the address. > > > >Now what to do ? > > > >Add an alias to the onconfig as before? > > > >"DBSERVERALIASES baantcp,arcdb # List of alternate dbservernames" > > > >Add an entry to $INFORMIXSERVER/etc/sqlhosts? > > > >baanshm onipcshm baan baanshm > >baantcp onsoctcp baan baantcp m=1 > >baantcp onsoctcp arcdb baantcp m=1> > > >What about the /etc/services file? > > > > > >"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message > >news:<c0ul5q$vtc$1@terabinaries.xmission.com>... > > > Hi again. > > > > > > Execute the following command. > > > > > > /usr/sbin/ping arcdb > > > > > > e.g) > > > etorofu 27: /usr/sbin/ping bygzam -n 3 > > > PING bygzam: 64 byte packets > > > 64 bytes from 172.16.105.171: icmp_seq=0. time=6. ms > > > 64 bytes from 172.16.105.171: icmp_seq=1. time=0. ms > > > 64 bytes from 172.16.105.171: icmp_seq=2. time=0. ms > > > > > > ----bygzam PING Statistics---- > > > 3 packets transmitted, 3 packets received, 0% packet loss > > > round-trip (ms) min/avg/max = 0/2/6 > > > > > > If you can not correct result from ping, resolve hostname first. > > > > > > Regards. > > > -- > > > Tsutomu Ogiwara from Tokyo Japan. > > > ICQ#:168106592 > > > > > > > > > > > > > > > > > > >From: "howard jones" <howie.lfc@virgin.net> > > > >Reply-To: "howard jones" <howie.lfc@virgin.net> > > > >To: informix-list@iiug.org > > > >Subject: Re: Connecting to new database within Informix Instance > > > >Date: Tue, 17 Feb 2004 14:05:07 -0000 > > > > > > > >Section of onconfig as follows: > > > > > > > >SERVERNUM 0 # Unique id corresponding > to a> > > >OnLine instance > > > >DBSERVERNAME baanshm # Name of default database server > > > >DBSERVERALIASES baantcp # List of alternate dbservernames> > > >#NETTYPE ipcshm,1,50,NET # Comment this out as it isn't > > > >needed > > > >#NETTYPE soctcp,2,300,CPU # Configure poll thread(s) > for > > > >nettype > > > >NETTYPE soctcp,2,300,NET # New settings > > > >NETTYPE sqlmux,1,100,CPU # SQLMUX setting > > > >DEADLOCK_TIMEOUT 60 # Max time to wait of lock in> > > >distributed env. > > > >RESIDENT 0 # Forced residency > flag > > > >(Yes = 1, No = 0) > > > > > > > >MULTIPROCESSOR 1 # 0 for single-processor, 1 for> > > >multi-processor > > > >#NUMCPUVPS 3 # Number of user (cpu) vps > > > >NUMCPUVPS 7 # Number of user (cpu) > vps > > > >SINGLE_CPU_VP 0 # If non-zero, limit number > of> > > >cpu vps to one > > > > > > > >NOAGE 1 # Process aging > > > >AFF_SPROC 0 # Affinity start > processor > > > >AFF_NPROCS 0 # Affinity number of> > > >processors > > > > > > > >Sqlhosts Info as follows ( hashed out entry prevented server reload ): > > > > > > > >baanshm onipcshm baan baanshm > > > >baantcp onsoctcp baan baantcp m=1 > > > >#arcdbtcp onsoctcp arcdb arcdbtcp m=1 > > > >newser onsoctcp baan newser> > > > > > > >Entries in "/etc/services" including the one for the new database > "arcdb" > > > > > > > >baanshm 6500/tcp # Informix instance SHM connection > > > >baantcp 6501/tcp # Informix instance TCP connection > > > >arcdbtcp 6505/tcp # Informix Archive TCP connection > > > > > > > >"Tsutomu Ogiwara" <tsutomu_ogiwara@hotmail.com> wrote in message > > > >news:c0t24b$fse$1@terabinaries.xmission.com... > > > > > > > > > > Hi Howard. > > > > > > > > > > Can you post your sqlhosts,DBSERVERALIAS of oncofig and > /etc/services ? > > > > > > > > > > Regards. > > > > > > > > > > -- > > > > > Tsutomu Ogiwara from Tokyo Japan . > > > > > ICQ#:168106592 > > > > > > > > > > > > > > > >From: howie_lfc@hotmail.com (howie) > > > > > >Reply-To: howie_lfc@hotmail.com (howie) > > > > > >To: informix-list@iiug.org > > > > > >Subject: Connecting to new database within Informix Instance > > > > > >Date: 17 Feb 2004 02:33:01 -0800 > > > > > > > > > > > >Informix 9.21.FC4 > > > > > >HPUX 11.0 > > > > > > > > > > > >Hello all, > > > > > > > > > > > >DFirstly I wish to thank eveyone who helped me populate the archive > > > > > >database on our Informix system. All went well over the last > weekend > > > > > >and we now have a live and an Archive database within the same > > > > > >Informix instance. > > > > > > > > > > > >The problem I am now having is connecting to the new database. > > > > > > > > > > > >I have tried putting entries in the $INFORMIXDIR/etc/sqlhosts file > and > > > > > >using the DBSERVERALIAS parameter within the > $INFORMIXDIR/etc/onconfig > > > > > >file but all this did was prevent the In