Re: Connecting to new database within Informix Instance

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 > > > to database server (arcdb). > > > > > >23:38:09 Attempting to bring listener thread down. > > > > > >23:38:09 Server stopped."> > > > > >So what I am asking is, what entries do I need in the > > >$INFORMIXDIR/etc/sqlhosts, $INFORMIXDIR/etc/onconfig and maybe teh > > >/etc/services files for the users to be able to connect to the new > > >archive database. > > > > > >Thanks in advance, > > > > > >Howard > > > > _________________________________________________________________ > > The new MSN 8: smart spam protection and 2 months FREE* > > http://join.msn.com/?page=features/junkmail > > > > sending to informix-list > > _________________________________________________________________ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail sending to informix-list

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 > > > > to database server (arcdb). > > > > > > > >23:38:09 Attempting to bring listener thread down. > > > > > > > >23:38:09 Server stopped."> > > > > > > >So what I am asking is, what entries do I need in the > > > >$INFORMIXDIR/etc/sqlhosts, $INFORMIXDIR/etc/onconfig and maybe teh > > > >/etc/services files for the users to be able to connect to the new > > > >archive database. > > > > > > > >Thanks in advance, > > > > > > > >Howard > > > > > > _________________________________________________________________ > > > The new MSN 8: smart spam protection and 2 months FREE* > > > http://join.msn.com/?page=features/junkmail > > > > > > sending to informix-list > > > > > > _________________________________________________________________ > The new MSN 8: advanced junk mail protection and 2 months FREE* > http://join.msn.com/?page=features/junkmail > > sending to informix-list