Solution : https://service.sap.com/sap/support/notes/146624 (SAP Service marketplace login required)
Summary :
This SAP Note facilitates accessing data from the ABAP stack of an SAP system stored in a remote IBM DB2 for i5/OS database, not on the SAP database server. Users should note the use of XDN requires a gateway instance, per the June 2010 update. Important components include configuring user profiles for database library access, ensuring necessary SAP software and server software for DB2/400 are in place, and verifying client and server prerequisites such as TCP/IP installation. The SAP configuration should be aligned for remote DB connections, with detailed guidelines on setting up DBCON parameters for user authorization and connection management.
Key words :
netstat cnn function key f14 function key f13, /usr/sap/<sid>/sys/exe/run, i5/os solution terms release, independent auxiliary storage pool, query attributes file qaqqini, sap note 751451 server software xdn, i5/os application server, configure matching user profiles, i5/os database interface, remote db server supports
Related Notes :
| 1460139 | DB4: Multiconnect from AIX Application Servers to IBM i |
| 1257635 | DB4: DBSL Direct Drive for DB2 for IBM i (DB2/400) |
| 820325 | iSeries: Using QAQQINI with SAP |
| 751451 | iSeries: XDA Database client for Windows and LinuxPPC |
| 705888 | DB4: Performance Enhancement: All I/O Optimizer Indicator |
| 585468 | NT/DB4: Authentication failure to iSeries Diagnose |
| 523381 | BW: External DB connect for an IBM i database |
| 323151 | Several DB connections with Native SQL |
| 178949 | MSSQL: Database MultiConnect with EXEC SQL |
| 77337 | AS/400: job R3RMTDB or QXDAEDRSQL is not active |