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

On 9 Nov, 11:39, "Keith Simmons" <smile...@googlemail.com> wrote: > On 09/11/2007, wjb <w.beh...@uni-bonn.de> wrote: > > > > > On 9 Nov., 09:59, "Keith Simmons" <smile...@googlemail.com> wrote: > > > On 08/11/2007, bozon <cur...@crowson1.com> wrote: > > > > > On Nov 8, 7:49 am, wjb <w.beh...@uni-bonn.de> 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 > > > > > We had this problem when we were testing a concept with hundreds of > > > > databases. If you have many databases then try researching and > > > > increasing the DD_HASHSIZE, DS_HASHSIZE and DD_HASHMAX parameters. > > > > > _______________________________________________ > > > > Informix-list mailing list > > > > Informix-l...@iiug.org > > > >http://www.iiug.org/mailman/listinfo/informix-list > > > > Werner > > > > Do you have a mixture of NT4 and W2K Servers in your resolve.conf? If > > > so remove the NT Servers (if possible) as they cannot handle IPV6 > > > that AIX uses as default for getaddrinfo(). If this is not possible > > > then change /etc/netsvc.conf file to include hosts=local4,bind4 which > > > will also eliminate IPV6 lookups. > > > > Keith- Zitierten Text ausblenden - > > > Hello all, > > > our problem could be solved either by changing the /etc/netsvc.conf: > > old: > > hosts=local,bind > > new: > > hosts=local,bind4 > > > or by deleting a line with an inactive nameserver in /etc/resolv.conf > > > Thanks a lot for all help! > > best regards > > Werner > > > BTW: > > > As it was the third nameserver entry I deleted (an inactive BIND on a > > BSD-System) > > one could assume that the resolver has a problem with the first two > > mentioned nameservers > > (W2K-Server) but nslookup works well. > > > Furthermore all informix-server are listed in the /etc/hosts. Strange > > that DNS is called > > despite the order "local,bind". > > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list > > Werner > > The problem isn't particularly with nslookup but rather with > getaddrinfo which goes out to DNS regardless of the order in > netsvc.conf! > > Keith- Hide quoted text - > > - Show quoted text - So nslookup does something different to getaddrinfo?