Document Type | Technical Information
Category | Administration
Applicable Product Version | Tibero 7
Document Number | TADTI116
Overview
This document provides instructions on how to set related parameters to enable CLI logging in a Windows environment.
Method
1. Set Windows Environment Variables
TBCLI_LOG_LVL: Specifies the log level for tbCLI.
TBCLI_LOG_DIR: Specifies the directory where tbCLI logs will be saved.
Note
TBCLI_LOG_LVL Options (Default: DEBUG)
- FATAL: When application termination is required due to a critical error
- ERROR: Application tasks continue to run
- WARN: Not an error, but potentially problematic
- INFO: Information that tracks the progress of the application, usually coarse-grained info (e.g., API calls)
- DEBUG: Fine-grained logging useful for debugging the application (e.g., logging parameters, temporary values during calculations, etc.)
- TRACE: Very detailed information, more detailed than DEBUG
(e.g., unformatted binary data dumps, memory dumps, etc. as extended dump logs)- INTERNAL: Logs the most detailed information. This level is for internal debugging only (e.g., lock information)
2. Restart cmd in Administrator Mode
After setting the environment variables, restart cmd in Administrator mode.
CLI logs will be generated without restarting Tibero.
Example
- Pre-task: Create a directory to store CLI logs (ex: C:\tmp\clilog)
C:\tmp\clilog>dir
Volume in drive C has no label.
Volume Serial Number is 4C3C-DE6C
Directory of C:\tmp\clilog
2025-12-17 12:33 AM <DIR> .
2025-12-17 12:33 AM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 313,431,789,568 bytes free
--Set TBCLI_LOG_LVL
C:\tmp\clilog>set TBCLI_LOG_LVL=TRACE
--Check TBCLI_LOG_LVL setting
C:\tmp\clilog>echo %TBCLI_LOG_LVL%
TRACE
--Set TBCLI_LOG_DIR
C:\tmp\clilog>set TBCLI_LOG_DIR=C:\tmp\clilog
--Check TBCLI_LOG_DIR setting
C:\tmp\clilog>echo %TBCLI_LOG_DIR%
C:\tmp\clilog
--Run tbsql
C:\tmp\clilog>tbsql tibero
tbSQL 7
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Enter Password: ****
TBR-17001: Login failed: invalid user name or password.
SQL> q
--Check if CLI log file was created
C:\tmp\clilog>dir
Volume in drive C has no label.
Volume Serial Number is 4C3C-DE6C
Directory of C:\tmp\clilog
2025-12-17 12:35 AM <DIR> .
2025-12-17 12:33 AM <DIR> ..
2025-12-17 12:35 AM 11,561 tbcli_20251217003527_6952.log
1 File(s) 11,561 bytes
2 Dir(s) 313,877,712,896 bytes free
--Check contents of CLI log file
C:\tmp\clilog>more tbcli_20251217003527_6952.log
12-17 00:35:27.596075 [6952][DBG] clnt_drive:175 clnt_driver_mgr_init: clnt log initialized
12-17 00:35:272][DBG] clnt_drive:177 clnt_net_mgr_initialize
12-17 00:35:27.612090 [6952][DBG] clnt_drive:318 clnt_driver_mgr_init: Tibero 7.2 (Windows 64bit) log_lvl[5]
12-17 00:35:27.612090 [6952][DBG] clnt_drive:320 revision : 305407
12-17 00:35:27.612090 [6952][DBG] clnt_drive:322 coreset :
12-17 00:35:27.612090 [6952][DBG] clnt_drive:324 patches : FS02PS_700093a FS02PS_700103a FS02PS_344166f FS02PS_700110a FS02PS_342949f FS02PS_345378b FS02PS_700006a FS02PS_342949g FS02PS_700107a FS02PS_308549f FS02PS_346332a FS02PS_284118a FS02PS_284118b FS02PS_335301g FS02PS_700174a FS02PS_342949h FS02PS_344166g
12-17 00:35:27.612090 [6952][DBG] clnt_drive:326 patches_expand : FS02PS_700093a FS02PS_700103a FS02PS_344166f FS02PS_700110a FS02PS_342949f FS02PS_345378b FS02PS_700006a FS02PS_342949g FS02PS_700107a FS02PS_308549f FS02PS_346332a FS02PS_284118a FS02PS_284118b FS02PS_335301g FS02PS_700174a FS02PS_342949h FS02PS_344166g
12-17 00:35:27.612090 [6952][DBG] clnt_drive:328 cli_charset : UTF8
12-17 00:35:27.612090 [6952][:329 host name : DESKTOP-KKBSK7O
12-17 00:35:27.612090 [6952][DBG] clnt_drive:330 terminal : DESKTOP-KKBSK7O
12-17 00:35:27.612090 [6952][DBG] clnt_drive:331 program : tbsql.exe
12-17 00:35:27.612090 [6952][DBG] clnt_drive:333 wchar_size : 2 (default)
12-17 00:35:27.612090 [6952][DBG] clnt_drive:335 ignore underflow: 0
12-17 00:35:27.612090 [6952][DBG] clnt_ska.c:439 clnt_ska_init
12-17 00:35:27.612090 [6952][DBG] cli_comm_m:041 cli_comm_mgr_initialize
12-17 00:35:27.612090 [6952][DBG] cli_api_en:085 cli_api_alloc_env:henv[00007FF6DCE30D08] use_multi_thread[true]
12-17 00:35:27.612090 [6952][DBG] cli_env.c :034 cli_env_new:env[00000079038FDC28]
12-17 00:35:27.612090 [6952][DBG] clnt_err_c:032 clnt_err_conv_get_filepath_from_env:env_name[TBCLI_ERR_CONV] filepath[]
12-17 00:35:27.612090 [6952][DBG] cli_handle:083 cli_handle_mgr_register:handle_type[1] ptr[0000026E11743440] handle_id[0000026E11743440]
12-17 00:35:27.612090 [6952][TRC] cli_api_en:097 cli_api_alloc_env RETURNS:henv[16777216]
12-17 00:35:27.612090 [6952][DBG] cli_api_db:096 cli_api_alloc_dbc:henv[16777216] hdbc[00007FF6DCE30D0C]
12-17 00:35:27.612090 [6952][DBG] cli_handle:156 cli_handle_mgr_get:handle_id[16777216] handle_type[1] ptr[00000079038FDC10]
12-17 00:35:27.612090 [6952][DBG] cli_dbc.c :162 cli_dbc_new:dbc[00000079038FDC20] env[0000026E11743440]
12-17 00:35:27.612090 [6952][DBG] clnt_comm.:025 clnt_comm_init:comm[0000026E1172C090]
12-17 00:35:27.612090 [6952][DBG] clnt_strea:444 clnt_stream_init:stream[0000026E1172C498]
12-17 00:35:27.612090 [6952][DBG] clnt_strea:466 clnt_stream_init:set last_multi_fetch_result_set as NULL
12-17 00:35:27.612090 [6952][DBG] cli_env.c :116 cli_env_register_dbc:env[0000026E11743440] dbc[0000026E11744860]
-- More (25%) --