Document Type | Technical Information
Category | Monitoring/Inspection
Document Number | TMOTI030
Overview
This guide explains how to configure TIBERO to automatically perform a callstack dump when a specific error number occurs.
Method
Automatic Callstack Dump Configuration
To configure the system so that a Callstack Dump is automatically generated when a specific error occurs, execute the following command.
alter system dump callstack on error -number on;
After executing the command, a Callstack Dump will be automatically generated when the specified error occurs.
It is also possible to generate sqlmemlog along with the Callstack Dump.
Disabling Callstack Dump Configuration
After confirming the automatic Callstack Dump setting, execute the following disable command to deactivate it.
ALTER SYSTEM DUMP CALLSTACK ON ERROR <error_number> OFF;
Callstack Dump Test Example
The test scenario for Tibero 5 SP1 (DB 5.0 FS01) version is as follows.
CREATE TABLE TEST_TABLE (C1 NUMBER PRIMARY KEY, C2 VARCHAR(10), C3 VARCHAR(10)) /
INSERT INTO TEST_TABLE VALUES (1, 'ABC', 'DEF')
/
INSERT INTO TEST_TABLE VALUES (2, 'ABC', 'DEF')
/
COMMIT
/
ALTER SYSTEM SET SQL_LOG_ON_MEMORY=Y
/
ALTER SYSTEM DUMP CALLSTACK ON ERROR -10007 ON
/
INSERT INTO TEST_TABLE VALUES (1, 'TEST', 'DATA');
/
TBR-10007: UNIQUE constraint violation ('POSTUSR'.'POSTUSR_CON170600127'). occurred
- Confirm memlog creation
TiberoVM@tibero5:/home/tibero5/tibero5/instance/t5/log/memlog # ll -rlt
total 48
-rw-r--r-- 1 tibero5 dba 38179 Jun 19 00:03 sql_memlog.18404.18.0
drwxr-xr-x 7 tibero5 dba 4096 Jun 19 00:03 ..
- tbsvr.callstack created
TiberoVM@tibero5:/home/tibero5/tibero5/instance/t5 # ll -rlt
total 36
drwxr-xr-x 3 tibero5 dba 4096 Jun 3 19:37 ..
drwxr-xr-x 2 tibero5 dba 4096 Jun 3 19:37 audit
-rw------- 1 tibero5 dba 0 Jun 11 00:58 lsnr.out.5717
-rw------- 1 tibero5 dba 0 Jun 19 00:00 lsnr.out.18403
-rw------- 1 tibero5 dba 0 Jun 19 00:00 tbsvr.out.18404
drwxr-xr-x 2 tibero5 dba 4096 Jun 19 00:00 path
-rw-r--r-- 1 tibero5 dba 315 Jun 19 00:00 .proc.list
drwxr-xr-x 3 tibero5 dba 4096 Jun 19 00:03 dump
drwxr-xr-x 6 tibero5 dba 4096 Jun 19 00:03 .
-rw-r--r-- 1 tibero5 dba 6363 Jun 19 00:03 tbsvr.callstack.18416
drwxr-xr-x 7 tibero5 dba 4096 Jun 19 00:03 log