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.ADMIN_INFO_SYSPARM 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).

Important

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.

This section contains the following topics:

Using the Db2 Connect feature

On this page