long time to wait until "dbaccess - Database - Select" answers
Posted in 2007
Werner reported that dbaccess database selection and connections took 30 to 45 seconds on IDS 10.00.FC4 on AIX. Paul Watson and Eric Rowell advised checking DNS and local name resolution. Werner said nslookup resolved all hosts in sqlhosts except one, and fixing that did not help. The last message was garbled and empty. Unresolved.
Topics: Server Administration, Versions, Editions & End-of-Life
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
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.
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 <paul@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-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>
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