topic Re: DB Connect Error while establishing secondary Database DB2 in mainframe sys in Application Development and Automation Discussions

DB Connect Error while establishing secondary Database DB2 in mainframe sys

Former Member — Mon, 27 Jul 2009 13:02:46 GMT

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 — Fri, 21 Aug 2009 08:51:46 GMT

Hi,

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

Former Member — Fri, 21 Aug 2009 08:56:18 GMT

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 — Fri, 21 Aug 2009 09:01:29 GMT

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 — Fri, 21 Aug 2009 09:05:07 GMT

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

Thanks everyone for replies.