Attachment of SQL Explorer to local or remote Db2 subsystems

A 

BMC AMI SQL Explorer for Db2

 session is always attached to a Db2 subsystem, either through the Call Attach Facility (CAF) or through the Db2 Distributed Data Facility (DDF).

During a session, you can also attach to an additional Db2 subsystem, as follows:

  • Use CAF to attach to a subsystem on the same MVS system.
  • Use DDF to attach to a subsystem on any MVS system.

Related topic

Setting-up-SQL-Explorer

The following table describes the requirements of CAF and DDF: 

Access method

Description

CAF

The target Db2 subsystem must be in the same MVS system as the current

Some content is unavailable due to permissions.

session.

DDF

The target Db2 subsystem has the following requirements:

  • Can be in a different MVS system from the current

    Some content is unavailable due to permissions.

    session
  • Must be defined to Db2 in the communications database

This section contains the following topics:

 

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