DB Connect Error while establishing secondary Database DB2 in mainframe sys

[Former Member]

Hello,

I am trying to establish a secondary database connection between my ECC system and a mainframe system.

In my SAP system, the database is Oracle and version is 10.2

I want to connect to a mainframe system DB2 (AS400).

I have installed DB2 client in SAP server.

I have checked the access to Mainframe system from DB2 client.

I have made the entry in DBCON table via t-code DBCO, which looks like this

AS4_HOST=<ip_address>;AS4_DB_LIBRARY=<LIB_NAME>;

But when I run, the std program ABCD_TEST_CONNECTION, I am getting error

Secondary DB connect FAILED!

Some doubts:

1) From an Oracle Database point, is it required to login to sqlplus and create a database link between Oracle Database and the Mainframe Database?

2) Is it required to have an entry in SM59, which connects the Mainframe system, if so what type of connection & name?

3) If anyone has faced situation like this, can you share what steps were taken to resolve the error?

If this is not the forum to post this question, can you suggest the correct forum?

Regards,

Vikas

[Former Member]

Hi,

Even I have the same requirement. Kindly let me know the steps to followed if you have setup the connection

[Former Member]

Hello Prem,

I have established connectivity with Mainframe via DB-Connect.

THe steps are

1) Make entry in DBCON table

2) Install DB2 client in SAP-Server

3) There are some jobs which needs to be run in Mainframe system. The job name was mentioned in one of SAP notes.

If you are facing problems after this, just check SAP version and patch installed.

Regards,

Vikas

[Former Member]

Hi,

/people/graham.robinson/blog/2008/10/27/using-abap-to-access-non-sap-databases

Go through above link, helpful to you..

Regards,

Rajesh

[Former Member]

The problem was more because of SAP patch not being installed on SAP system.

Thanks everyone for replies.