cancel
Showing results for 
Search instead for 
Did you mean: 

need to connect SAP ECC on MSSql Server to external db2/as400 non-sap

Former Member
0 Kudos

Hi,

I need to connect my SAP System to a non-sap IBM I DB2/AS400 System.

The SAP System details are

My SAP BW System

OS/DB- Windows2008/SQL2008

SAP: NW7.31

Kernel-7.20 64Bit Unicode

DBSL-  Downloaded for  AS/400(DB2/400)


Externel System to which i am trying to connect is.


IBM I - DB2/AS400


DBCO Config on SAP system is


Database connection - z_bw_as4

DBMS                            - DB4

Username                   - myuser

*Password                    ***********

Connection Information - AS4_HOST=IBMHOST;AS4_DB_LIBRARY=myuser

Permanent :- checked

Connection Limit :- 5

Optimum Conns :- 5


Both the DBMS name and AS_DB_LIBRARY are same and in uppercase.


Added the following parameters in the SAP Instance profile.

dbs/db4/xdn_port 9601

dbs/db4/connect_type T

dbs/db4/xdn_trace_file XDNTrace

dbs/db4/driver_type XDN


Installed SAPHOSTAGENT on the remote DB2/AS400 System. Made sure

that the saphostagent is up.id


After doing all the above things still i am getting the error as below.


Please advise.


B Sat Aug 30 17:07:10 2014

B  Connect to Z_BW_DB4 as FLLIB00 with AS4_HOST=IBMHOST;AS4_DB_LIBRARY=myuser;

C  Secondary DB connect, user user

C  Environment: AS4_HOST=IBMHOST;AS4_DB_LIBRARY=myuser;

C Sat Aug 30 17:07:11 2014

C  *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to: IBMHOST:963 (10061).

[dbsldb4dbi.c 502]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => === Secondary DB connect FAILED! ===

[dbsldb4.cpp  17720]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => === Connection settings ===

[dbsldb4.cpp  19945]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => connected               = FALSE

[dbsldb4.cpp  19946]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => con_hdl                 = 1

[dbsldb4.cpp  19947]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => db_handle               = 0

[dbsldb4.cpp  19948]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbhost                  = IBMHOST

[dbsldb4.cpp  19949]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbhostport              =

[dbsldb4.cpp  19950]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => rdbname                 =

[dbsldb4.cpp  19951]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dblib                   = FLLIB00

[dbsldb4.cpp  19952]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => r3sysle_changed         = FALSE

[dbsldb4.cpp  19955]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => query_compl_reval       = Y

[dbsldb4.cpp  19956]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbconnecttype           = T

[dbsldb4.cpp  19957]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => user                    = FLLIB00  

[dbsldb4.cpp  19958]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => qaqqinilib              = Default (QUSRSYS)

[dbsldb4.cpp  19962]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbjobname               =

[dbsldb4.cpp  19963]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbjobuser               =

[dbsldb4.cpp  19964]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => dbjobno                 =

[dbsldb4.cpp  19965]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => rmtexelib               =

[dbsldb4.cpp  19966]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => parallel_alter_tables   = *OFF

[dbsldb4.cpp  19969]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => ===========================

[dbsldb4.cpp  19988]

C  {root-id=00155D0EDF011ED48C87991235C3BE0D}_{conn-id=00000000000000000000000000000000}_0

B  ***LOG BYI=> connect failed for connection Z_BW_DB4   [dbds         889]

B  ***LOG BZY=> unexpected return code 8192       calling DBDS       [dbacds       1555]

Accepted Solutions (0)

Answers (2)

Answers (2)

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

For connecting any remote database you need DBSL for target DB in your calling system. For that you need to find and extract Remote DB dbsl in your calling system. If the dbsl is supplied by the vendor for SAP applications then you can connect. If not, then check with vendor directly. As you say it's DB4, i am not sure and you need to check in SAP service market place for the same and then try DBconn connect.

Regards

Former Member
0 Kudos

Hi Divyanshu,

Thanks for the reply,

I already extracted the required DBSL files for the DB2 System in the calling system, these DBSL files were taken from the service market place.

But still it is not able to establish the connection.

Kind regards,

Faseeh.

divyanshu_srivastava3
Active Contributor
0 Kudos

Hi,

Thanks for the reply.

Update your kernel as per below note

1747109 - DBA: Include All DBSLs in SAPEXEDB.SAR

Make sure you are above PL400 for your release 720 of kernel.


Now, make sure ports are open between these two systems, and that two bidirectional.


Then, create an entry in DBCON.

Run ADBC_TEST_CONNECTION in se38 and share results


Once all done, share results.


Regards,

Divyanshu

Sriram2009
Active Contributor
0 Kudos

Hi Faseeh

Could you check this SAP Note for you connection issue

1871400 - DB4: Prioritizes localhost Connect to IPv4 (127.0.0.1)


Regards

SS

Reagan
Advisor
Advisor
0 Kudos

I believe you need to install the DB2 client software along with the DBSL files for DB2.

Check this note for information.

1267189 - DBA Cockpit: DB2 for LUW as Remote Database

Regards

RB

Former Member
0 Kudos

Hi Benjamin,

Thanks for the reply.

I followed the note 523381, 1257635 and 146624 according to these notes DB2 Client is note required at SAP instance, instead we need to put the DBSL files for DB2 in the SAP Kernel. I did this already.

Thanks,

Faseeh.