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...@[EMAIL PROTECTED]
wrote:
> On May 6, 2:43 pm, 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 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. 'ex****t 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
|
