IBM GC09-2830-00 manual Register this database as an ODBC data source

b.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.

c.Select the database that you want to add and click on the Next push button.

Step 4. Enter a local database alias name in the Database alias ®eld and add a comment that describes this database in the Comment ®eld. 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 5. 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.

a.Ensure that the Register this database for ODBC check box is selected.

b.Select the radio button that describes how you would like to register this database:

v 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.

vIf you would like only the current user to have access to this data source, select the As a user data source radio button.

c.If you would like to create an ODBC data source ®le to share database access, select the Create a ®le data source check box and enter the path and ®lename for this ®le in the File data source name ®eld.

d.Click on the Optimize for application drop down box and select the application for which you want to tune the ODBC settings.

e.Click on the Done push button to add the database that you selected. The Con®rmation window opens.

Step 6. 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 speci®ed or click on the Help push button for more information. For even more detailed information, refer to the Troubleshooting Guide.

Step 7. Enter your user ID and password and click on OK. If the connection is successful, a message con®rming the connection appears.

Chapter 9. Con®guring Client-to-Server Communications Using the Client Con®guration Assistant 109