Solution : https://service.sap.com/sap/support/notes/160484 (SAP Service marketplace login required)
Summary :
This SAP Note details the implementation and configuration of DATABASE-MULTICONNECT for NATIVE SQL, enabling connections to other manufacturers' database management systems (heterogeneous multi-connect) or to the same manufacturer's systems (homogeneous multi-connect). Key configurations involve maintaining connection data in the DBCON table, utilizing default connection parameters, and configuring with DB2 CONNECT. For heterogeneous environments, specific platform notes must be referred to. Supported from Release 4.6A with DB2/390, detailed instructions for DB2 Connect setup, including the installation and configuration steps, are provided to ensure successful connectivity and access management.
Key words :
dsnl004i -dsnx ddf start complete location dsnx lu desapw00, iclilibrary=/usr/sap/d6d/sys/exe/run/ibmiclic, /usr/sap/<sapsid>/sys/exe/run directory, <username>password < >con env plan=<plan>, native sql multi-connect open sql database accesses, subsequent open sql commands continue, programming native sql language commands, remote database> location=<ddf location, availability native sql multi-connect, remote database> port=<ddf port
Related Notes :
| 1382952 | DB2-z/OS:CCMS: DBA Cockpit: DB2 for z/OS as Remote Database |
| 663756 | DB6: Multiconnect on DB2 for z/OS, DB2 for i with DB6 DBSL |
| 323151 | Several DB connections with Native SQL |
| 178949 | MSSQL: Database MultiConnect with EXEC SQL |