If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > Connection to a DB2 database takes over 10 minutes

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-11-06, 09:54
cleaner cleaner is offline
Registered User
 
Join Date: Mar 2003
Posts: 1
Question Connection to a DB2 database takes over 10 minutes

Hello,

I'm just wondering if anyone has run into a similar problem - though it probably isn't directly tied to DB2 itself.

Essentially, it takes over ten minutes to connect to a DB2 V8 FP 10 multi partitioned database from a windows client. This behaviour is not consistent however, since at least one w2k client is able to connect without a problem. Here's the breakdown:

Windows DB2 v8 client -> DB2 V8 FP10 (slow)
Unix DB2 v8 client -> DB2 V8 FP 10 (fast)
Windows DB2 v7 client -> DB2 V8 FP 10 (fast)

What is strange is that V7 clients are able to connect without a problem, but when we upgrade to V8, they take forever to connect.

We had a similar problem on our production systems, but adding a search path to the DNS server allowed it to resolve the client to the domain it was located in. However, this didn't solve the problem in development.

Would anybody know anything about the newer features of the V8 clients on Windows that makes them so affected by changes to the DNS? Are there any parameters on the DB2 server which can change the behaviour of client connections? A registry variable perhaps?

I'm still reading through the documentation, but if anyone has a direction to point me in, I'd appreciate it.

Thanks.
Reply With Quote
  #2 (permalink)  
Old 01-11-06, 10:57
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
Make sure that your db is catalogued on your client with "authentication server" parm at the end.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote
  #3 (permalink)  
Old 01-11-06, 16:17
dbamota dbamota is offline
Registered User
 
Join Date: Sep 2003
Posts: 237
We had problems(not connectivity) with 8.1 client talking to 8.2FP10. Were strongly urged to upgrade client to FP10 also. Problems disappeared. Can you PING the server from 8.1 client quickly?
__________________
mota
Reply With Quote
  #4 (permalink)  
Old 01-12-06, 02:50
przytula przytula is offline
Registered User
 
Join Date: Nov 2004
Posts: 374
client

we had same problem from windows client on server machine.
had todo with dns sequence lookup and with user authentication verification to server.
__________________
Best Regards, Guy Przytula
DB2/ORA/SQL Services
DB2 DBA & Advanced DBA Certified
DB2 Dprop Certified
http://users.skynet.be/przytula/dbss.html
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On