SEO

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 echo hi" and "db2_all db2_all echo hi" OK
Tried to connect to db SAMPLE .....................
alas, a 4 minute delay from DB2CC or db2 client on other server.
Connection via jdbc (DBVisualizer) still 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

On May 6, 7:45 am, danfa...@hotmail.com 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 echo hi" and "db2_all db2_all echo hi" OK
> Tried to connect to db SAMPLE .....................
> alas, a 4 minute delay from DB2CC or db2 client on other server.
> Connection via jdbc (DBVisualizer) still 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. Configuring the server to
use ssh (via DB2RSHCMD=/usr/bin/ssh) only affects db2start/db2stop
processing (and commands invoked by db2_all/rah). After 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? i.e. 'export DB2NODE=0 ; db2 connect to SAMPLE'? What if
you replace 'myhost' in your db2nodes.cfg with the fully-qualified
domain name?

Cheers,
Liam.

On May 6, 2:43*pm, Liam Finnie <lfin...@ca.ibm.com> wrote:
> On May 6, 7:45 am, danfa...@hotmail.com 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 *echo hi" *and "db2_all *db2_all echo hi" * *OK
> > Tried to connect to db SAMPLE .....................
> > alas, a *4 minute delay from DB2CC or db2 client on other server.
> > Connection via jdbc (DBVisualizer) *still 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. *Configuring the server to
> use ssh (via DB2RSHCMD=/usr/bin/ssh) only affects db2start/db2stop
> processing (and commands invoked by db2_all/rah). *After 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? *i.e. 'export DB2NODE=0 ; db2 connect to SAMPLE'? *What 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

Does it also take that long to activate the database? By changing it
to a multipartition database you have increased the memory load on
your server. It is possible that you have overallocated memory on the
machine causing os paging as the database becomes active

On May 7, 1:35 am, danfa...@hotmail.com wrote:
> On May 6, 2:43 pm, Liam Finnie <lfin...@ca.ibm.com> wrote:
>
>
>
> > On May 6, 7:45 am, danfa...@hotmail.com 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 echo hi" and "db2_all db2_all echo hi" OK
> > > Tried to connect to db SAMPLE .....................
> > > alas, a 4 minute delay from DB2CC or db2 client on other server.
> > > Connection via jdbc (DBVisualizer) still 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. Configuring the server to
> > use ssh (via DB2RSHCMD=/usr/bin/ssh) only affects db2start/db2stop
> > processing (and commands invoked by db2_all/rah). After 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? i.e. 'export DB2NODE=0 ; db2 connect to SAMPLE'? What 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

On May 8, 12:48*pm, Lew <seth...@yahoo.com> wrote:
> Does it also take that long to activate the database? *By changing it
> to a multipartition database you have increased the memory load on
> your server. *It is possible that you have overallocated memory on the
> machine causing os paging as the database becomes active
>
> On May 7, 1:35 am, danfa...@hotmail.com wrote:
>
>
>
> > On May 6, 2:43 pm, Liam Finnie <lfin...@ca.ibm.com> wrote:
>
> > > On May 6, 7:45 am, danfa...@hotmail.com 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 *echo hi" *and "db2_all *db2_all echo hi" * *OK
> > > > Tried to connect to db SAMPLE .....................
> > > > alas, a *4 minute delay from DB2CC or db2 client on other server.
> > > > Connection via jdbc (DBVisualizer) *still 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. *Configuring the server to
> > > use ssh (via DB2RSHCMD=/usr/bin/ssh) only affects db2start/db2stop
> > > processing (and commands invoked by db2_all/rah). *After 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? *i.e. 'export DB2NODE=0 ; db2 connect to SAMPLE'? *What 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- Hide quoted text -
>
> - Show quoted text -

Everything works OK locally on the server.
Note also that connect with jdbc is fast.
Even though an initial connect has been made in DB2CC (after a 4
minute delay),
DB2CC performs a new authentication every now and then and each time
it takes 4 minutes.
/dg

Another thing you might check is make sure that the database is
configured explicitly to authentication server on the client. I
didn't think this was an issue any more but maybe it will help.


On May 8, 7:08 am, danfa...@hotmail.com wrote:
> On May 8, 12:48 pm, Lew <seth...@yahoo.com> wrote:
>
>
>
> > Does it also take that long to activate the database? By changing it
> > to a multipartition database you have increased the memory load on
> > your server. It is possible that you have overallocated memory on the
> > machine causing os paging as the database becomes active
>
> > On May 7, 1:35 am, danfa...@hotmail.com wrote:
>
> > > On May 6, 2:43 pm, Liam Finnie <lfin...@ca.ibm.com> wrote:
>
> > > > On May 6, 7:45 am, danfa...@hotmail.com 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 echo hi" and "db2_all db2_all echo hi" OK
> > > > > Tried to connect to db SAMPLE .....................
> > > > > alas, a 4 minute delay from DB2CC or db2 client on other server.
> > > > > Connection via jdbc (DBVisualizer) still 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. Configuring the server to
> > > > use ssh (via DB2RSHCMD=/usr/bin/ssh) only affects db2start/db2stop
> > > > processing (and commands invoked by db2_all/rah). After 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? i.e. 'export DB2NODE=0 ; db2 connect to SAMPLE'? What 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- Hide quoted text -
>
> > - Show quoted text -
>
> Everything works OK locally on the server.
> Note also that connect with jdbc is fast.
> Even though an initial connect has been made in DB2CC (after a 4
> minute delay),
> DB2CC performs a new authentication every now and then and each time
> it takes 4 minutes.
> /dg