Re: NET connection problems

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