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

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.

On 08/11/2007, bozon <curtis@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-list@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

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".

On 09/11/2007, wjb <w.behnke@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-list@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