Document Type | Technical Information
Category | Utility
Applicable Product Versions | 6FS07, 6FS07PS, 7FS02, 7FS02PS
Document Number | TUTTI004
Overview
This guide explains how to configure the client tool tbsql on a remote server.
Method
1. Package the $TB_HOME/client directory into a tar file and transfer it to the remote server
#. tibero server $ su - [tibero installation OS user] $ tar -cf client.tar $TB_HOME/client $ scp client.tar [target user]@i[target ip]:[target path]
2. Extract the archive at the desired path on the remote server
#. remote server $ su - test $ tar -xf /home/test/client.tar
3. Configure the bash profile of the remote server OS user
Refer to the tibero user bash profile when writing this.
#. remote server $ vi ~/.bash_profile export TB_HOME= /home/test #. directory where client was extracted export TB_SID= [db sid] export PATH=.:$TB_HOME/bin:$TB_HOME/client/bin:$PATH export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib:$LD_LIBRARY_PATH $ source ~/.bash_profile
4. Modify the client/config/tbdsn.tbr file according to your environment
#. remote server
[db sid]=(
(INSTANCE=(HOST=[db server ip])
(PORT=[db port])
(DB_NAME=[db name])
)
)
#. Example
test=(
(INSTANCE=(HOST=10.x.x.x)
(PORT=8629)
(DB_NAME=tibero)
)
)
5. Connect to session
After completing the setup, connect to the session using tbsql.
$ tbsql sys/tibero