DataDeploy Connection Error to IBM DB2 database

I am in the process of setting up DataDeploy 5.6 (Windows 2000) to move data from TeamSite 5.52 to an IBM DB2 database. But there seems to be something wrong with the connection process. I am getting the following errors:

DataDeploy Version 5.6.0 Build 14707 Interwoven 20021211
Database Vendor set to IBM
Setting up consumer TDbAgent
>>> Loading drivers <<<
url : bmdb
login : a37345
login timeout=3
Connecting to the database...
Try connecting using jdbc:db2:bmdb...
SQL failure
ERROR:ERROR: Could not connect to [jdbc:db2:bmdb]

*******************************************************
SQLException occured in JdbcCheckup:MakeConnection()
Exception Message: No suitable driver
Vendor Error Code: 0
SQL state: 08001
*******************************************************
<Stack Trace Information goes here>

ERROR:Could not connect to [bmdb]
ERROR:Unable to connect to bmdb
Error occured in TDbAgent
Rollback database [bmdb]...
Deployment[do-sql] Table[bm]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
ERROR:TDbAgent create failure
Started : Wed Apr 23 13:25:42 CDT 2003
Finished: Wed Apr 23 13:25:42 CDT 2003

### IWDataDeploy FAILED ###[i/]

Here is a copy of the database.xml file:
<data-deploy-elements>
<database
name = "bmdb"
db = "bmdb"
user = "a37345"
password = "street$$"
vendor = "IBM"
use-db2-app-driver="yes"
/>
</data-deploy-elements>

Configuration File:
<data-deploy-configuration>
<client>


<deployment name="do-sql">
<destinations>

<database db = "bmdb"
user="a37345"
password="street$$"
vendor = "IBM"
table="bm">
<sql user-action="testdd" type="query">
select * from bm.benefits_manual
</sql>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

Find more posts tagged with

Comments

nipper

Check your JDBC drivers, there should be a test utility to see if JDBC is configured correctly, looks like it is not.

Andy

dtheimer

Andy,

Could you provide more details on the test utility? Who supplies it? Where can I find this tool?

Thanks

nipper

Depends on the driver. Should be with your ODBC/JDBC driver.

For example, Oracle has an app called ODBC Test which just opens a short connection to the DB.

What JDBC driver do you have ?

nipper

Per the DD manual, IBM does not automatically start the daemon to accept JDBC connections, that also could be your problem. Appendix 1 DD admin manual

iwovjames

On the DB2 target DB server you need to grab the db2java.zip file from the <db2home>/java folder. Copy that to the DataDeploy/lib folder and rename it to db2java_71_nt.zip if on W2K or db2java_71_sol.zip if on Solaris.

You also need to start the DB2 JDBC listener as described in the DD manual, using the command DB2JSTRT <port#>

If the jstrt listener is not started you'd get a different error than what you are getting. If the listener is not started, you'd get a socket not found error (or something like that).

Hope this helps.

dtheimer

Here is the correct database.xml file:
<data-deploy-elements>
<database
name = "bmdb"
db = "bmdb"
user = "a37345"
password = "xxxxxxx"
vendor = "IBM"
use-db2-app-driver="yes"
/>
</data-deploy-elements>

*** The use-db2-app-drive is for the Type 2 JBDC driver ***

Corrections in the Configuration File:
<data-deploy-configuration>
<data-deploy-elements filepath="c:\dd-home\conf\database.xml"/>
<client>


<deployment name="do-sql">
<destinations>

<database use = "bmdb"
table="bm">
<sql user-action="testdd" type="query">
select * from bm.benefits_manual
</sql>
</database>
</destinations>
</deployment>
</client>
</data-deploy-configuration>

*** Note the data-deploy-elements tag and the removal of the incorrect database connection information ***

NOTE: By chance found out that either Datadeploy or the IBM JBDC drive did not pass the "$" correctly used in the password. Changed it to numbers and it then worked.

Migrateduser

> NOTE: By chance found out that either Datadeploy or the IBM JBDC drive did not pass
> the "$" correctly used in the password. Changed it to numbers and it then worked.

Yeah, there's a DataDeploy bug open on that: #27395

Todd Scallan
Group Product Manager
Interwoven
t: 408-530-7167
e: tscallan@interwoven.com