DB2 Connect Quick Beginnings PE

Configuration Steps

To configure your workstation to access a host or AS/400 database, perform the following steps:

Step  1.

Log on to the system with a valid DB2 user ID. For more information, see Appendix D, Naming Rules.

Figure 00002674 not displayed.

If you are adding a database to a system that has a DB2 Connect server product installed, log on to this system as authority.

This restriction is controlled by the catalog_noauth database manager configuration parameter. For more information, refer to the Administration Guide.

Step  2.

The Welcome window opens each time you start the CCA, until you add at least one database to your client.

Step  3.

Click Add Database or Add to configure a connection.

You can use one of the following configuration methods:

Adding a Database Using a Profile

A profile contains information about instances and databases on a system, and databases within each instance. For information on profiles, see Creating and Using Profiles.

If your administrator provided you with a profile, perform the following steps:

Step  1.

Select the Use a profile radio button and click Next.

Step  2.

Click on the ... push button and select a profile.

Step  3.

A list, with the system, the instances, and the databases, is displayed. Select the database that you want to add to your system.

Step  4.

Select the type of connection that you want to make to the host or AS/400 database. Before you do this, you must select a host or AS/400 database from the list of databases in the profile.

  • To make a direct connection, select the Connect directly to the server radio button.
  • To make a connection through a DB2 Connect gateway, select the Connect to the server via the gateway radio button.

Step  5.

Click Next.

Step  6.

Enter a local database alias name in the Database alias field and optionally enter a comment that describes this database in the Comment field. Click Next.

Step  7.

If you are planning to use ODBC, register this database as an ODBC data source.
Note:ODBC must be installed to perform this operation.

  1. Ensure that the Register this database for ODBC check box is selected.
  2. Select the radio button that describes how you would like to register this database:
    • If you would like all users on your system to have access to this data source, select the As a system data source radio button.
    • If you would like only the current user to have access to this data source, select the As a user data source radio button.
    • If you would like to create an ODBC data source file to share database access, select the As a file data source radio button and enter the path and file name for this file in the File data source name field.
  3. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings.
  4. Click Finish to add the database that you selected. The Confirmation window opens.

Step  8.

Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.

Step  9.

In the Connect To DB2 Database window, enter a valid user ID and password for the remote database and click OK. If the connection is successful, a message confirming the connection appears.

If the connection test failed, you will receive a help message. To change any settings you may have incorrectly specified, click the Change push button in the Confirmation window to return to the Add Database Wizard. If problems persist, refer to the Troubleshooting Guide for more information.

Step 10.

You are now able to use this database. Click Add to add more databases, or click Close to exit the Add Database Wizard. Click Close again to exit the CCA.

Adding a Database Using Discovery



Figure 00002674 not displayed.

This option cannot return information about pre-Version 5 DB2 systems or any systems where an Administration Server is not running. It also cannot return information about host or AS/400 databases, unless they are already cataloged on a DB2 Connect EE server. For more information, refer to the Administration Guide.

You can use the Discovery feature to search the network for databases. To add a database to your system using the Discovery feature, perform the following steps:

Step  1.

Select the Search the network radio button and click Next.

Step  2.

Click on the [+] sign beside the Known Systems icon to list all the systems known to your systems.

Step  3.

Click on the [+] sign beside a system to get a list of the instances and databases on it.

If the system that contains the database that you want to add is not listed, perform the following steps:

  1. Click on the [+] sign beside the Other Systems (Search the network) icon to search the network for additional systems.
  2. Click on the [+] sign beside a system to get a list of the instances and databases on it.
  3. Select the database that you want to add, click Next, and proceed to Step 4.


Figure 00002674 not displayed.

The Client Configuration Assistant may be unable to detect a remote system if:

  • The Administration Server is not running on the remote system.
  • The Discovery function times out. By default, the Discovery function will search the network for 40 seconds; this may not be long enough to detect the remote system. You can set the DB2DISCOVERYTIME registry variable to specify a longer period of time.
  • The network that the Discovery request is running on is configured so that the Discovery request does not reach the remote system desired.
  • You are using NetBIOS as the Discovery protocol. You may need to set the DB2NBDISCOVERRCVBUFS registry variable to a larger value to enable the client to receive more concurrent Discovery replies.

For more information, refer to the Administration Guide.

If the system that you want to add is still not listed, it can be added to the list of systems by performing the following steps:

  1. Click Add System. The Add System window opens.
  2. Enter the required communication protocol parameters for the remote Administration Server and click OK. A new system is added. For more information, click Help.
  3. Select the database that you want to add and click Next.

Step  4.

Select the type of connection that you want to make to the host or AS/400 database. Before you do this, you must select a host or AS/400 database from the list of databases in the profile.

  • To make a direct connection, select the Connect directly to the server radio button.
  • To make a connection through a DB2 Connect gateway, select the Connect to the server via the gateway radio button.

Step  5.

Click Next.

Step  6.

Enter a local database alias name in the Database alias field and optionally enter a comment that describes this database in the Comment field. Click Next.

Step  7.

If you are planning to use ODBC, register this database as an ODBC data source.
Note:ODBC must be installed to perform this operation.

  1. Ensure that the Register this database for ODBC check box is selected.
  2. Select the radio button that describes how you would like to register this database:
    • If you would like all users on your system to have access to this data source, select the As a system data source radio button.
    • If you would like only the current user to have access to this data source, select the As a user data source radio button.
    • If you would like to create an ODBC data source file to share database access, select the As a file data source radio button and enter the path and file name for this file in the File data source name field.
  3. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings.
  4. Click Finish to add the database that you selected. The Confirmation window opens.

Step  8.

Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.

Step  9.

In the Connect To DB2 Database window, enter a valid user ID and password for the remote database and click OK. If the connection is successful, a message confirming the connection appears.

If the connection test failed, you will receive a help message. To change any settings you may have incorrectly specified, click the Change push button in the Confirmation window to return to the Add Database Wizard. If problems persist, refer to the Troubleshooting Guide for more information.

Step 10.

You are now able to use this database. Click Add to add more databases, or click Close to exit the Add Database Wizard. Click Close again to exit the CCA.

Adding a Database Manually

If you have the protocol information for the server that you want to connect to, you can manually enter all of the configuration information. This method is analogous to entering commands via the command line processor, however, the parameters are presented graphically.

To add a database to your system manually, perform the following steps:

Step  1.

Select the Manually configure a connection to a database radio button and click Next.

Step  2.

If you are using Lightweight Directory Access Protocol (LDAP), select the radio button that corresponds to the location where you would like your DB2 directories to be maintained:

  • If you would like to maintain the DB2 directories locally, select the Add database to your local machine radio button and click Next.
  • If you would like to maintain the DB2 directories globally at an LDAP server, select the Add database using LDAP radio button and click Next.

Step  3.

Select the radio button that corresponds to the protocol that you want to use from the Protocol list. You will also have the option of selecting the type of connection that you want to make to the host or AS/400 database. Select the The database physically resides on a host or AS/400 system check box, then select either of the following radio buttons:

  • To make a connection through a DB2 Connect gateway, select the Connect to the server via the gateway radio button.
  • To make a direct connection, select the Connect directly to the server radio button.

Click Next.

Step  4.

Enter the required communication protocol parameters and click Next. For more information, click Help.

Step  5.

Enter the database alias name of the remote database that you want to add in the Database name field and a local database alias name in the Database alias field.

If this is a host or AS/400 database, type the Location name for an OS/390 database, the RDB name for an AS/400 database, or the DBNAME for a VSE or VM database in the Database name field, and optionally add a comment that describes this database in the Comment field.

Click Next.

Step  6.

Register this database as an ODBC data source.
Note:ODBC must be installed to perform this operation.

  1. Ensure that the Register this database for ODBC check box is selected.
  2. Select the radio button that describes how you would like to register this database:
    • If you would like all users on your system to have access to this data source, select the As a system data source radio button.
    • If you would like only the current user to have access to this data source, select the As a user data source radio button.
    • If you would like to create an ODBC data source file to share database access, select the As a file data source radio button and enter the path and file name for this file in the File data source name field.
  3. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings.
  4. Click Finish to add the database that you selected. The Confirmation window opens.

Step  7.

Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.

Step  8.

In the Connect To DB2 Database window, enter a valid user ID and password for the remote database and click OK. If the connection is successful, a message confirming the connection appears.

If the connection test failed, you will receive a help message. To change any settings you may have incorrectly specified, click the Change push button in the Confirmation window to return to the Add Database Wizard. If problems persist, refer to the Troubleshooting Guide for more information.

Step  9.

You are now able to use this database. Click Add to add more databases, or click Close to exit the Add Database Wizard. Click Close again to exit the CCA.

Binding DB2 Utilities and Applications

When you have finished adding the host or AS/400 database to your system, we recommend that you bind any DB2 utilities or applications to the database you just added. To do so, perform the following steps:

Step  1.

Log on to the system with a user ID that has System Administrative (SYSADM), Database Administrative (DBADM), or Bind Add (BINDADD) authority on the database.

Step  2.

Start the CCA.

Step  3.

Select the database against which you want to bind the utilities and packages.

Step  4.

Click Bind.

Step  5.

Select the type of bind that you want to perform:

  • Select the Bind DB2 utilities radio button if you want to bind utilities against the database.
  • Select the Bind user applications radio button if you want to bind applications against the database.

Step  6.

Click Continue.

Step  7.

Enter a user ID and password to connect to the database and click OK.

Step  8.

Select the utilities or applications that you want to bind and click OK.



Figure 00002671 not displayed.

Now that you have configured host connections, go to Enabling Multisite Updates (Two-Phase Commit) if you want to enable the multisite updates feature.


[ Top of Page | Previous Page | Next Page ]