tb=(
    (INSTANCE=(HOST=168.1.1.33)
              (PORT=8629)
              (DB_NAME=tibero)
    )
)

tbdsn.tbr has the following structure:

SID_1=(
       (INSTANCE=(item1=value1)
                 (item2=value2)
        ...
       )
)

SID_2=(
       (INSTANCE=(item1=value1)
                 (item2=value2)
        ...
      )
)

TB_LANG=EUCKR

TBCLI_LOG_LVL=TRACE

TBCLI_LOG_DIR=/home/test/log

...

An SID is a unique name that identifies a corresponding server for a client and includes detailed information about the server. Multiple SIDs can be listed.

In tbdsn.tbr, alphabetical characters (A - Z, a - z), digits (0 - 9), and hyphens (-) can be used for an SID.

Detailed information about SIDs is shown below:

A client environment can also be specified in the file tbdsn.tbr without environment variables. If the environment is specified in both the file and with variables, the configuration in the file takes precedence.

Replication servers are multiple physically independent servers that are replicated. Any replicated servers can be accessed. A replicated server can be replaced with another replicated server when it is terminated.

To configure a replication server in tbdsn.tbr, specify each server with an INSTANCE entry with a single SID. CTF (Connection Time Failover) is always supported for the SID configured for the replication server.

tb=(
    (INSTANCE=(HOST=168.1.1.33)
              (PORT=8629)
              (DB_NAME=tibero)
    )
    (INSTANCE=(HOST=192.168.1.25)
              (PORT=8629)
              (DB_NAME=tibero2)
    )
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )     

Tibero provides load balancing to prevent a single server from being accessed too much. It prevents heavy loads on a system by distributing access to multiple servers.

Load balancing is specified in tbdsn.tbr as follows:

tb=(
    (INSTANCE=(HOST=168.1.1.33)
              (PORT=8629)
              (DB_NAME=tibero)
    )
    (INSTANCE=(HOST=192.168.1.25)
              (PORT=8629)
              (DB_NAME=tibero2)
    )
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )
    (LOAD_BALANCE=Y)
)        

As in the above example, if LOAD_BALANCE is specified as Y, the load balancing function is enabled. If it is specified as another value or omitted, the function is not used.

If Tibero terminates due to a failure when it is part of a TAC or is a replication server, the CLI module automatically recovers the corresponding session by accessing another instance or replicated server.

Failover is specified in tbdsn.tbr as follows:

tb=(
    (INSTANCE=(HOST=168.1.1.33)
              (PORT=8629)
              (DB_NAME=tibero)
    )
    (INSTANCE=(HOST=192.168.1.25)
              (PORT=8629)
              (DB_NAME=tibero2)
    )
    (INSTANCE=(HOST=localhost)
              (PORT=8629)
              (DB_NAME=tibero)
    )
    (USE_FAILOVER=Y)
    (FORCE_FAILOVER_DELAY=10)
)        

As in the above example, if USE_FAILOVER is specified as Y, the failover function is enabled. However, recovery at the statement level is not supported.

FORCE_FAILOVER_DELAY is a failover option that can be used to cause a delay (in sec) before attempting to connect to another instance or replicated server. In the previous example, there will be a 10 second delay before failing over to another instance.