If you have the information for the database you want to connect to and the server upon which it resides, you can manually enter all of the configuration information. This method is analogous to entering commands using the command line processor, however, the parameters are presented graphically.

• Ensure that you have a valid DB2^® user ID for the database you want to connect to.

• If you are configuring a connection from a system that has a DB2 server or DB2 Connect™ server product installed, ensure that you have a user ID with SYSADM or SYSCTRL authority for the database manager instance.

1. Log on to the system with a valid DB2 user ID.

2. Start the CA. The CA can be started from the Start menu on Windows^® or using the db2ca command.

3. On the CA menu bar, under Selected, choose Add Database Using Wizard.

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

5. If you are using Lightweight Directory Access Protocol (LDAP), select the radio button that corresponds to the location where you want DB2 directories to be maintained. Click Next.

6. Select the radio button that corresponds to the protocol that you want to use from the Protocol list. (

   Note: While APPC, APPN, or NetBIOS might still appear as options, they are no longer supported.) If DB2 Connect is installed on your system and you select TCP/IP, you have the option to select The database physically resides on a host or OS/400 system. If you select this check box, you have the option of selecting the type of connection that you want to make to the host or OS/400^® database:

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

7. Type the required communication protocol parameters and click Next.

8. Type 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 you are adding a host or OS/400 database, type the location name for an OS/390^® or z/OS^® database, the RDB name for an OS/400 database, or the DBNAME for a VSE or VM database in the Database name field. Optionally, you can add a comment that describes this database in the Comment.

   Click Next.

9. If you are planning to use ODBC, register this database as an ODBC data source. Ensure that ODBC is installed before performing this operation. Click Next.

10. In the Specify the node options window, select the operating system, and type the remote instance name for the database system you want to connect to.

11. In the Specify the system options window, ensure that system name, host name, and operating system are correct. The information on this panel is used to configure the administration node. You can optionally enter a comment. Click Next.

12. In the Specify the security options window, specify the security option that will be used for authentication.

13. Click Finish. You can now use this database. Select the Exit menu action to close the CA.

Parent topic: Client-to-server communications configuration overview

Related tasks
Testing a database connection using the Configuration Assistant