Re: NET connection problems

In article <35216294.2A22@bloomberg.com>, kagel@bloomberg.com wrote: > > richard_kofler@edvg.co.at wrote: > > > > We are constantly encountering net connection problems, where should > > we start to investigate? > > > > machine: SNI RM600 V5.43 / INFORMIX V7.12 UC1 > > up to 70 PCs connected via Ethernet > > > > We are running 2 CPUVPs and 4 NETVPs on a 3 CPU machine with 512 MB memory, > > this gives us 4 tlitcppoll threads & 9 tlitcplst threads. > > The machine has 3 ethernet boards > > We have KIO support and 1 AIOVP only & that looks good. > > ( 2 KIO queues, as we have 2 CPUVPs, load is balanced)) > > > > Connection type is TLI > > > > This is our NETTYPE Statement > > NETTYPE tlitcp,4,40,NET # Override sqlhosts nettype parameters> > This is some of the other $ONCONFIG lines, maybe influencing this behavior > > SERVERNUM 1 # Server Number > > DBSERVERNAME I4080001 # Database Server > > DBSERVERALIASES s40800011,0.s1,1.s1,I4080002,0.I1,1.I1,0.I2,1.I2 #> > In your sqlhosts file I assume that I4080001 is defined as a shared > memory connection (onipcshm) and that the others are networked > (ontlitcp). How are you trying to connect from the PCs? With what > INFORMIXSERVER name? If I4080001 that will only work if you change the > service on the clients for I4080001 to one of the services used by a > networked connection. Do you have UNIQUE services for each connection > alias and for the DBSERVERNAME (you must)? > > So your sqlhosts on the server should show (in part): > > I4080001 onipcshm sni1 sqlmemsvc > s40800011 ontlitcp sni1 sqlnetsvc1 > O.s1 ontlitcp sni1 sqlnetsvc2 > ...> > On the client though, in setnet32, you can use: > > Host Servername Protocol Service > ------ ---------- -------- ------- > sni1 s40800011 olsoctcp sqlnetsvc1 > sni1 I4080001 olsoctcp sqlnetsvc1 > snil O.s1 olsoctcp sqlnetsvc2 > > Art S. Kagel > Hi, Art, thank you for listening! No, we run TLI connections only. There are no ipc shared memory connections at all. We startet the project on INFORMIX Version 6 and our port did not support shm connections (I can not verify this, it was before I joined) Anyway, this is a typical setup on the PC hosts: 127.0.0.1 localhost 194.37.184.66 s4080001 # ceres: used by inf_svc 194.37.228.2 cs_s0000004 # ceres: used by ief_svc 194.37.229.74 cs_s0000001 # ceres: used by ief_svc 194.37.228.5 cs_s0000012 # ceres: used by ief_svc 194.37.106.130 cs_s0010001 # ceres: used by ief_svc 194.37.106.34 cs_s0020001 # ceres: used by ief_svc ..... this is followed by all the other server machines (99 of them) informix.ini: [INET_CONNECTION] user=AMSDBUSR1 service=ifx1 protocol=tcp-ip Host=s4080001 Passwd=XX 32 32 32 32 33 34 35 36 47 48 49 50 90 90 99 99 99 99 [INET_PROTOCOL] tcp-ip=INETWSOK.DLL ipx=INETIPX.DLL pipe=inetwpip.DLL [ENVIRONMENT] informixdir=C:\\INF TMBlockMode=1 DBNLS=2 COLLCHAR=1 ConnChecker=On ShowCheckerIcon=On DbDate=DMY40 ------------------------------------------------------------------ On unix we have: /etc/inetd/hosts (excerpted) 194.37.184.66 s1 s4080001 194.37.184.130 0.s4080001 194.37.185.66 1.s4080001 sqlhosts s40800011 ontlitcp s1 ifx0 0.s1 ontlitcp 0.s4080001 ifx0 1.s1 ontlitcp 1.s4080001 ifx0 s40800021 ontlitcp s2 ifx0 0.s2 ontlitcp 0.s4080002 ifx0 1.s2 ontlitcp 1.s4080002 ifx0 I4080001 ontlitcp s1 ifx1 I4080002 ontlitcp s1 ifx2 0.I1 ontlitcp 0.s4080001 ifx1 1.I1 ontlitcp 1.s4080001 ifx1 0.I2 ontlitcp 0.s4080001 ifx2 1.I2 ontlitcp 1.s4080001 ifx2 s00000011 ontlitcp s0000001 ifx0 I0000001 ontlitcp s0000001 ifx1 I0000002 ontlitcp s0000001 ifx2 and the relevant part of /etc/services is # INFORMIX ifx0 22222/tcp # Informix Service (CERES) ifx1 22223/tcp # Informix Service ifx2 22224/tcp # Informix Service ifx3 22225/tcp # Informix Service The hostname of the unix machine is 's1' What do I miss here ? Regards Dick Richard Kofler EDVg-debis Systemhaus Vienna, Austria e-mail: richard_kofler@edvg.co.at -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading