Linking OpenLink Database Agents

It is sometimes necessary to link or re-link your   OpenLink database agents when one of the following situations arise:

  • No database agent executable was supplied with the OpenLink server components installed on your OpenLink server machine
  • A database agent executable file exists but is unable to converse with your database server due to version incompatibility

OpenLink provides a database agent relink script for each supported database engine, this script is name using the following convention:

ld - indicates a link script

XXX - first three letters of database name

X - major and minor release number

Relink Steps

  1. Move to the "lib" sub-directory of your OpenLink server components installation directory e.g: "/usr/openlink/lib"

  2. Setup key OpenLink link script environment variables which create a reference to key database environment variables required for making a native connections to your database engine:

    DB2
    DB2DIR=$DB2INST

    Informix
    INFORMIX5DIR=$INFORMIXDIR
    INFORMIX6DIR=$INFORMIXDIR
    INFORMIX7DIR=$INFORMIXDIR

    Ingres
    INGRES6DIR=$II_SYSTEM/ingres
    INGRES7DIR=$II_SYSTEM/ingres

    Oracle
    ORACLE6DIR=$ORACLE_HOME
    ORACLE7DIR=$ORACLE_HOME
    ORACLE8DIR=$ORACLE_HOME

    Solid
    SOLIDDIR=$SOLID                                            

    Sybase
    SYBASE10DIR=$SYBASE
    SYBASE11DIR=$SYBASE
    SYBASE4DIR=$SYBASE

    Unify
    UNIFYDIR=$UNIFY../lib

    Velocis
    VELOCISDIR=$VELOCIS

    Virtuoso
    VIRTUOSODIR=$VIRTUOSO

    You can also opt to manually configure these values in the "dbpaths" file situated in the same directory as your database agent link script.

  3. Ensure that the "lib" subdirectory that your are working within is also part of your system PATH, if this isn't the case add this directory to the system PATH.

  4. Run the link script ldXXXX  which will attempt to build a new database agent (XXX_sv). Once the relink process is completed the new database agent executable is placed  in the "bin" subdirectory directory of your OpenLink server components installation using. The new database agent binary will be named accordingly using the " XXX_sv"  database agent naming convention.