DD5.00 to DB2

Hi,

We are using DataDeploy 5.00 on an NT machine and are trying to connect to a DB2 database. We are specifying the address and port correctly as we can see the packets being received on the DB2 machine. However we keep getting back an error :

>>> Loading drivers <<<
url : //machinename Smiley Tongue

ort/dbname
login : cmsadmin
login timeout=3
Connecting to the database...
Try connecting using jdbc:db2://machinename Smiley Tongue

ort/dbname...
SQL failure
ERROR: Could not connect to [jdbc:db2://machinename Smiley Tongue

ort/dbname]

*******************************************************
SQLException occured in JdbcCheckup:MakeConnection()
Exception Message: [IBM][JDBC Driver] CLI0615E Error receiving from socket, ser
ver is not responding. SQLSTATE=08S01
Vendor Error Code: -99999
SQL state: 08S01
*******************************************************

Attempt to connect using jdbc:db2://machinename Smiley Tongue

ort/dbname failed.
ERROR:Failed connect to [//machinename Smiley Tongue

ort/dbname]
ERROR:Unable to connect to //machinename Smiley Tongue

ort/dbname
ERROR:TDbAgent constructor failed.
ERROR:TDbSchemaAgent create failure.
Started : Wed Jul 31 10:09:06 BST 2002
Finished: Wed Jul 31 10:09:07 BST 2002

### IWDataDeploy FAILED ###

I was wondering if anyone else had got this error? I have also read something in the Docs saying that the DB2 driver also needs to be installed, but looking in the Opendeploy/lib directory we find db2java_71_nt.zip file. This only contains class files. Does it need to be unpacked somewhere?

The docs also mention running the db2jstrt port command, but this does not apear anywhere on the Teamsite machine.

Any ideas?

Jeremy

Find more posts tagged with

Comments

Migrateduser

I assume you specified the actual machine name, port and database name for the "db" attribute in your DD config file, because, the log you had pasted shows "machinename", "port" and "database". I assume you didn't want to publicize the actual values for these attributes. If this isn't true, specify the actual values and retry.

DD50 is one of the major releases and subsequently a lot of bugs have been fixed. I suggest you first upgrade to DD521 which is compatible with TS451 (no DD admin ui support) and TS50x releases.

Having said all that, the error message indicates that the JDBC driver and the database are out of sync. What version of DB2 are you using? If it's something other than DB2 7.1, you want to copy db2java.zip from your DB2 installation (under sqllib/java directory) to ddhome/lib/ directory. the name in which you copy that JDBC driver file should be reflected in iwdd.ipl file.

You have may have to update the DB2 JDBC driver, even if you migrate to DD521, because DD521 also bundles JDBC driver for DB2 7.1.

Migrateduser

BTW, on which platform your DB2 is running? DD521 has been tested against DB2 running on Solaris and Windows. DD551 has been tested against DB2 on AIX also.

Jeremy

Thanks for the response.

We are trying to run Datadeploy 5.00 on an NT machine with DB2 7.2 on an AIX machine. Only after we had started (this was the database we were already using) installing DB500 (I don't know too much about databases so did not think too much about compatability) did I think about compatability. We then realised that this may not be compatable and so have raised an issue with Interwoven Support.

I did mention that I have a db2java_71_nt.zip and it is installed in the Opendeploy folder as we were already running Opendeploy 4.5.2. If I change this file name to db2java.zip then I get more errors and Datadeploy does not even run, so I assume it is seeing that correctly.

I don't know too much about JDBC driver and the like. How do I check if we are running the correct version of that on the Teamsite server? Would we be required to make changes to the DB2 server as this may be an issue as it is already jusing JDBC to talk to some other stuff at the moment.

I have left this alone at the moment as I wait for a response from Interwoven.

Thanks again.
Jeremy

Migrateduser

Take db2java.zip from your DB2 7.2 installation on NT and copy it as db2_72_nt.zip under ddhome/lib. Then search and replace db2_71 with db2_72 in iwdd.ipl. Then it should work.

Remember, JDBC drivers for DB2 are not truly platform independent. since you are running DD on NT, you need the JDBC driver for DB2 7.2 on NT to talk to DB2 7.2 on AIX.

If I were you, I would upgrade to DD521 before anything.