DB2 Connect Quick Beginnings for UNIX**

Configuration Steps

To configure your workstation to access a database on a remote server, 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. 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 push button to configure a connection.

You can use one of the following configuration methods:

• Adding a Database Using a Profile.
• Adding a Database Using Discovery.
• Adding a Database Manually.

Adding a Database Using a Profile

A server profile contains information about server instances on a system, and databases within each server 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 the Next push button.
Step  2.	Click the ... push button and select a profile. Select a remote database from the object tree that is displayed from the profile, and if the database selected is a gateway connection, select a connection route to the database. Click the Next push button.
Step  3.	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  4.	If you are planning to use ODBC, register this database as an ODBC data source. Note: ODBC must be installed to perform this operation. 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 As a file data source radio button and enter the path and file name for this file in the File data source name field. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. Click Finish to add the database that you selected. The Confirmation window opens.
Step  5.	Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.
Step  6.	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  7.	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

This option cannot return information about DB2 systems earlier than Version 5 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 a 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 the Next push button.
Step  2.	Click the [+] sign beside the Known Systems icon to list all the systems known to your client.
Step  3.	Click 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 the Next push button, and proceed to Step 4. 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 Next, 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 Add System. The Add System window opens. Enter the required communication protocol parameters for the remote Administration Server and click OK. A new system is added. For more information, click Help. Select the database that you want to add and click Next.
Step  4.	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  5.	If you are planning to use ODBC, register this database as an ODBC data source. Note: ODBC must be installed to perform this operation. 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 As a file data source radio button and enter the path and file name for this file in the File data source name field. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. Click Finish to add the database that you selected. The Confirmation window opens.
Step  6.	Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.
Step  7.	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  8.	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 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 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 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. If DB2 Connect (or the DB2 Connect Support Feature) is installed on your machine and you select TCP/IP or APPC, you can select The database physically resides on a host or AS/400 system. If you select this check box, you will have the option of selecting 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. 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. 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 As a file data source radio button and enter the path and file name for this file in the File data source name field. Click the Optimize for application drop down box and select the application for which you want to tune the ODBC settings. 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.

You can use the Export function of the CCA to create a client profile for an existing client configuration and use it to create identical target clients across your network. A client profile contains database connection, ODBC/CLI, and configuration information for an existing client. Use the CCA Import function to set up multiple clients across your network. Each target client will have the same configuration and settings as the existing client. For more information on creating and using client profiles, see Creating and Using Profiles.

You have now completed all the tasks that are involved in Quick Beginnings and are ready to start using DB2 Connect. If you want to deploy this product using a distributed installation, refer to the Installation and Configuration Supplement.