RE: Connecting to new database within Informix Instance

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

Section of onconfig as follows: SERVERNUM 0 # Unique id corresponding to aOnLine 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 indistributed env. RESIDENT 0 # Forced residency flag (Yes = 1, No = 0) MULTIPROCESSOR 1 # 0 for single-processor, 1 formulti-processor #NUMCPUVPS 3 # Number of user (cpu) vps NUMCPUVPS 7 # Number of user (cpu) vps SINGLE_CPU_VP 0 # If non-zero, limit number ofcpu vps to one NOAGE 1 # Process aging AFF_SPROC 0 # Affinity start processor AFF_NPROCS 0 # Affinity number ofprocessors 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