Skip to main content

Search

Welcome to Tibero GTS!

Setting up MS-SQL DBLink in Tibero (Windows) (3)

Document Type | Technical Information

Category | Interface/Integration

Document Number | TIITI031

 

Overview

Once the integration between Tibero and MS-SQL Gateway is complete, verify that the Gateway service is running, and then configure the tbdsn.tbr file to register the DBLink connection information.
 
This article explains how to verify Gateway execution and the procedure to configure tbdsn.tbr.
 
 

Method

Run and Verify TbGateway

1. Start the service and check status
prunmgr.exe should be run, then click the Start button to start the Gateway service.
prunmgr.exe //ES//TBGateway
Click Start button

2. Verify execution
Check the status to confirm the service is running properly.
Note
  1. When running the Java Gateway, a log folder is created alongside it. In case of issues, you can analyze the cause through these log files.
  2. A Failed creating Java error may occur in the log folder.
    * Cause: This happens if the msvcr71.dll file is missing due to changes in daemon registration method in JDK 1.6 environment.
    * Solution: Copy msvcr71.dll to the windows/system32 directory or use JDK 1.5.
  3. After running prunmgr.exe //ES//TBGateway, you can directly specify the JVM path in the Java tab.
 

tbdsn.tbr Configuration

To create a DBLink, add the MSSQL connection information to the tbdsn.tbr file.
Existing content (information may vary depending on installation environment)
Tibero6=(
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero6)
    )
)

# Additional content
msgate=(
    (GATEWAY=(LISTENER=(HOST=192.168.20.130)
                        (PORT=9093))
             (TARGET=192.168.77.224:1433:tbTest)
             (TX_MODE=GLOBAL))
)


Explanation of Configuration

  1. Set the IP, PORT, DB_NAME, and GW_TX_MODE for the Java Gateway.
  2. In the DB_NAME field, specify the actual IP, PORT, and database name of the SQL Server to connect to.
  3. GW_TX_MODE can be set to either LOCAL or GLOBAL, with the default being GLOBAL.
    * GLOBAL: Operates using 2 Phase Commit method.
    * LOCAL: Operates using Local Commit method.
  4. When setting GW_TX_MODE to GLOBAL mode, make sure that the DTC (Distributed Transaction Coordinator) service on the MSSQL server is activated.
 
 
 

Related to