Chat now with support
Chat with Support

Toad Data Studio 1.1 - Release Notes

About 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. Create Toad Connection Profiles for DB2

Note: You must have a DB2 client installed before you can configure client connections and create connection profiles. Refer to IBM for information regarding a DB2 client download, http://www-01.ibm.com/software/data/db2/linux-unix-windows/downloads.html, or consult your organization's IT department. For a list of supported DB2 client versions, see the Toad Data Studio Release Notes.

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. If you previously used the Toad DB2 client installed with the product in prior versions, use this method to transfer the catalog from the previous Toad DB2 client to your current 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. Configure DB2 LDAP Support

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. Create Toad Connection Profiles for DB2

 

Related Topics

Create DB2 Connections

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating