Slow JDBC DB2 Connection

5 pts.
Tags:
DB2
DB2 8.1
DB2 8.x
DB2 Performance
Domino 7.0.3
Domino 7.x
JDBC
Linux RHE 4
Hello, Having an issue with a new server we are setting up. The server is Linux RHE 4, running DB2 8.1 and Domino 7.03. Our DB2 databases reside an a separate dedicated DB2 server and are cataloged on our new server. Connections to these databases are working fine using SQL tools and from the server console, but when trying to make connection to the cataloged databases using JDBC the connection takes 2-3 minutes to simply establish a connection. We have tried level 2, 3 and 4 JDBC drivers, all with the same result. Here's a sample of a simple connect to a DB that takes 2-3 minutes to run: String driver = "COM.ibm.db2.jdbc.net.DB2Driver"; String url = "jdbc:db2://127.0.0.1:60000/DBNAME"; String userid = "user"; String password = "pass"; Driver drv = (Driver)Class.forName(driver).newInstance(); con = DriverManager.getConnection(url, userid, password); Strange thing is that it actualy does connect eventually, but takes 2-3 minutes. Thanks for any ideas!

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following