Connecting a Solution Manager on DB2 LUW to a DB2 zOS system
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
- 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>
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
Be the first to leave a comment
You must be Logged on to comment or reply to a post.