Set up Relational Connect for Sybase data sources

A DB2 federated database system enables users and applications to refer to multiple database management systems or databases within a single SQL statement. You can, for example, perform a UNION between a DB2 table and a Sybase view. A DB2 federated system includes a DB2 instance and database, and one or more data sources. Each data source consists of a non-DB2 DBMS and data.

In DB2 Relational Connect, different wrappers are provided to allow your DB2 server to access different data sources. Wrappers are available for Oracle, Sybase, and MS SQL Server.

Before setting up Relational Connect, you must do two things:

  1. Install and configure the Sybase client software on the DB2 federated server system. The Sybase client software must be obtained from Sybase.
  2. The Sybase client software must be configured to connect to the data source. It is recommended to test this connection using query tools of the data source vendor so that any problem encountered with server definitions can be isolated to either the installation and configuration of the data source client software or the installation and configuration of DB2 and DB2 Relational Connect.

To set up Relational Connect for Sybase data sources, enter the Sybase client installation directory. For example, if your Sybase database server is installed in the /Sybase directory, enter /Sybase in the field. The DB2 Setup wizard will install a wrapper for the data source and set up Relational Connect to access it.

You can set up Relational Connect for data sources later by using the DB2 Setup wizard or the Command Line Processor (CLP). For more information on using DB2 Relational Connect to access non-DB2 data sources see the Federated Systems Guide.