How to connect through JDBC adapter to DB2 UDB v8.2 on IBM z/OS Mainframe

[Former Member]

Hi.

I have possibility integration scenario to DB2 UDB v8.2 running on IBM mainframe z/OS. I have some question :

1. How to configure XI JDBC adapter (parameters) ?.

2. is there any additional software required ?

3. What is the name of the library (jar) required ?

Thank you and Best Regards

Fernand

[Former Member · Accepted solution]

Hi Fernand

.Take a look at this thread and see if it helps,

Thanks !!

[Former Member]

The solution is using DB2 Connect driver from IBM.

Regards

[Former Member]

Hi Monica,

Thank you for your information.

But then the library that your mention it only for IBM iSeries (AS400) not for zSeries (Mainframe). Do you have information about that ?

Do we need to use IBM DB2 Connect ?

Regards

Fernand

[Former Member]

Hi

3)What is the name of the library (jar) required ?

Download universal driver for DB2,the jar file

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

also have a look at the following to install these driver in XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

You can use jt400.jar This will help you connect to DB2.

You can get it free from the internet. Try: http://www-03.ibm.com/servers/eserver/iseries/toolbox/downloads.html

For more

1)How to configure XI JDBC adapter (parameters) ?

FILE to JDBC Adapter using SAP XI 3.0

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

Thanks