Configuring the Client Workstation

To access a DB2 database through XDB Link from an XDB client application, you must use the Options program to point the workstation to the DB2 database and establish an operating environment compatible with the DB2 host system.

To configure the client workstation, take the following steps before you execute an XDB client application.

To configure an XDB client workstation for DB2

1. On the machine where XDB Link is installed, start the communications software (SNA or TCP/IP), if it is not already running.
2. If you are using XDB Link in a gateway configuration, start the XDB Server on the machine where XDB Link is installed.
3. At the client workstation, start Options by selecting its icon from the XDB program group or folder.
4. When the Options window opens, set the following values on the Connect page:

   If you are using a...	Make these selections...
   Gateway configuration	In the Server Name field, select the name of the XDB Server on which XDB Link is installed. In the Location field, specify the name of the DB2 location. In the Protocol field, select protocol this machine will use to communicate with the XDB Server on which XDB Link is installed.
   Direct-connect configuration	In the Location field, specify the name of the DB2 location. In the Protocol field, select DRDA.

5. Set these additional options:
   • On the Security page, enable the Client Security option.
   • On the SQL page, set SQL Compatibility Mode to DB2.
6. Click OK to save your settings and close Options.
7. Run the client application.