Connecting a Solution Manager on DB2 LUW to a DB2 zOS system

Follow RSS feed Like

5 Likes 904 Views 0 Comments

Purpose

The purpose of this page is to explain how to connect a Solution Manager running on DB2 LUW to a DB2 zOS system

In order to connect a Solution Manager on DB2 LUW to a DB2 z/OS system some files need to be downloaded from the SAP Service Marketplace

Download file SAPEXEDB_DB2.SAR from the SAP Service Marketplace, files .dbdb2slib.o dbdb2slib9.o dbdb2slibx.o and db2radm need to be copied to the SAP EXE directory
The CLI driver being used for DB2 LUW can be used to access the DB2 zOS system. Set the following environment variable in your SAP application server :
If CLI driver is under /usr/sap/<SID>/SYS/global/db6/AIX_64/db6_clidriver,
DB2_CLI_DRIVER_INSTALL_PATH = /usr/sap/<SID>/SYS/global/db6/AIX_64/db6_clidriver
It is recommended to use CLI driver 10.5 instead of 9.7.
Copy the license files db2consv_ee.lic and db2consv_t.lic onto /usr/sap/<SID>/SYS/global/db6/AIX_64/db6_clidriver/license
Bind the CLI driver to the DB2 zOS system by calling db2radm from the application server
db2radm -m db2i -C SAP0709U -H <host> -P <port> -L <DDF Location> -S <SSID> -U <connect user> -Q <schema> -u <admin user with SYSAADM> -p <admin pwd with SYSADM> -B force -G only -W secondary_only
Add a DBCON connection in DBA Cockpit with
SSID/Alias = SSID Collection ID = SAP0709U Database Host = <host> Database Name = <DDF Location> Port Number = <port> Schema Name <schema>