State of a service thread
This query shows the state of a service thread.
Column Name |
Description |
|---|---|
RUN_MODE |
the type of service thread. (dedicated or shared) |
STATE |
currenly working state (executing / pool) |
CNT |
the number of threads in the run_mode and state |
ALTIBASE HDB V4
ALTIBASE HDB V5
Lock & Transaction Information
This query shows the lock & transaction information including replication transactions.
Column Name |
Description |
|---|---|
TX_ID |
current transaction id |
BLOCKED_TX_ID |
the transaction id which current transaction is waiting for |
STATUS |
current transaction's status |
USER_NAME |
the user name who has issued the current transaction |
SESSION_ID |
the session id which has issued the current transaction |
CLIENT_IP |
client IP address |
AUTOCOMMIT |
autocommit |
LOCK_DESC |
Lock description |
FIRST_UPDATE_TIME |
the first update time of current transaction |
TABLE_NAME |
table_name |
CURRENT_QUERY |
current query in the current transaction |
DDL |
DDL or not |
LOGFILE# |
logfile number |
ALTIBASE HDB V4
ALTIBASE HDB V5
Redo log files
This query shows the information of transaction log files
Column Name |
Description |
|---|---|
OLDEST_LOG_FILE |
the oldest log file in LOG_DIR |
CURRENT_LOG_FILE |
the current log file number which service thread is writing to. |
LOG_FILE_GAP |
the interval between CURRENT_LOG_FILE and OLDEST_LOG_FILE |
Cumulative count of total transaction waits due to logging
This query shows the number of total waits due to lack of the log space exhaustion for logging. If the value returns non-zero value, you'd better increase PREPARE_LOG_FILE_COUNT in altibase.properties.
Memory Ager GAP
This query shows the memory ager thread's information.
Column Name |
Description |
|---|---|
GC_NAME |
the Ager name. (LOGICAL_AGER for index aging , DELTHRD for data aging) |
SCNOFTAIL |
The commit SCN of the tail in garbage collection OID list |
MINMEMSCNINTXS |
The lowest of the view SCNs for memory-related transactions |
GC_GAP |
the OID count which ager has to proceed |
Finding a query which blocks ager from aging.
Aging process will be blocked if there's a transaction which refers the aging target. This query shows the query which blocks from aging.
Column Name |
Description |
|---|---|
SESSION_ID |
the session identifier |
TOTAL_TIME |
total elapsed time |
EXECUTE_TIME |
the elapsed time for query execution |
TX_ID |
transaction identifier |
QUERY |
query string |
Memory status
This query shows the memory state arranged by ALTIBASE module.
Column Name |
Description |
|---|---|
NAME |
the name of ALTIBASE module |
ALLOC_MAX(M) |
max alloc size of memory |
ALLOC(M) |
current size of memory |
Total memory usage of ALTIBASE
This query shows the total memory state.
Column Name |
Description |
|---|---|
ALLOC_MAX(M) |
max alloc size of memory |
ALLOC(M) |
current size of memory |