Slow connections & Select database

Hi, we are having problems with slow connections on our informix database. It is IDS Version 9.21.UC1, running on SunOS 5.7 It takes a long time to connect from clients but also when running dbaccess on the actual database server. The usual scenario seems to be - Run 'dbaccess' on its own - starts quickly Run 'dbaccess dbname' - very slow Once in dbaccess, trying to Select Database - very slow First connection to any database - very slow All subsequent connections to databases - fine I've tried both shm connections and tcp connections on the db server, and the shm are a bit slow (few secs) but tcp are much worse (can be over a minute). The load averages on the server are small (round about 0.15 at the most) and it is not short of memory. I have tried putting the ip address in the sqlhosts instead of the hostname (we already did this on the client machines) but it seemed to make no difference. My colleague checked dns lookup times and they seem fine. The database has been in use at least a couple of years and has only developed this problem in the last few weeks. Nothing has changed in the config as far as I know. We have had this in the message log this morning : 09:40:34 listener-thread: err = -25582: oserr = 9: errstr = : Network connection is broken. System error = 9. But the network shouldn't affect the running of dbaccess on the dbserver ... should it ..?? Help! Can anyone explain to me why it should be so slow to find the databases, or tell me what I should be looking at ? Thanks ever so much Rosemary Rhodes

Rosie Rhodes wrote: > Hi, > we are having problems with slow connections on our informix database. > It is IDS Version 9.21.UC1, running on SunOS 5.7 > It takes a long time to connect from clients but also when running dbaccess > on the actual database server. > > The usual scenario seems to be - > Run 'dbaccess' on its own - starts quickly > Run 'dbaccess dbname' - very slow > Once in dbaccess, trying to Select Database - very slow > First connection to any database - very slow > All subsequent connections to databases - fine > > I've tried both shm connections and tcp connections on the db server, and > the shm are a bit slow (few secs) but tcp are much worse (can be over a > minute). > The load averages on the server are small (round about 0.15 at the most) > and it is not short of memory. > > I have tried putting the ip address in the sqlhosts instead of the hostname > (we already > did this on the client machines) but it seemed to make no difference. > My colleague checked dns lookup times and they seem fine. > Did s/he check reverse DNS? -- Clive

Rosie Rhodes wrote: > Hi, > we are having problems with slow connections on our informix database. > It is IDS Version 9.21.UC1, running on SunOS 5.7 You should definitely upgrade! > It takes a long time to connect from clients but also when running dbaccess > on the actual database server. > > The usual scenario seems to be - > Run 'dbaccess' on its own - starts quickly > Run 'dbaccess dbname' - very slow > Once in dbaccess, trying to Select Database - very slow > First connection to any database - very slow > All subsequent connections to databases - fine > > I've tried both shm connections and tcp connections on the db server, and > the shm are a bit slow (few secs) but tcp are much worse (can be over a > minute). > The load averages on the server are small (round about 0.15 at the most) > and it is not short of memory. > > I have tried putting the ip address in the sqlhosts instead of the hostname > (we already > did this on the client machines) but it seemed to make no difference. > My colleague checked dns lookup times and they seem fine. > > The database has been in use at least a couple of years and has only > developed this > problem in the last few weeks. Nothing has changed in the config as far as I > know. > We have had this in the message log this morning : > 09:40:34 listener-thread: err = -25582: oserr = 9: errstr = : Network > connection is broken. > System error = 9. > But the network shouldn't affect the running of dbaccess on the dbserver ... > should it ..?? > > Help! > Can anyone explain to me why it should be so slow to find the databases, or > tell me > what I should be looking at ? > > Thanks ever so much > Rosemary Rhodes I think you're right to suspect DNS. Here are some ideas. There are two things that have to happen DNS-wise when you connect to the server: the client machine must look up the server's IP address and the server does a reverse look-up the client's. If your client (dbaccess) is run on the server then the server performs both roles. Changing sqlhosts to include an IP address only helps the client end of things find the server's IP address by avoiding a forward DNS look-up. The server will still do a reverse DNS look-up on the client and this is often the cause of delays. It would be interesting to see /etc/hosts and /etc/resolv.conf I would expect to see the server's hostname and all its aliases, e.g. server, server.domain etc. in hosts and for all DNS servers to be responsive. Has the configuration of your DNS server changed recently. Ben.

