Limited support BMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see BMC AMI Catalog Manager for Db2 13.1.

Using the Db2 Connect feature

The Db2 Connect feature enables you to connect your attached SSID to another SSID through the Db2 Distributed Data Facility (DDF) in order to execute SQL.

Db2 Connect has the following requirements:

  • Catalog Manager must be installed on the target z/OS system at the same maintenance level as the product instance from which you are connecting.
  • The IBM SYSPROC.DSNWZP stored procedure must be installed. For more information, see the IBM Db2 for z/OS Installation Guide.
  • The Db2 Distributed Data Facility (DDF) must be installed.
  • The target subsystem can be on the same system or on a different z/OS system.
  • The target subsystem can be at any level of Db2.

Catalog Manager provides the following features:

  • If catalog indirection was set up when Catalog Manager was installed, you can connect to other catalog copies.
  • If you install the IBM SYSPROC.ADMIN_DS_LIST stored procedure, you can obtain data set information on the remote SSID. For more information, see Obtaining-data-set-information-from-a-remote-SSID.

  • If you install the IBM SYSPROC.ADMIN_COMMAND_Db2 stored procedure, you can issue the Db2 DISPLAY, START, and STOP commands on the remote SSID. For more information, see Connecting-to-a-remote-SSID-and-issuing-Db2-commands-to-manipulate-objects .

    If you issue the Db2 commands on a local SSID, the product calls the IBM Instrumentation Facility Interface (IFI).

Note

When you are connected to a remote SSID, Catalog Manager does not support the following commands:

  • SPACE and STATS commands that invoke DASD MANAGER PLUS
  • The DSN command DCLGEN
  • The DSN commands BIND, REBIND, and FREE for PLAN, although these commands are supported for PACKAGES

The following figure shows how Catalog Manager is attached to Db2A and connected to Db2B. Catalog Manager could be connected to Db2C through the session attached on Db2A.

GUID-50D20391-A13B-4C93-B7D9-59CC7EA26A16-low.png

This section contains the following topics:

Related topic

Accessing-other-Db2-subsystems

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*