On May 6, 2:43=A0pm, Liam Finnie <lfin...@[EMAIL PROTECTED]
> wrote:
> On May 6, 7:45 am, danfa...@[EMAIL PROTECTED]
wrote:
>
>
>
>
>
> > Hi!
>
> > I have a previous post on the subject that connect takes a long time.
>
> > I uninstalled db2 completely.
> > Installed V9.5
> > Installed fixpack 1
> > created das
> > created an instance
> > installed database sample.
> > Tested to connect to sample from DB2 CC - Worked OK
> > Stopped db2.
> > configured UDB to use Openssh following Liam Finnies step-by-step
> > guide
> > Updated db2nodes.cfg:
> > 0 myhost 0
> > 1 myhost 1
> > 2 myhost 2
> > Started db2
> > tested "db2_all =A0echo hi" =A0and "db2_all =A0db2_all echo hi" =A0
=A0O=
K
> > Tried to connect to db SAMPLE .....................
> > alas, a =A04 minute delay from DB2CC or db2 client on other server.
> > Connection via jdbc (DBVisualizer) =A0still works OK
> > Obviously, the partitioning feature or ssh has something to do with
> > the problem.
>
> > We have a similar configuration in our test environment but on V9.1
> > and it works OK.
> > /dg
>
> Hello,
>
> I can't say where the delay is coming from.... but I can say that it's
> not from configuring the server to use ssh. =A0Configuring the server to
> use ssh (via DB2RSHCMD=3D/usr/bin/ssh) only affects db2start/db2stop
> processing (and commands invoked by db2_all/rah). =A0After that point,
> FCM is used to communicate between the different database partitions.
> So, connecting to a database will not involve ssh (at least on the
> server), so the delay must be coming from somewhere else.
>
> Do you see the same delay if you explicitly select a partition to
> connect to? =A0i.e. 'ex****t DB2NODE=3D0 ; db2 connect to SAMPLE'?
=A0What =
if
> you replace 'myhost' in your db2nodes.cfg with the fully-qualified
> domain name?
>
> Cheers,
> Liam.- Hide quoted text -
>
> - Show quoted text -
Thanks Liam, but none of the suggested changes made any difference.
I will open a PMR
/dg
|
