Re: long time to wait until "dbaccess - Database - Select" answers

I would like to reference the following; http://www.iiug.org/forums/ids/index.cgi/noframes/read/10087 Check the following first; tail /etc/netsvc.conf #If the last line look like this? hosts=local,bind #Note: DO NOT do this if you are using IPv6 since changing from "bind" to "bind4" disables the DNS support for IPv6. Since I don't have IPv6 on my network this doesn't cause me any issues. #Change it to be this ; hosts=local,bind4 All of my users come from locations that are in /etc/hosts so DNS should not be used. I have noted that until changing to "bind4" a DNS query is preformed and takes a long time. The DNS server is Windows so I have I have not come up with a different solution (am I not searching for another at this point either). Just so you can compare; /etc> oslevel -s 5300-06-03-0732 /etc> oslevel -r 5300-06 Please let us know if this helps. Eric B. Rowell On Nov 8, 2007 10:55 AM, wjb <w.behnke@uni-bonn.de> wrote: > On 8 Nov., 15:46, "Eric Rowell" <erow...@gmail.com> wrote: > > Start by checking DNS settings... What OS? I have seen a problem > > like this with AIX. > > > > Eric B. Rowell > > > > On Nov 8, 2007 9:20 AM, Paul Watson <p...@oninit.com> wrote: > > > > > > > > > wjb wrote: > > > > Hello, > > > > > > dbaccess - Database - Select > > > > takes about 30 ... 45 seconds to list all 8 databases. > > > > > > After selecting a database it takes the same time to > > > > show the info or the missing connect permission. > > > > > > The same behaviour if the DB-Client calls an external > > > > program that connects to the DB (for example crystal report). > > > > > > Any ideas what could be the reason? > > > > (BTW, we use IDS 10.00.FC4) > > > > > > Thanks, > > > > Werner > > > > > For slow initial connectivity issues check your DNS and/or make sure the > > > servers can resolve locally > > > > > -- > > > Paul Watson > > > Tel: +1 913-400-2620 > > > Mob: +1 913-387-7529 > > > Web:www.oninit.com > > > > > Failure is not as frightening as regret. > > > If you want to improve, be content to be thought foolish and stupid. > > > > > _______________________________________________ > > > Informix-list mailing list > > > Informix-l...@iiug.org > > >http://www.iiug.org/mailman/listinfo/informix-list- Zitierten Text ausblenden - > > > > - Zitierten Text anzeigen - > > > Yes, the OS is AIX: > > aix12:/> oslevel -s > 5300-03-00 > aix12:/> oslevel -r > 5300-03 > aix12:/> > > nslookup can resolve all hosts defined in ~informix/etc/sqlhosts > (except one - but correction of the hostname in sqlhosts and > deleting the line from sqlhosts did not solve the problem) > > regards > Werner > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >