How to create a new channel for connecting to a DB2 in AS/400

[Former Member]

Dear experts,

I need to connect from a DB2 Aix system to a DB2 database located in an AS/400 system. I need to connect in order to read, write, modify.... I´m not really experienced with this kind of connections, so It will be very kind of you I anybody can tell me where I can find any kind of documentation, guide, "howto" or whatever that helps me to create this communication channel between these two DB´s.

Is this a good option using a JDBC adapter ? If not, what kind of adapter would you recommend me to use ?

Thank you very much in advance for your valuable help

Kind regards

P.S. I´m talking about a P.I (7.0) system.

[Former Member · Accepted solution]

Hi Juan,

Yes you can use JDBC adapter to integrate with DB2 but you need to deploy the DB2 drivers.

Possible options to integrate with DB2 are :

We can integrate DB2 system with XI using different methods :

a)For batch mode we can work with standard file adapter of XI

b)Install MQ Series and use JMS Adaptersto send and receive messages with DB2

c)Use the JDBC Adapters to directly write to the DB2 Database.These is for

incoming interfaces

d) Third Party Adapters provided by iway can also be utilized ,but it requires a separate license

regards

Gangaprasad

[Former Member · Accepted solution]

Thank you very much for your quick answer,

now that It´s for sure that JDBC adapter is probably the "best" option, could you tell me where can I obtain a kind of guide which explain how to configure it in detail (deploying drivers, creating the channel with the JDBC adapter...).

Thank you very much indeed for your support

Kind regards

[Former Member · Accepted solution]

For PI 7.0 check https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/60237e74-ef19-2b10-5a9b-b35cc6a2...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

[Former Member · Accepted solution]

Thank you very much for all your help.

The information you´ve given to me it will be very helpful.

Kind regards

[prateek]

Is this a good option using a JDBC adapter ?

Yes, use JDBC adapter.

If not, what kind of adapter would you recommend me to use ?

U may use file adapter, but recommended would be JDBC.

U have to deply db2jcc.jar and db2jcc_license_c.jar on XI server.

Regards,

Prateek