Mode 3 - External Server

DB-Gate runs as a server process on a different computer. That computer and the DB-Gate service running on it must be activated before any SQL processing is initiated.

The computer running this server mode can run on Windows, Unix, Linux, or any other operating system that supports Java. This mode has no initial extra processing and requires virtually no extra memory resources from the IBM i. Memory resources and processing power that would be used by the Java processing are consumed instead on the external computer running the DB-Gate server.

It is the user’s responsibility to ensure activation of the computer and server running the external DB-Gate.

  1. Install the DB-Gate server as follows:
    1. Close all applications.
    2. Run the setup file DB-Gate_setup.exe or the corresponding file for the server's operating system. The installation wizard opens.
  2. Proceed through the Wizard choosing the destination path, name and shortcut settings and click Install on the Ready to Install screen. .
  3. Upon completion select Launch DB-Gate Server and click Finish.

The Connect to System dialog appears.

Running the DB-Gate Server

The DB-Gate server is started either by:

  • Selecting Launch DB-Gate server at the end of the installation process
  • Starting the DB-Gate server from the Windows Start menu or the icon on the desktop

To run the server:

  1. Right-click on the icon in the System tray. The DB-Gate menu opens.
  1. Click Start DB-GateServer. The ConnectTo System dialog appears.
  2. Connect to the system as follows:
    1. Type the address (IP or network path) or host name for the DB-Gate server.
    2. Type the User and Password to access that host.
    3. Click OK.
  3. Log in to the IBM i.
  4. Start SQL by typing STRSQL.
  5. Connect to the SQL database instance.
  6. You can now work with DB-Gate.

DB-Gate Server Logs

NOTE: Only use this procedure under the supervision of Raz-Lee support personnel.

To view DB-Gate Server logs:

  1. Right-click on the icon in the System tray. The DB-Gate menu opens.
  2. Click About. The About DB-Gate Server dialog appears.


  1. Click Open Log... The Open File dialog box appears.


  1. Select the log file you want to view and click Open. The file opens by default in the internal Java viewer but can be viewed in any external tool.

NOTE: All DB-Gate log file names begin with the string dbgater .

NOTE: If you have a problem opening the file, ensure that txt.0 files are associated with a text file viewer/editor.

Ending DB-Gate Server

To end the DB-Gate Server:

  1. Right-click on the icon in the System tray. The DB-Gate menu opens.
  2. Click About. The Confirm Exit dialog appears.


  1. Click OK. The DB-Gate Server stops.