Step 3: Setting environment variables

To run the administration tools, several environment variables must be defined or modified. This is usually done in the sa_config.sh file, which is created by the SQL Anywhere installer, but you have the flexibility to do this however is most appropriate for your application.

  1. Set the PATH to include the following:

    /opt/sqlanywhere11/bin32

    (whichever is appropriate).

  2. Set LD_LIBRARY_PATH to include the following:

    For Linux:

    /opt/sqlanywhere11/jre_1.6.0_linux_sun_i586/lib/i386/client
    /opt/sqlanywhere11/jre_1.6.0_linux_sun_i586/lib/i386
    /opt/sqlanywhere11/jre_1.6.0_linux_sun_i586/lib/i386/native_threads

    For Solaris:

    /opt/sqlanywhere11/jre_1.6.0_solaris_sun_sparc/lib/sparc/client
    /opt/sqlanywhere11/jre_1.6.0_solaris_sun_sparc/lib/sparc
    /opt/sqlanywhere11/jre_1.6.0_solaris_sun_sparc/lib/sparc/native_threads
  3. Set the following environment variable:

    SQLANY11="/opt/sqlanywhere11"