Hi All,
We had just migrated our itcamfwas db2 database to the new server, jdbc driver and db2client are both configured and pointed to the new server, the were verified successfully.
Now the final component is how I could reconfigure the java component and have it communicated with the new box?
/local/itcam/WebSphere/MS/bin> ./klctl.sh dbtest
Testing DB Connection with kernel properties...
using the following properties to test database connection...
JDBC DRIVER NAME =com.ibm.db2.jcc.DB2Driver
DB URL =jdbc:db2://itcammsdc.xxxxx.ca:50000/octigate
DB USER =testid
DB PASSWORD =XXXX
Trying to establish connection to database
Exception in thread "main" java.sql.SQLException: DB2 SQL error: SQLCODE: -1060, SQLSTATE: 08004, SQLERRMC: CYANEA
at com.cyanea.common.database.DbAccess.getDbConn(DbAccess.java:167)
at com.cyanea.common.dbtest.DBTest.testDBConnection(DBTest.java:61)
at com.cyanea.common.dbtest.DBTest.main(DBTest.java:185)
Thanks,
sc