Not able to connect to DB2 from OD 721

SPrakash

I am not able to connect to the db2 server from opendeploy.

I see from the open deploy logs that it is connecting using a type 3 driver (COM.ibm.db2.jdbc.net.DB2Driver). I am getting the same error when i am trying to connect through DB2 client using the same driver.

I have tried connecting from DB2 client using type 4 driver(com.ibm.db2.jcc.DB2Driver) which i was successful. I want to connect with type 4 driver using open deploy. Can any one suggest me the configuration file where i should change the DB2 driver name in open deploy?

Teamsite: 7.2.1
Open Deploy: 7.2.1.0.0
Environment: Linux

Below is the error.

DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:db2://165.203.203.216:50000/SAMPLE]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: [IBM][JDBC Driver] CLI0615E Error receiving from socket, server is not responding. SQLSTATE=08S01
DBD: Vendor Error Code: -99999
DBD: SQL state: 08S01
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0615E Error receiving from socket, server is not responding. SQLSTATE=08S01
at COM.ibm.db2.jdbc.net.SQLExceptionGenerator.throwReceiveError(SQLExceptionGenerator.java:501)
at COM.ibm.db2.jdbc.net.DB2Request.receive(DB2Request.java:704)
at COM.ibm.db2.jdbc.net.DB2Request.sendAndRecv(DB2Request.java:564)
at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(DB2Connection.java:376)
at COM.ibm.db2.jdbc.net.DB2Connection.SQLConnect(DB2Connection.java:327)
at COM.ibm.db2.jdbc.net.DB2Connection.create(DB2Connection.java:312)
at COM.ibm.db2.jdbc.net.DB2Connection.(DB2Connection.java:212)
at COM.ibm.db2.jdbc.net.DB2Driver.connect(DB2Driver.java:215)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:699)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:550)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:272)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForMultiDeployment(TConsumerManager.java:150)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:129)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:108)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:632)
at java.lang.Thread.run(Thread.java:619)


DBD: ERROR:Could not connect to [//165.203.203.216:50000/SAMPLE]
DBD: ERROR:Unable to connect to //165.203.203.216:50000/SAMPLE
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent

ISCBorisB

Can any one suggest me the configuration file where i should change the DB2 driver name in open deploy?

It's documented in Database Deployment for OpenDeploy Administration Guide.