DB2 Client connection timeout

Mike Elleby, III

DB2 Client connection timeout

Good afternoon-

I apologize if this question has been asked before, as I tried to do a search on connect timeouts and did not find a possible resolution.

I have a server running an app which uses DB2 client (v10.5fp6) to connect to a remote DB2 server (v11.1.4) that is in an HADR configuration.  The connection ultimately times out, but takes about 10 min to do so.  The only conclusion I can come to is that the client attempts to connect to the first node where the DB lives, times out and then tries to connect to the 2nd.  I get the appropriate response back, but again it takes 10 minutes.

Any way I could reduce this timeout.. I've set the following on the server where I am making the connection from via the client:

db2set DB2TCP_CLIENT_CONTIMEOUT=60

Any suggestions?

Many thanx in advance.

Mike E-

 

Edited By:
Mike Elleby, III[Organization Members] @ Jun 17, 2020 - 03:55 PM (America/Eastern)

Jorg Lueke

RE: DB2 Client connection timeout
(in response to Mike Elleby, III)

What are hadr_timeout and hadr_peer_window settings?

See also https://www.ibm.com/support/pages/apar/IT06504

 

Jorg Lueke Db2 Dba

https://www.linkedin.com/in/jorg-lueke-8b391b4/

Mike Elleby, III

DB2 Client connection timeout
(in response to Jorg Lueke)
Hello:


* PEER_WINDOW(seconds) = 300
* HADR_TIMEOUT(seconds) = 120


From: Jorg Lueke <[login to unmask email]>
Sent: Wednesday, June 17, 2020 4:25 PM
To: [login to unmask email]
Subject: [External] [DB2-L] - RE: DB2 Client connection timeout

Warning: This email originated from the Internet!
DO NOT CLICK links if the sender is unknown, and NEVER provide your password.

What are hadr_timeout and hadr_peer_window settings?

See also https://www.ibm.com/support/pages/apar/IT06504



Jorg Lueke Db2 Dba

https://www.linkedin.com/in/jorg-lueke-8b391b4/

-----End Original Message-----

Confidentiality Notice:
This e-mail, including any attachments is the property of Trinity Health and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.

Jorg Lueke

RE: DB2 Client connection timeout
(in response to Mike Elleby, III)

Do you get a corresponding message in the db2diag.log?

Jorg Lueke Db2 Dba

https://www.linkedin.com/in/jorg-lueke-8b391b4/

Mike Elleby, III

DB2 Client connection timeout
(in response to Jorg Lueke)
I’ll try it again and confirm

Mike E-

From: Jorg Lueke <[login to unmask email]>
Sent: Wednesday, June 17, 2020 4:43 PM
To: [login to unmask email]
Subject: [External] [DB2-L] - RE: DB2 Client connection timeout

Warning: This email originated from the Internet!
DO NOT CLICK links if the sender is unknown, and NEVER provide your password.

Do you get a corresponding message in the db2diag.log?

Jorg Lueke Db2 Dba

https://www.linkedin.com/in/jorg-lueke-8b391b4/

-----End Original Message-----

Confidentiality Notice:
This e-mail, including any attachments is the property of Trinity Health and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.

Mike Elleby, III

DB2 Client connection timeout
(in response to Mike Elleby, III)
Jorg-

Finally got around to this, and noting that there is a timeout that matched up against the time we were waiting for the error connecting to the DB. The ‘PEER_WINDOW’ timeout was set to 300 seconds on each server in the HADR configuration.

Mike E-

From: Mike Elleby
Sent: Wednesday, June 17, 2020 6:07 PM
To: [login to unmask email]
Subject: RE: DB2 Client connection timeout

I’ll try it again and confirm

Mike E-

From: Jorg Lueke <[login to unmask email]<mailto:[login to unmask email]>>
Sent: Wednesday, June 17, 2020 4:43 PM
To: [login to unmask email]<mailto:[login to unmask email]>
Subject: [External] [DB2-L] - RE: DB2 Client connection timeout

Warning: This email originated from the Internet!
DO NOT CLICK links if the sender is unknown, and NEVER provide your password.

Do you get a corresponding message in the db2diag.log?

Jorg Lueke Db2 Dba

https://www.linkedin.com/in/jorg-lueke-8b391b4/

-----End Original Message-----

Confidentiality Notice:
This e-mail, including any attachments is the property of Trinity Health and is intended for the sole use of the intended recipient(s). It may contain information that is privileged and confidential. Any unauthorized review, use, disclosure, or distribution is prohibited. If you are not the intended recipient, please delete this message, and reply to the sender regarding the error in a separate email.