Chat now with support
Chat with Support

Toad Data Point 6.0 - User Guide

About 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.

Note: You must have a DB2 client installed before you can configure client connections and create connection profiles. Beginning with Toad Data Point 3.6, a DB2 client is no longer included in the product installation. 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 Point Release Notes.

Show all

If You Previously Used the Toad DB2 Client

If you previously used the Toad DB2 client installed with earlier versions of Toad Data Point, you may need to do the following:

  • Install a DB2 client from IBM and set it as the default. Because Toad no longer installs a client along with the product, you must now have a DB2 client from IBM installed to use your DB2 connections.
  • Transfer the catalog from the previous Toad DB2 client to your current default DB2 client. If you used the Toad DB2 client in a previous version of Toad, install a default DB2 client from IBM, and then transfer the catalog from the Toad client to the new default DB2 client. See Transfer a Catalog Any Time After Initial Setup.

To check default client

  • You may want to check that the correct client is set as the default, before you import a catalog to it. The default client is identified as such in the Start menu (Start | All Programs | IBM DB2). The default client has “(Default)” after the client name.

To specify default client

  • You can specify the default client using the Database Client Interface Selection Wizard (Start | All Programs | IBM DB2 client name | Database Client Interface Selection Wizard).

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating