Package installation

Provides instructions for installing the DB Sync package, including setting up the environment, unzipping the package, and configuring necessary environment variables for proper functionality.

To install the DB Sync framework:
  1. Open a command line terminal.

  2. Set up the FGLGWS environment and GAS environment.

  3. Get the DB Sync zip archive, for example:
    fjs-dbsync-5.01.02-202412030057.zip
  4. Unzip the package in your prefered location. This will create a directory with the name "dbsync-version", with the product version number such as dbsync-5.01.02.

    Note:

    File changes are required, do not install under "Program Files" on Windows® platforms.

  5. Go to the DB Sync root installation directory.

  6. Set up the environment variables for DB Sync. This can be done by sourcing the envdbsync script provided in the DB Sync root installation directory.

    Note:

    If you plan to execute the envdbsync script from outside the installation directory, you must alter the script to set DBSYNCDIR variable to the installation directory of the framework.

    To source the environment setup file:

    • UNIX®/Linux:
       . ./envdbsync
    • Windows:
      envdbsync.bat
    The following environment variables will be set by the script:
    • The DBSYNCDIR environment variable must contain the installation directory of the framework.

    • The fglrun locale settings must match the database client locale. UTF-8 and CHAR length semantics is strongly recommended:
      • LANG/LC_ALL is set to UTF-8 (value is platform dependant)

      • FGL_LENGTH_SEMANTICS=CHAR

    • For the DB Sync server configuration and service programs:
      • PATH must contain the DBSYNCDIR/bin directory to find the DB Sync commands.

      • FGLLDPATH=$DBSYNCDIR/lib

      • FGLRESOURCEPATH=$DBSYNCDIR/lib

      • DBMONEY/DBFORMAT must not be set to use the defaults.

    • For the DB Sync service program only:
      • DBDATE=Y4MD-

      • DBFORMAT/DBMONEY must use . for decimal separator (the is the case when these env vars are not set)