connect to db2 9.5 server slow

[Dan van Ginhoven]

Hi!

I have installed a new Db2 V9.5 fp1 Linux 64 bit with a partioned database.

When I connect to the database using DB2Visualizer on Windows, that uses db2jcc, it works OK.

Connecting from DB2 Control Center takes 4-5 minutes, but it connects. Opening a table can take 4-5 minutes too.
Connecting thru a Linux DB2 Client also takes 4-5 minutes, but after that table access seems OK.
I compared dbm cfg with a working db2 server but did'nt find any significant differences.

Where do I start looking? Tried to Google, but did'nt find any obvious answers.
Something with the authentication process?

Mvh
/dg

[Frank Swarbrick]

Re: connect to db2 9.5 server slow

Do you have a firewall blocking access to port 523? It looks like Control
Center first tries to connect to this port, and only later goes to the port
the instance is listening on. So if port 523 is blocked you have a delay
(though not 4 or 5 minutes, in my experience.)

Based on your comment that you have the same issue with a Linux DB2 Client
other than CC makes me think this is *not* the issue, but I just thought I'd
put it out there.

Frank

n 4/29/2008 at 7:48 AM, in message <VGFRj.6709$R_4 .5308@newsb.tel ia.net>,
Dan van Ginhoven<danfan 46@hotmail.comw rote:

Hi!
>
I have installed a new Db2 V9.5 fp1 Linux 64 bit with a partioned
database.
>
When I connect to the database using DB2Visualizer on Windows, that
uses db2jcc, it works OK.
>
Connecting from DB2 Control Center takes 4-5 minutes, but it connects.
Opening a table can take 4-5 minutes too.
Connecting thru a Linux DB2 Client also takes 4-5 minutes, but after that

table access seems OK.
I compared dbm cfg with a working db2 server but did'nt find any
significant differences.
>
Where do I start looking? Tried to Google, but did'nt find any obvious
answers.
Something with the authentication process?
>
Mvh
/dg

[Mark A]

Re: connect to db2 9.5 server slow

"Dan van Ginhoven" <danfan46@hotma il.comwrote in message
news:VGFRj.6709 $R_4.5308@newsb .telia.net...

Hi!
>
I have installed a new Db2 V9.5 fp1 Linux 64 bit with a partioned
database.
>
When I connect to the database using DB2Visualizer on Windows, that uses
db2jcc, it works OK.
>
Connecting from DB2 Control Center takes 4-5 minutes, but it connects.
Opening a table can take 4-5 minutes too.
Connecting thru a Linux DB2 Client also takes 4-5 minutes, but after that
table access seems OK.
I compared dbm cfg with a working db2 server but did'nt find any
significant differences.
>
Where do I start looking? Tried to Google, but did'nt find any obvious
answers.
Something with the authentication process?
>
Mvh
/dg

Make sure that your databases are catalogued with "authentica tion server".

You can check it with "db2 list db directory".

[Dan van Ginhoven]

Re: connect to db2 9.5 server slow

Hi!

I believe port 523 is open ( but when can you trust what the firewall people say).

I know that Authentication = SERVER (db2 get dbm cfg)

I also measured that the delay is 240 seconds (4 minutes) every time .
I searched for "anything" with a timeout = 240/4 but didn't find one.
Anyone with Linux expertise know of anything with 240 seconds timeout?
db2diag.log is quiet. (Greatly improved readability in 9.5!!!!)

/dg