Learn more about Toad for IBM DB2
at Dell Software

Find solutions and downloads at the
Dell Software Support Portal

 

Toad for IBM DB2 6.0

You are here: Manage Connections > Configure DB2 Client Connections

Configure DB2 Client Connections

Setting up connections to the DB2 for LUW databases and DB2 for z/OS subsystems that Toad will manage requires two main steps.

Step 1. Configure DB2 client connections - Before you can create a connection profile, each of the databases or subsystems must be cataloged on the DB2 client. This topic helps you with that process.

Step 2. Create connection profiles - Step 2 involves creating Toad connection profiles for the cataloged DB2 databases or subsystems. Each profile contains the information that Toad needs to connect to the system, such as the user ID and password, DB2 registry settings, and the default schema. See Create Toad Connection Profiles for DB2 for more information.

Show all

Configure DB2 Client Connections

Use one of the following methods to catalog each of the databases or subsystems on the DB2 client.

Transfer a Catalog Any Time After Initial Setup

Use this method to transfer a catalog from another DB2 client on your machine to your default DB2 client.

To transfer a catalog any time after initial setup

  1. In the Connection Manager, click in the toolbar.

    Note: If the Client Configuration Wizard opens, Toad found only one DB2 client installed.

  2. From the DB2 Client list, select the name of the DB2 client whose catalog you want to transfer to your default DB2 client.

    This list contains all current previously installed DB2 clients on your computer, including the default DB2 client instance and any Toad DB2 client installations.

  3. Click OK.
  4. To create a connection in Toad for any of the transferred catalog entries, see Create Toad Connection Profiles for DB2.

Note: Toad for DB2 supports LDAP connections. See Configure DB2 LDAP Support for more information.

Maintain DB2 Client Connections

Additionally, Toad provides functionality to perform the following maintenance on the catalog you set up for the current DB2 client:

After you have set up the catalog on the current DB2 client, you can proceed to the second phase of the Toad connection setup. This phase involves creating Toad connection profiles for the cataloged DB2 databases or subsystems. See Create Toad Connection Profiles for DB2 for more information.

 

Related Topics

Create DB2 Connections

of