JDBC connection to DB2 Database

[Former Member]

Hi All,

Can i have any sucessfull story in the JDBC connection to DB2/As400 system..

We are proposing the JDBC connection to the DB2 database other than the file communication, so need to know some sucessful story of any XI implementaion having JDBC connection with DB2/ AS400 system.

thankx in advance,

Shree...

[bhavesh_kantilal · Accepted solution]

Hi Shree,

yes, it is possible to connect to a DB2 database from XI.

There are two types of DB2 JDBC Drivers are available.

1.The "Native" JDBC driver.

Driver:com.ibm.db2.jdbc.app.DB2Driver

Sub protocol:db2Ex.jdbc:db2:localhost/COLLECTIONNAME

2.The "Toolbox" JDBC driver.

Driver:com.ibm.as400.access.AS400JDBCDriver

Sub protocol:as400

Ex.jdbc:as400://MACHINENAME/COLLECTIONNAME

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

If you want to download the driver for DB2, then I think you can do it from these links,

http://www-128.ibm.com/developerworks/db2/downloads/jcc/

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

Regards,

Bhavesh

[Former Member · Accepted solution]

Hi Bhavesh,

Thankx for your reply .. can i have any clients who have sucessfully working on this scenario.. JDBC connection to DB2 database.

Thankx,

Shree