Access DB2 on AS400 from Windows based SAP platform thru ABAP

[Former Member]

Hello All,

I've gone thru all the posting and various SAP notes but still not able to connect to the external DB2 system on AS400 using ABAP. Here is the error I'm getting:

**********************************************************************************

ShrtText

Error setting up a secondary database connection.

What happened?

It is impossible to connect to a database system with the identifier

"CON_NAME".

**********************************************************************************

Here is the entry in DBCON :

DB Connection: CON_NAME

DBS: DB4

User Name: USERNAME

DB password: PASSWORD

Connection info.: AS4_HOST=HOST;AS4_DB_LIBRARY=LIBRARYNAME;AS4_QAQQINILIB=FILENAME;

Permanent: X

Connection Limit: 0

Optimum Conns: 0

I'm getting the above error at the time of establishing the connection:

EXEC SQL.

SET CONNECTION :CON_NAME

ENDEXEC.

The database server job is running on the remote DB server. Also I'm able to connect to the DB on the application server using Client Access and ODBC.

I would appreciate any help in this regard.

Cheers!

Sajal

[former_member433984]

Hello Sajal,

the general points described in notes 323151 and 780891 (ok, ok - I know that is for ORA, but idea is the same):

- you need to maintain DBCON entry

- you need proper dbdb*slib.dll for Windows in SAP kernel folder

- you need DB2 client for Windows installed on your machine

I think you can find some details to DB2 client on Windows in installationi guide.

The statement above is valid if you run your dialog instance on Windows.

best regards

[Former Member]

Hi Sajal,

Have you resolved this issue? If so, would you mind sharing the solution? I'm trying to work through this same issue.

Thanks!

Scott

[Former Member]

Not Yet Scott.. I'm still looking for solution. Please let me know if you come accross any and I'll do the same.

Cheers!

Sajal

[Former Member]

I will, Sajal.

Thank you!

[Rudi_Wiesmayr]

Try to ask the iSeries people in

They may know.

HTH, Rudi