Overview

This document explains how to configure CLI logs to record connection and operation logs of clients accessing the database through the CLI in Tibero, and how to set the log level to check the logs.

Method

1. How to set TB_CLI_LOG_LEVEL

alter system set _cli_log_level = <log-level> ;
<log-level> is a number between -1 and 6. (-1 means no logs are recorded.)

• Meaning of LOG_LEVEL

0(FATAL), 1(ERROR), 2(WARN), 3(INFO), 4(DEBUG), 5(TRACE), 6(INTERNAL)
The values in parentheses correspond to the TBCLI_LOG_LVL environment variable.

The default value is 2.

FATAL: Used when a critical error requires the application to terminate.
ERROR: An error occurs, but the application continues its operation.
WARN: Not an error, but requires caution.
INFO: Information that allows tracking the progress of the application.
DEBUG: Fine-grained logging helpful for debugging the application.
TRACE: Very detailed information, providing more detailed logging than DEBUG.
INTERNAL: Logs the most detailed information. (This level is used only for internal debugging.)