were to find db2 drivers and how to check if it is working

[Former Member]

i have to configure a scenario from db2 to xi to rfc

let me know were to find the db2 driver and once done how do i check if i have installed the correct driver. is there any sample program through which i can check if the driver is installed

[bhavesh_kantilal]

Hi Amit,

IF you have already instaled DB2 databse, then you can get the driver, in this location from your DB2 database folder,

/usr/local/java/db2/lib/db2jdbc.zip

If you need to install DB2, then I would suggest that you try this link,

http://www.ibm.com/software/data/db2/

http://www-128.ibm.com/developerworks/db2/library/techarticle/0203zikopoulos/0203zikopoulos.html

As DB2 is a Database from IBM, a search in the IBM website can also help you if the above links do not help.

Regards,

Bhavesh

[bhavesh_kantilal]

Hi Amit,

After you have configured your DB2, the paramerts to be entered in your sender/ receiver JDBC adapter will have the following values,

jdbcDriver=COM.ibm.db2.jdbc.net.DB2Driver

jdbcUrl=jdbc:db2://hostadres/portno

Regards,

Bhavesh

[Former Member]

i think

we should use

jdbcDriver=com.ibm.db2.jcc.DB2Driver

jdbcUrl=jdbc:db2://hostadres:portno/databasename eg

jdbc:db2://localhost:50000/phonedb

please validate

[bhavesh_kantilal]

Hi Amit,

Sorry for the confusion here.

There are two types of DB2 JDBC Drivers are avialble.

1.The "Native" JDBC driver.

Driver:<b>com.ibm.db2.jdbc.app.DB2Driver</b>

Sub protocol:<b>db2</b>Ex.jdbc:db2:localhost/COLLECTIONNAME

2.The "Toolbox" JDBC driver.

Driver:com.ibm.as400.access.AS400JDBCDriver

Sub protocol:as400

Ex.jdbc:as400://MACHINENAME/COLLECTIONNAME

<i>jdbcUrl=jdbc:db2://hostadres:portno/databasename eg

jdbc:db2://localhost:50000/phonedb</i>

I think the JDBC Url is as you have mentioned.

Regards,

Bhavesh

[Former Member]

Hi Bhavesh ,

the Db2 is on as400 machine . so should i user The "Toolbox" JDBC driver.

from were to get this driver . i am writing a sample java program so that i can test it . kindly let me know any useful links if you know about JDBC connection to AS400-DB2 .

thnaks

amit

[bhavesh_kantilal]

Hi Amit,

I would suggest that you go through this link. It might answer your queries.

http://as400bks.rochester.ibm.com/html/as400/v4r5/ic2924/index.htm?info/java/rzaha/jdbc.htm

Regards,

Bhavesh

[Former Member]

I am able to connect using toolbox jdbc driver using a sample java program .

would update if i am able to do the same viz xi

[bhavesh_kantilal]

Hi Amit,

Nice to be know that it worked. Lets hope XI behaves as expected too

Regards,

Bhavesh