Purpose

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

Overview

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

Resolution

1. 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
2. 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.
3. Copy the license files db2consv_ee.lic and db2consv_t.lic onto /usr/sap/<SID>/SYS/global/db6/AIX_64/db6_clidriver/license
4. 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
5. 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>

Related Documents

note 1382952 – DB2-z/OS:CCMS: DBA Cockpit: DB2 for z/OS as Remote Database
http://scn.sap.com/docs/DOC-27124#jive_content_id_Setup_for_Remote_Monitoring_and_Administration_of_DB2_for_zOS