Slow JDBC DB2 Connection
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!
Software/Hardware used:
Software/Hardware used:
ASKED:
January 8, 2009 9:12 PM
UPDATED:
January 8, 2009 9:35 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
