Document Type | Technical Information
Category | Administration
Document Number | TADTI060
Overview
CLI Log is generally set up to record logs of clients connecting through the CLI.
After setting the CLI Log, when restarting the DB, Tibero must be restarted after applying certain environment variables.
This explains how to restart the DB when setting the CLI Log.
Method
CLI Log is recorded when the two environment variables
TBCLI_LOG_LVL and TBCLI_LOG_DIR are applied and the client program is started. At the beginning of the log file, it is possible to verify which program is leaving the log in the following form.08-27 11:43:11.020867 [10800][TRC] clnt_drive:287 program : tbsql
In rare cases where CLI Log left by the Working Process is needed after restarting the DB following CLI Log setup,
in such cases, the two CLI Log environment variables
TBCLI_LOG_LVL and TBCLI_LOG_DIR must be applied before restarting Tibero.Subsequent CLI Logs will be recorded with the program name in the form tbsvr_WP000 as shown below.
08-27 11:43:47.951035 [8341][TRC] clnt_drive:287 program : tbsvr_WP000