Re: Connecting to new database within Informix Instance
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/sqlhoststsutoo731ud6_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 Instance from coming up after
>a
> > > > >reboot, with the following error in the online.log
> > > > >
> > > > >"Sun Feb 15 23:37:58 2004
> > > > >
> > > > >23:37:58 Event alarms enabled. ALARMPROG =
> > > > >'/home/informix/etc/log_full.sh'
> > > > >23:37:58 Booting Language <c> from module <>
> > > > >23:37:58 Loading Module <CNULL>
> > > > >23:37:58 Booting Language <builtin> from module <>
> > > > >23:37:58 Loading Module <BUILTINNULL>
> > > > >23:38:09 Informix Dynamic Server 2000 Version 9.21.FC4
> > > > >23:38:09 listener-thread: err = -930: oserr = 0: errstr = arcdb:> > > > >Cannot connect