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.
| ||
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:
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. | |||
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.
| ||
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.
| ||
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.
|
![]() | 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:
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:
| ||
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.
| ||
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.
| ||
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.
|
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:
| ||
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:
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.
| ||
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.
|
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:
|
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.
|
![]() | Now that you have configured host connections, go to Enabling Multisite Updates (Two-Phase Commit) if you want to enable the multisite updates feature. |