Re: Bringing up a new instance of Informix

From: ram_cnc <rsivaguru@my-deja.com> > >I am configuring a new instance of informix 9.20 UC1. I am having >problems if I add DBSERVERALIASES. > >I have the 9.14 and 7.31 configured and working properly. > >The /etc/services entries on the HP box (starfish) looks like: > >sqlexec_1544 1544/tcp # For the new 9.20 Instance >sqlexec_star 1542/tcp # Existing 9.14UC7 Instance >sqlexec 1543/tcp # Existing 7.31UC4 Instance > >The sqlhosts file for the new 9.20 instance looks like: > >star_ius_shm onipcshm starfish star_ius_shm >star_ius_soc onsoctcp starfish sqlexec_1544 >star2_ods_soc onsoctcp starfish sqlexec> >The sqlhost file for the existing 9.14 instance looks like: >honor_ius_shm onipcshm starfish honor_ius_shm >honor_ius_soc onsoctcp starfish sqlexec_star >star2_ods_soc onsoctcp starfish sqlexec> >The sql host file for the existing 7.31 instance looks like: > >star2_ods_shm onipcshm starfish star2_ods_shm >star2_ods_soc onsoctcp starfish sqlexec >honor_ius_soc onsoctcp starfish sqlexec_star> >The config entries from the onconfig file are:(9.20 instance) > >SERVERNUM 15 # Unique id corresponding to a OnLine>instance >DBSERVERNAME star_ius_shm # Name of default database server >DBSERVERALIASES star_ius_soc # List of alternate dbservernames >NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for nettype >NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype> >The online.log message entries are: > >17:07:53 listener-thread: err = -931: oserr = 0: errstr =>sqlexec_1544: Cannot locate sqlexec_1544 service/tcp service in >/etc/services. > >17:07:53 Attempting to bring listener thread down. > >17:07:53 Server stopped. > >17:07:53 Informix Dynamic Server 2000 Stopped. >17:07:53 mt_shm_remove: WARNING: may not have removed all/correct>segments > >The onconfig entries from the 9.14 instance: > >SERVERNUM 12 # Unique id corresponding to a OnLine>instance >DBSERVERNAME honor_ius_shm # Name of default database server >DBSERVERALIASES honor_ius_soc # List of alternate dbservernames > >NETTYPE ipcshm,1,50,CPU # Configure poll thread(s) for nettype >NETTYPE soctcp,1,50,NET # Configure poll thread(s) for nettype> > >The onconfig entries for the 7.31 instance: > >SERVERNUM 11 # Unique id corresponding to a OnLine>instance >DBSERVERNAME star2_ods_shm # Name of default database server >DBSERVERALIASES star2_ods_soc # List of alternate dbservernames >NETTYPE ipcshm,1,50,NET # Configure poll thread(s) for nettype >NETTYPE soctcp,1,50,CPU # Configure poll thread(s) for nettype> >I am pretty sure that I have left out some thing. > >Appreciate your valuable time and input. Nothing definite springs to mind. Are you sure that 1544 isn't already in use, and are you sure 9.20 uses sockets, not TLI? Good luck! ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com