on 08-30-2014 4:17 PM
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
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]
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.