Skip to Content
Author's profile photo Former Member

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


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


  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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.