We are not able to connect to DB2 database using standalone data deploy configuration file. I have updated the database.xml with DB2 details and created datadeploy configuration file. When executed the xml file i am getting below error DBD: SQL datatype for column EFF_DT is DATE DBD: SQL datatype for column EXP_DT is DATE DBD: SQL datatype for column OWNER is VARCHAR(100) DBD: SQL datatype for column OWNER_EM is VARCHAR(100) DBD: SQL datatype for column PATH is VARCHAR(100) DBD: SQL datatype for column LAST_MODIFY_DT is DATE DBD: # of columns: 25 DBD: # of primary key columns specified: 3 DBD: # of groups defined in element: 1 DBD: [Thu Feb 02 21:28:57 PST 2017] Begin executing basearea Contact Details Ticket Details DBD: Area VPath:/Agency/main/CAG/STAGING DBD: Setting up TDbSchemaAgent. DBD: Loading COM.ibm.db2.jdbc.app.DB2Driver DBD: ERROR:ERROR: Loading drivers : COM.ibm.db2.jdbc.app.DB2Driver DBD: DBD: ******************************************************* DBD: SQLException occured in JdbcCheckup:LoadDrivers() DBD: Exception Message: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path DBD: Vendor Error Code: 0 DBD: SQL state: null DBD: ******************************************************* DBD: DBD: *******STACK TRACE************* DBD: ERROR: java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path at COM.ibm.db2.jdbc.app.DB2Driver.(Unknown Source) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.j ava:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at com.interwoven.dd100.dd.JdbcCheckup.registerDriverWithDriverManager(JdbcCheckup.java:170) at com.interwoven.dd100.dd.JdbcCheckup.LoadThirdPartyJDBCDriver(JdbcCheckup.java:126) at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:681) 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(TConsumerMa nager.java:514) at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587) DBD: ERROR: java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path at COM.ibm.db2.jdbc.app.DB2Driver.(Unknown Source) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.j ava:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at com.interwoven.dd100.dd.JdbcCheckup.registerDriverWithDriverManager(JdbcCheckup.java:170) at com.interwoven.dd100.dd.JdbcCheckup.LoadThirdPartyJDBCDriver(JdbcCheckup.java:126) at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:681) 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(TConsumerMa nager.java:514) at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587) at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumer Manager.java:192) at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133) 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:Unable to connect to PEGASBOX DBD: ERROR:TDbAgent constructor failed. DBD: Error occured in TDbSchemaAgent DBD: Stat for group [CAG]: DBD: ----------------------------------- DBD: Rows inserted : 0 DBD: Rows updated : 0 DBD: Rows deleted : 0 DBD: Rows failed : 0 DBD: Rows rolled back : 0 DBD: Rows skipped : 0 DBD: -----------------------------------
From putty I am able to connect to DB2 database using DB client
db2 => connect to PEGASBOX user pegadev
Enter current password for pegadev:
Database Connection Information
Database server = DB2/AIX64 9.7.5
SQL authorization ID = PEGADEV
Local database alias = PEGASBOX
Please let us know what may be the issue. I places all required files in drivers directory.
Appreciate your help!!!
