cancel
Showing results for 
Search instead for 
Did you mean: 

Connection Parameters for JDBC adapter which connects to DB2 in AS400

Former Member
0 Kudos

Hi,

I need to connect to the DB2 database running in As400 and and i need to know how would you specify the connection parameter in the JDBC adapter for DB2 database.

I have worked on SQL and Oracle but the similar ways doesn't work for DB2 ..

can any one help me.

thankx,

Shree

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member187339
Active Contributor
0 Kudos

Hi Shree,

Hope you have deployed the necessary drivers for DB2. For drivers have a look at the following thread:

<i>>> have worked on SQL and Oracle but the similar ways doesn't work for DB2</i>

Needs a little more explaination !!!

Regards

Suraj

Former Member
0 Kudos

Hi,

what means similar way does not work? What have you done so far?

Necessary steps would be:

1. Get a JDBC driver for your DB2 version and deploy it as stated in XI documentation

2. Check the Documentation of your JDBC driver for the driver class name (with package) to be put in configuration

3. Check the JDBC driver doc for the syntax of the connection string, as this differs from driver to driver.

Have you carried out any of this steps or where are you stuck right now?

Have a look at this link on IBM documentation giving some hints. http://publib.boulder.ibm.com/infocenter/db2luw/v8/topic/com.ibm.db2.udb.doc/ad/tjvjcccn.htm

For example the connection string should look like String "jdbc:db2://sysmvs1.stl.ibm.com:5021/san_jose:user=db2adm;password=db2adm;" if you use the DB2 Universal JDBC Driver.

Best regards

Christine