Quick Beginnings for DB2 Connect

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 F, Naming Rules. If you are adding a database to a system that has a DB2 Connect server product installed, log on to this system as a user with System Administrative (SYSADM) or System Controller (SYSCTRL) authority on the instance. For more information, see Working with the System Administrative Group. This restriction is controlled by the catalog_noauth database manager configuration parameter. For more information, refer to the Administration Guide.
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. Go to the section that describes the configuration method that you want to use: Adding a Database Using a Profile. Adding a Database Using Discovery. Adding a Database Manually.

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 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: 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.
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. If you do not specify a database alias name, the default will be the same as the remote database alias name.
Step  7.	Register this database as an ODBC data source. If you are not planning to use ODBC, click on the Done push button and go to the next step. Ensure that the Register this database for ODBC check box is selected. 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 Create a file data source check box and enter the path and filename for this file in the File data source name field. Click on the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. Click on the Done push button to add the database that you selected. The Confirmation window opens.
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.

Adding a Database Using Discovery

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: Click on the [+] sign beside the Other Systems (Search the network) icon to search the network for additional systems. Click on the [+] sign beside a system to get a list of the instances and databases on it. Select the database that you want to add, click on the Next push button, and proceed to Step 4. 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: Click on the Add System push button Enter the required communication protocol parameters for the remote Administration Server and click on OK. A new system is added. For more information, click on the Help push button. Select the database that you want to add and click on the Next push button.
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: 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.
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. If you do not specify a database alias name, the default will be the same as the remote database alias name.
Step  8.	Register this database as an ODBC data source. If you are not planning to use ODBC, click on the Done push button and go to the next step. Ensure that the Register this database for ODBC check box is selected. 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 Create a file data source check box and enter the path and filename for this file in the File data source name field. Click on the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. Click on the Done push button to add the database that you selected. The Confirmation window opens.
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.

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 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. If you are not using Lightweight Directory Access Protocol (LDAP), this tab will not be shown, skip this step and go to Step 3.
Step  2.	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 on the Next push button. If you would like to maintain the DB2 directories globally at an LDAP server, select the Add database using LDAP radio button and click on the Next push button.
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: OS/390 or MVS Location name AS/400 RDB name VM or VSE DBNAME When a database is created on the remote server, if a database alias is not specified during database creation, the database is created with a database alias=database_name; otherwise, the database alias is the name that was specified when the database was created.
Step  6.	Register this database as an ODBC data source. Ensure that the Register this database for ODBC check box is selected. 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 Create a file data source check box and enter the path and filename for this file in the File data source name field. Click on the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. Click on the Done push button to add the database that you selected. The Confirmation window opens. If you are adding a database using the manual method, you can also select the Node Options tab, the Security Options tab, or the Host or AS/400 Options tab (if you are adding a host or AS/400 database) to specify more detailed catalog information. Refer to the online help in each tab for more information. If you want to use the default settings for the node, security, and host or AS/400 (if applicable) options, click on the Done push button and go to the next step.
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: Select the Bind DB2 utilities radio button if you want to bind utilities against the database Select the Bind applications radio button if you want to bind applications against the database
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.

[ DB2 List of Books | Search the DB2 Books ]