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 F, Naming Rules.
| ||
Step 2. | Start the CCA. For more information, see Starting the Client Configuration Assistant. The Welcome window opens each time you start the CCA, until you add at least one database to your client. | ||
Step 3. | Click on the Add Database or Add push button to
configure a connection.
|
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 an access profile radio button and click on the Next push button. | ||
Step 2. | Click on the ... push button and select a profile. | ||
Step 3. | You are presented with a list of systems, instances, and databases. 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:
| ||
Step 5. | Click on the Next push button. | ||
Step 6. | Enter a local database alias name in the Database alias field
and add a comment that describes this database in the Comment
field. Click on the Next push button.
| ||
Step 7. | Register this database as an ODBC data source.
| ||
Step 8. | Click on the Test Connection push button to test the connection. The Connect to DB2 Database window opens. If the database that you want to add was not added successfully, click on the Change push button to change any settings that you may have incorrectly specified or click on the Help push button for more information. For even more detailed information, refer to the Troubleshooting Guide. | ||
Step 9. | Enter your user ID and password and click on OK. If the connection is successful, a message confirming the connection appears. | ||
Step 10. | You are now able to use this database. To finish using the Add Database SmartGuide, click on the Close push button; you can then add more databases by clicking on the Add push button or exit the CCA.
|
![]() |
This option cannot return information about pre-Version 5 DB2 systems or
any systems where an Administration Server is not running. 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 Discovery, perform the following steps:
Step 1. | Select the Search the network radio button and click on the Next push button. | ||
Step 2. | Click on the [+] sign beside the Known Systems icon to list all the systems known to your client. | ||
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. | You are presented with a list of systems, instances, and databases. Select the database that you want to add to your system. | ||
Step 5. | Select the type of connection that you want to make to the host or AS/400 database:
| ||
Step 6. | Click on the Next push button. | ||
Step 7. | Enter a local database alias name in the Database alias field
and add a comment that describes this database in the Comment
field. Click on the Next push button.
| ||
Step 8. | Register this database as an ODBC data source.
| ||
Step 9. | Click on the Test Connection push button to test the connection. The Connect to DB2 Database window opens. If the database that you want to add was not added successfully, click on the Change push button to change any settings that you may have incorrectly specified or click on the Help push button for more information. For even more detailed information, refer to the Troubleshooting Guide. | ||
Step 10. | Enter your user ID and password and click on OK. If the connection is successful, a message confirming the connection appears. | ||
Step 11. | You are now able to use this database. To finish using the Add Database SmartGuide, click on the Close push button; you can then add more databases by clicking on the Add push button or 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 for you.
To add a database to your system manually, perform the following steps:
Step 1. | Select the Manually configure a connection to a DB2 database
radio button and click on the Next push button.
| ||||||||
Step 2. | 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 and click on the Next push button. | ||||||||
Step 4. | Enter the required communication protocol parameters and click on the Next push button. For more information, click on the Help push button. | ||||||||
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. Add a comment that describes this database in the Comment field and click on the Next push button. If you are adding a database that resides on a host or AS/400 system, the Database name field will appear as follows:
| ||||||||
Step 6. | Register this database as an ODBC data source.
| ||||||||
Step 7. | Click on the Test Connection push button to test the connection. The Connect to DB2 Database window opens. If the database that you want to add was not added successfully, click on the Change push button to change any settings that you may have incorrectly specified or click on the Help push button for more information. For even more detailed information, refer to the Troubleshooting Guide. | ||||||||
Step 8. | Enter your user ID and password and click on OK. If the connection is successful, a message confirming the connection appears. | ||||||||
Step 9. | You are now able to use this database. To finish using the Add Database SmartGuide, click on the Close push button; you can then add more databases by clicking on the Add push button or exit the CCA.
|
When you have finished adding the host or AS/400 database to your system, we recommended that you bind any DB2 utilities or applications to the database you just added by performing 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 that you want to bind the utilities and packages against. |
Step 4. | Click on the Bind push button. |
Step 5. | Select the type of bind that you want to perform:
|
Step 6. | Click on the Continue push button. |
Step 7. | Enter a user ID and password to connect to the database. |
Step 8. | Select the utilities or applications that you want to bind and click on 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, or Installing DB2 Clients to install DB2 clients. |