DB2 Connect Quick Beginnings for UNIX**

Creating and Using Profiles

The information in this section describes how to create and use profiles to set up connections between DB2 clients and servers. To configure database connections on a DB2 client, you can use either a server profile or client profile.

Server Profiles

A server profile contains information about instances on a server system, and databases within each instance. The information for each instance includes the protocol information required to set up a client to connect to databases in that instance.

We recommend that you create a server profile only after you have created the DB2 databases that you want your remote clients to access.

To create a server profile, perform the following steps:

Step  1.	Start the Control Center. For more information, refer to Starting the DB2 Control Center.
Step  2.	Select the system that you want to create a profile for and right click. If the system that you want to create a profile for is not shown, select the Systems icon, click the right mouse button, and select the Add option. Click the Help push button and follow the online help.
Step  3.	Select the Export Server Profile option.
Step  4.	Enter a path and filename for this profile and select OK.

You are ready to use this profile on your system. For more information on how to add a database to your system using a server profile, go to Configuration Steps.

Client Profiles

Information in a client profile can be used to configure clients using the Import function in the Client Configuration Assistant (CCA). Clients can import all or a subset of the configuration information in a profile. The following scenario assumes that the database connections configured on one client will be exported and used to set up one or more clients.

Note:

Configuration profiles can also be imported using the db2cfimp command. Refer to the Command Reference for more information.

A client profile is generated from a client using the Export function of the CCA. The information contained in a client profile is determined during the export process. Depending on the settings chosen, it can contain the existing client's:

• Database connection information (including CLI or ODBC settings).
• Client settings (including database manager configuration parameters and DB2 registry variables).
• CLI or ODBC common parameters.
• Configuration data for the local APPC or NetBIOS communications subsystem.

To create a client profile, perform the following steps:

Step  1.	Start the CCA. For more information, see Starting the Client Configuration Assistant.
Step  2.	Click Export. The Select Export Option window opens.
Step  3.	Select one of the following export options: If you want to create a profile that contains all of the databases cataloged on your system, and all of the configuration information for this client, select the All radio button, click OK, and go to Step 8. If you want to create a profile that contains all of the databases cataloged on your system without any of the configuration information for this client, select the Database connection information radio button, click OK, and go to Step 8. If you want to select a subset of the databases that are cataloged on your system, or a subset of the configuration information for this client, select the Customize radio button, click OK, and go to the next step.
Step  4.	Select the databases to be exported from the Available databases box and add them to the Selected databases box by clicking on the push button. To add all of the available databases to the Databases to be exported box, click the >> button.
Step  5.	Select the check boxes from the Select custom export option box that correspond to the options that you want to set up for the target client. To customize settings, click on the appropriate Customize push button. The settings that you customize will only affect the profile to be exported, no changes will be made to your workstation. For more information, click Help.
Step  6.	Click OK. The Export Client Profile window opens.
Step  7.	Enter a path and file name for this client profile and click OK. The DB2 Message window appears.
Step  8.	Click OK.

To import a client profile, perform the following steps:

Step  1.	Start the CCA. For more information, see Starting the Client Configuration Assistant.
Step  2.	Click Import. The Select Profile window opens.
Step  3.	Select a client profile to import and click OK. The Import Profile window opens.
Step  4.	You can select to import all or a subset of the information in a Client Profile. Select one of the following import options: To import everything in a client profile, select the All radio button. To import a specific database, or settings, that are defined in a Client Profile, select the Customize radio button. Select the check boxes that correspond to the options that you want to customize.
Step  5.	Click OK. If you selected the All radio button, you are now ready to start using your DB2 product. For more advanced topics, refer to the Administration Guide and the Installation and Configuration Supplement.
Step  6.	You are presented with a list of systems, instances, and databases. Select the database that you want to add and click Next.
Step  7.	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  8.	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  9.	Click the Test Connection push button to test the connection. The Connect to DB2 Database window opens.
Step 10.	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 11.	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.