Sorry to top post... rDNS or reverse DNS shouldn't have any impact on this. If you want to check for network latency, you can do a series of ping(s) from the client to the server and if you want to get fancy, do a traceroute as well. This will not only tell you the network latency but also the path from the client to the server. Since Rosie indicated that the process is running slow on the server as well as on the client, then we can be sure that its not the network. Had the speed changed when going from shared memory to tcp/ip, we could have suspected that there was something like a firewall on the server which may be causing some of the problems. If we're going to focus on the server, then you will want to run top -s1. This will indicate the current system load updated every second. (You could also run an xload too for a graphical comparision.) Now the next set of questions. SunOs 5.7 is which flavor of Solaris? How backdated it that? Then look at the IDS config. The point is to issolate the trouble by ruling out what we know from what we don't know. Since we've ruled out the network, the client, we need to focus on the server. How does Rosie handle authentication? LDAP? PAM? NIS/YP? or std Unix authentication? Is dbaccess slow for everyone or just this specific user? (Simple test, create an account that's on the server but not in LDAP or NIS, assuming that they are using LDAP or NIS.) This would indicate that there was some sort of delay in authentication. Did Rosie try a different database? Since dbaccess comes up fast, then slows down when connecting to a specific database, what happens when she connects to a different database? If it also slows down, then we have to look at the server's configuration vs the system's configuration. Does that make sense? -G >From: Clive Eisen <clive@serendipita.com> >Rosie Rhodes wrote: > > Hi, > > we are having problems with slow connections on our informix database. > > It is IDS Version 9.21.UC1, running on SunOS 5.7 > > It takes a long time to connect from clients but also when running >dbaccess> > on the actual database server. > > > > The usual scenario seems to be - > > Run 'dbaccess' on its own - starts quickly > > Run 'dbaccess dbname' - very slow > > Once in dbaccess, trying to Select Database - very slow > > First connection to any database - very slow > > All subsequent connections to databases - fine > > > > I've tried both shm connections and tcp connections on the db server, >and > > the shm are a bit slow (few secs) but tcp are much worse (can be over a > > minute). > > The load averages on the server are small (round about 0.15 at the most) > > and it is not short of memory. > > > > I have tried putting the ip address in the sqlhosts instead of the >hostname > > (we already > > did this on the client machines) but it seemed to make no difference. > > My colleague checked dns lookup times and they seem fine. > > >Did s/he check reverse DNS? > >-- >Clive >_______________________________________________ >Informix-list mailing list >Informix-list@iiug.org >http://www.iiug.org/mailman/listinfo/informix-list _________________________________________________________________ The average US Credit Score is 675. The cost to see yours: $0 by Experian. http://www.freecreditreport.com/pm/default.aspx?sc=660600&bcd=EMAILFOOTERAVERAGE

What Ben said - reverse DNS. -- Neil Truby t:01932 724027 Director m:07798 811708 Ardenta Limited e:neil.truby@ardenta.com "Rosie Rhodes" <rosemary@spider-networks.net> wrote in message news:HONQh.214$xm4.23@newsfe3-win.ntli.net... > Hi, > we are having problems with slow connections on our informix database. > It is IDS Version 9.21.UC1, running on SunOS 5.7 > It takes a long time to connect from clients but also when running > dbaccess on the actual database server. > > The usual scenario seems to be - > Run 'dbaccess' on its own - starts quickly > Run 'dbaccess dbname' - very slow > Once in dbaccess, trying to Select Database - very slow > First connection to any database - very slow > All subsequent connections to databases - fine > > I've tried both shm connections and tcp connections on the db server, and > the shm are a bit slow (few secs) but tcp are much worse (can be over a > minute). > The load averages on the server are small (round about 0.15 at the most) > and it is not short of memory. > > I have tried putting the ip address in the sqlhosts instead of the > hostname (we already > did this on the client machines) but it seemed to make no difference. > My colleague checked dns lookup times and they seem fine. > > The database has been in use at least a couple of years and has only > developed this > problem in the last few weeks. Nothing has changed in the config as far as > I know. > We have had this in the message log this morning : > 09:40:34 listener-thread: err = -25582: oserr = 9: errstr = : Network> connection is broken. > System error = 9. > But the network shouldn't affect the running of dbaccess on the dbserver > ... should it ..?? > > Help! > Can anyone explain to me why it should be so slow to find the databases, > or tell me > what I should be looking at ? > > Thanks ever so much > Rosemary Rhodes > >