Solved: BW External DB connect to an IBM i (AS400) system

Former Member · ‎08-18-2014

Hello,

I am trying to connect my BW system to external database on IBMi system (AS400). Here are the detail information

My SAP BW System

OS/DB- Windows2012/SQL2012

SAP: NW7.4

Kernel-7.41 64Bit Unicode

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

SAR

lib_dbsl_47-10012479.sar

Database Library

47

Info

4627

15.08.2014

After extracting this sar file got all these files

06/29/2014 05:35 PM 233,984 db4cncl.exe

06/29/2014 05:35 PM 887,808 db4cncl.pdb

06/29/2014 07:05 PM 1,739,776 dbdb4slib.dll

06/29/2014 07:05 PM 3,075,072 dbdb4slib.pdb

06/29/2014 06:36 PM 317,952 dbsldb4ccm.dll

06/29/2014 06:05 PM 365 patchesdb.mf

06/29/2014 05:36 PM 155,136 setdb4pwd.exe

06/29/2014 05:36 PM 584,704 setdb4pwd.pdb

07/04/2014 08:28 AM 5,520 SIGNATURE.SMF

06/29/2014 06:27 PM 243,712 xdnxdaapi.dll

External Source to which I am trying to connect - IBMi -AS400 (Version R611)

DBCO configuration on SAP BW system -

Database connection - BWAS400DEV

DBMS - DB4

Username - SAPUSR

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

Connection Information - AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR

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

Following Profile Parameters is also set

dbs/db4/xdn_trace_file=XDNTrace

dbs/db4/connect_type= T

dbs/db4/xdn_port= 9601 ( this is my SAP BW messageserver number as per note-1875310 - IBM i: Incorrect XDN default port)

dbs/db4/driver_type=XDN

SAPHOST Agent is installed in SAP system but not on IBMi system. We are planing to install the SAPHOSTAgent on the IBMi system also.

Testing the connection via SE38-ADBC_TEST_CONNECTION - Select the -Database connection - BWAS400DEV and test the connection( I did testing from two system one has SAN NW gateway installed, but same error)

ERROR

Testing a Database Connection Defined in DBCON

Could not open connection BWAS400DEV

DBI error 16 occured.

See trace file for further info: dev_w 3

The dev_w 3 - shows

B Loading DB library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' ...

B Library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' loaded

B Version of 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' is "741.10", patchlevel (0.41)

B Connect to BWAS400DEV as SAPUSR with AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR

C DB4 SQL Reparse Activated

C Windows 2008 R2 - XDN Default

C Secondary DB connect, user SAPUSR

C Environment: AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR

C *** ERROR => EXEC SQL connect: AS4_DB_LIBRARY invalid

[dbsldb4.cpp 18043]

C {root-id=005056810E3C1ED489E30965816320CF}_{conn-id=00000000000000000000000000000000}_0

C *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to:.

[dbsldb4dbi.c 502]

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

[dbsldb4.cpp 17852]

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

[dbsldb4.cpp 20085]

C *** ERROR => connected = FALSE

[dbsldb4.cpp 20086]

C *** ERROR => con_hdl = 1

[dbsldb4.cpp 20087]

C *** ERROR => db_handle = 0

[dbsldb4.cpp 20088]

C *** ERROR => dbhost = DVTEST

[dbsldb4.cpp 20089]

C *** ERROR => dbhostport =

[dbsldb4.cpp 20090]

C *** ERROR => rdbname =

[dbsldb4.cpp 20091]

C *** ERROR => dblib =

[dbsldb4.cpp 20092]

C *** ERROR => r3sysle_changed = FALSE

[dbsldb4.cpp 20095]

C *** ERROR => query_compl_reval =

[dbsldb4.cpp 20096]

C *** ERROR => dbconnecttype =

[dbsldb4.cpp 20097]

C *** ERROR => user =

[dbsldb4.cpp 20098]

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

[dbsldb4.cpp 20102]

C *** ERROR => dbjobname =

[dbsldb4.cpp 20103]

C *** ERROR => dbjobuser =

[dbsldb4.cpp 20104]

C *** ERROR => dbjobno =

[dbsldb4.cpp 20105]

C *** ERROR => rmtexelib =

[dbsldb4.cpp 20106]

C *** ERROR => parallel_alter_tables = *OFF

[dbsldb4.cpp 20109]

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

[dbsldb4.cpp 20128]

B ***LOG BYI=> connect failed for connection BWAS400DEV [dbds 929]

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

Our Network Team did monitor the network traffic and confirmed nothing from going out from my SAP system to the AS400 system.

Any help/suggest is highly appreciated.

I have gone through all these Notes.

146624 DB Multiconnect for I series.pdf

1031096 - Installing Package SAPHOSTAGENT.pdf

1257635-1257635 - DB4 DBSL Direct Drive for DB2 for IBM i(DB2_AS400).pdf

146624 - IBM i Database Multiconnect for IBM DB2 for i.pdf

1541772 - DB4- Easy SAP Gateway Install on IBM i (EZ Gateway).pdf

1760513 - Inst. Standalone Gateway based on NW 7.0 & EHP 1-3.pdf

1875310 - IBM i- Incorrect XDN default port.pdf

323151-Several DB connections with Native SQL.pdf

523381 - BW- External DB connect for an IBM i database.pdf

751451 - iSeries- XDA Database client for Windows and LinuxPPC.pdf

283,931 AS400 Source System Connection.docx

808,286 Transferring Data with DB Connect.pdf

Former Member · ‎08-26-2014

silly mistake or not I can say not know requirement, I was missing a semicolon(;) at the end of my configuration parameters in DBCO

Connection Information - AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR;

After add the semicolon then tested the connection via SE38-ADBC_TEST_CONNECTION - Select the -Database connection - BWAS400DEV and tested the connection and it successful.

Former Member · ‎08-25-2014

Hi Volker,

We got the SAP HOST Agent installed on IBNM I host and started the XDN listener Job, its listing to Port 963.

But still no Luck.

Getting Same Error. I restart our SAP instance and also the hostAgent on the SAP side.

We also asked our IBMi team to restart the SAP Host Agent.

Exact Same Error. And our Network Team setup a traffic monitoring between SAP to IBM and he is saying no traffic is coming from SAP to the IBMi server

Error:

B Mon Aug 25 15:41:25 2014

B Loading DB library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' ...

B Library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' loaded

B Version of 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' is "741.10", patchlevel (0.41)

N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]

N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]

N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]

N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]

N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]

N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]

B Connect to BWAS400DEV as KTSAPUSR with AS4_HOST=DVTEST;AS4_DB_LIBRARY=KTSAPUSR

C DB4 SQL Reparse Activated

C Windows 2008 R2 - XDN Default

C XDN-Port: Assuming 9600 + sapmsSB1 mod 100 = 9601

C Secondary DB connect, user KTSAPUSR

C Environment: AS4_HOST=DVTEST;AS4_DB_LIBRARY=KTSAPUSR

C *** ERROR => EXEC SQL connect: AS4_DB_LIBRARY invalid

[dbsldb4.cpp 18043]

C {root-id=005056810E3C1ED48B930260998960CF}_{conn-id=00000000000000000000000000000000}_0

C *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to:.

[dbsldb4dbi.c 502]

We also Removed AS4_DB_LIBRARY from DBCO configuration to see what happen and we got this error

B Mon Aug 25 15:52:54 2014