Document Type | Technical Information
Category | Administration
Applicable Product Version | 6FS07
Document Number | TADTI142
Overview
Starting from 6FS07, the event log has been changed to ILOG.
This guide provides information on key parameters related to ILOG, as well as how to extract and check ILOG.
- OS Version: Red Hat Enterprise 8.10
- Tibero Version: Tibero7 (DB7.2.4)
Method
ILOG
The internal log file (ILOG) is a file where system logs for events set per thread are recorded.
tbiv
tbiv is a utility that converts ilog files, which are stored in binary format,
so that users can check their contents.
1. ILOG Related Parameters
| Parameter | Description | Default Value (as of 7.2.4) |
|---|---|---|
| ILOG_BACKUP_SIZE_LIMIT | Total size limit of backed-up ilog | (MAX_SESSION_COUNT + 150) * (ILOG_FILE_SIZE) |
| ILOG_DEST | Absolute path where Ilog will be created | $TB_HOME/instance/$TB_SID/log/ilog If the LOG_DEFAULT_DEST parameter is set, LOG_DEFAULT_DEST/ilog |
| ILOG_FILE_BACKUP_ON_BOOT | Whether to create an ilog backup and back up the existing file when the DB boots. If Y, a new backup directory is created; if N, records continue in the existing file. | Y |
| ILOG_FILE_SIZE | File size limit per ILOG If this value is exceeded, the file is renamed and a new file is created | At least 512KB, and the smallest size divisible by ILOG_MMAP_SIZE |
| ILOG_KEEP_BACKUP_ASIDE | Whether to include the backup directory size in the ILOG_TOTAL_SIZE_LIMIT calculation. (If Y, managed separately; if N, included). | N |
| ILOG_MAP | Absolute path of the ilog map (tag on/off setting file) | "" (blank) |
| ILOG_MMAP_SIZE | Specifies the MMAP page size to use for MMAP when leaving an ILOG | 64 * 1024 |
| ILOG_TOTAL_SIZE_LIMIT | Maximum total capacity that ILOG can occupy | ((WTHR_PROC_CNT + 1) * WTHR_PER_PROC + PEP_PROC_CNT * WTHR_PER_PEP + ACF_CMPT_CNT + 150) * (ILOG_FILE_SIZE) * 2 USE_ILOGWhether to use ilogY |
2. Enabling and Disabling ILOG TAG
In ILOG, you can enable or disable TAGs to check logs in more detail for the category corresponding to a specific TAG.
However, since there are many types of TAGs and inappropriate use may generate excessive ILOGs, it is recommended to apply them carefully by referring to the research center or engineer guide when log analysis is required.
2.1 Dynamic Change
$ tbsql sys/tibero -- Enable (1) ALTER SYSTEM ILOG ENABLE NAME 'BODY_SQL_PROCESS'; -- Enable (more than 2) ALTER SYSTEM ILOG ENABLE NAME 'BODY_MSG_CSR_BIND_PARAM_INFO, BODY_SQL_PROCESS';
$ tbsql sys/tibero -- Disable (1) ALTER SYSTEM ILOG DISABLE NAME 'BODY_SQL_PROCESS'; -- Disable (more than 2) ALTER SYSTEM ILOG DISABLE NAME 'BODY_MSG_CSR_BIND_PARAM_INFO, BODY_SQL_PROCESS';
2.2 Change via ILOG.MAP
--Create and modify ilog.map $ vi ilog.map Or copy the example file (ilog.map.example) to $TB_HOME/config/ ex) $ cp ilog.map.example ilog.map --Enable tag ex) TAG : PSM, EXTPROC on --Disable tag ex) TAG : PSM, EXTPROC off -- Apply ILOG_MAP parameter to tip file and restart $ vi $TB_HOME/config/$TB_SID.tip ILOG_MAP=[absolute path where ilog.map exists] ex) ILOG_MAP=/home/tibero/tibero7/config/ilog.map $ tbdown; tbboot
3. tbiv Options
| Option | Description |
|---|---|
| -x | Extracts ilog format to ilog_fmtmap.bin file This file is required to view on another server |
| -o | Specifies output file path (default: standard output stdout) |
| -l | Splits and saves output file by specified size (MB) |
| -T | Does not display time information on output |
| -k | Display system tick |
| -s | Display sequence number |
| -i | Display file info |
| -r | Outputs only logs within the specified time range (YYYYMMDDHH24MISS ~ YYYYMMDDHH24MISS) |
4. Usage Example
ex) Extract Thread id 16
$ tbiv -o test.txt tiberin-16.ilg
Tibero Internal Log Viewer (7 r303667, little-endian)
TmaxTibero Corporation Copyright (c) 2020-. All rights reserved.
Completed.
[test.txt]
11/10 17:05:26.8 0-0016 tc_fdpoo:678 fdelem alloc 00007fd72db6d2e0
11/10 17:05:26.9 0-0016 ddl_fram:238 Executing DDL: ALTER TABLE _tpr_snapshot ADD PARTITION P_20251111 VALUES LESS THAN (TO_DATE('2025-11-12', 'YYYY-MM-DD'))
11/10 17:05:26.9 0-0016 tc_fdpoo:678 fdelem alloc 00007fd72db6d3c0
11/10 17:05:26.9 0-0016 tx_sgmt.:2655 sgmt create: ts=4 sgmt=3571 type=1 extsz=16 blksz=8192
โฆ (omitted)
11/10 17:05:27.8 0-0016 shp_allo:988 slave alloc: idx=0, ext_size=2097152, total_size=29360128 shp alloc: total_size=29360128, max_size=96853920, root alloc: available size=121057280, used size=102760448