DD to DB2 via JDBC

krauseke

Am trying to connect to a DB2 database on a W2K machine for DD of metadata. I was able to set up an ODBC connection via System DSN and it connects to the database correctly.

When I use the database connection format for DB2 in the deployment script (see below) I get an SQL State error from socket, server is not responding.

What is missing? I am using DD 5.0 and have the db2 drivers installed in the dd-home\lib directory. Is there a way to force an ODBC connection at least to test?

Here is the connection string from the DD script:
<database db = "//servernameort#/DBName"
user="UID"
password="pwd"
vendor = "ibm"
tablespace="USERSPACE1"
max-id-length = "18"
delete-tracker="yes"
update-type="standalone"
drop-table="yes" >.....

Thanks