Server Agent Administration

Sybase

Note:

The Sybase Agent is no longer required, all Sybase connectivity is handled by the TDS Agent.

See: TDS Agent

This section remains purely for reference on previous OpenLink versions

When configuring a Sybase database agent the critical configuration items are:

• Database Identification - this is the name of the Sybase database to be connected to ie pubs2 in the case of the Sybase provided sample database. This is the value that you enter into the "Database Name" field of either your Admin Assistant's database agent configuration form or wizard dialog. If you choose to have database identification take at the client rather than server, you enter this value into the "Database Name" field or connection attribute when configuring your OpenLink client.

Sybase provides a number of environment variables for configuring database clients, the basic set required for successfully connecting your database agent to a Sybase database server are tabulated below:

Table: 1. Default Rule Book settings

Rule Book Section & parameters	Default Rule Book Settings	Notes
[Environment SYBASE4]
SYBASE	/ dbs/sybase4	Full path to the base directory for the Sybase installation.
DSQUERY	SYBASE	Name of the Sybase Query Server that you are connecting to.
[Environment SYBASE10]
SYBASE	/ dbs/sybase10	Full path to the base directory for the Sybase installation.
DSQUERY	SYBASE	Name of the Sybase Query Server that you are connecting to.
[Environment SYBASE11]
SYBASE	/ dbs/sybase11	Full path to the base directory for the Sybase installation.
DSQUERY	SYBASE	Name of the Sybase Query Server that you are connecting to.

Note:

On some systems, like RedHat Linux, if the environment variable LANG=en_US is set it may need to be unset, or the environment variable LC_ALL=default set in the 

RuleBook to avoid RPC:Time Out errors on connect.

Rebuilding Sybase Database Agents

OpenLink provides a relinkable library and script files that enable you to rebuild your database agents as shared, as opposed to statically linked binaries, or for the purposes of getting a closer database implementation fit, should your Sybase database environment be a more recent release than the actual version used by OpenLink to build the database agent installed on your system. Please read the Relinking OpenLink Database Agents section that follows, for details on how to perform this task.

Application Server & 3-Tier Architecture Configuration

There may be situations in which you are unable to install your OpenLink Request Broker and Database Agents on the same machine as the one hosting your Sybase database server. Irrespective of the reasons that lead you to this scenario, it is possible to configure your OpenLink database agents hosted on your Application Server machine such that they connect to a remote Sybase database on your Database Server machine using Sybase database specific networking (Open Client) as opposed to OpenLink's Database Independent Networking. The end result being a 3-tier distributed OpenLink architecture in which the communication between OpenLink clients and database agents use OpenLink Database independent Networking, while the communication between the Sybase database agent and the Sybase database server uses Sybase Open Client.

Configuration Steps:

Assuming you have an Sybase Database Server machine called "mainserver2" that has an Sybase Server named "mainserver2" up and running:

1. On your Application Server (the machine hosting your database agents) create an Open Client Database Connection Alias named "mainserver2" (for purposes of this example only).

2. Ensure that you have a usable connection to the remote Sybase database server using the Open Client Database alias "mainserver2"

3. Add the following values to the "Server Options" field within the Admin Assistant Forms or Wizards used to configure your database agent. If you choose to set this value on the client simply enter the same value into to the "Database Name" Attribute associated with the configuration of your OpenLink client (see OpenLink ODBC or JDBC or UDBC client configuration for more details):

      mainserver2

You may also enter the following values into the "Database Server Options" field: -s mainserver2

See Also:

Application Server Architecture for various illustrations of distributed client-server architectures supported by 

OpenLink database agent

Unicode Configuration

See the Unicode section? for configuration details.