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%) --