The following sections describe how you can call up XCONS directly on the command line.
However, we recommend that you do not call XCONS directly from the command line but use Database Manager CLI or CCMS instead. In this way, you avoid problems with access rights on Unix and Linux.
More information:
Database Manager CLI, show
Database Administration in CCMS, Database Console
XCONS is installed on the database computer.
x_cons <database_name> <command> [<interval> [<repeat>]]
Option |
Description |
---|---|
<command> |
XCONS command |
<interval> |
Time between repetitions of the same command. If you do not specify <interval>, the command is only executed once. |
<repeat> |
Number of times the command is repeated. If you specify <interval> but not <repeat>, the command is repeated indefinitely. |
Command |
Description |
---|---|
affinity <uktindex> |
Note that this command was designed for development purposes. Do not use it in production operation, but only when requested to do so by the support team. This command allows the user kernel thread with index <uktindex> to be assigned to a specific processor. |
cancel <taskindex> |
Cancels the command currently being executed by the task with the index <taskindex> |
diagnose_pagecache |
Analyzes the page cache The system writes the results to the kernel log file. More information: Database Administration, Log Files |
kill <taskindex> |
Closes the session of the task with the index <taskindex> |
pagecache_release |
Releases the page cache |
procmask <procmask> |
Note that this command was designed for development purposes. Do not use it in production operation, but only when requested to do so by the support team. Only on Microsoft Windows: User kernel threads are permanently assigned to specific processors. |
show active [dw | sv | us | gc] |
Statistics for active tasks You also have the option of only displaying statistics for certain task groups: DW (Data Writer = Pager), SV (Server Task), US (User Task), GC (Garbage Collector). |
show aio |
Only for backups; volume access statistics |
show all |
All available information and statistics |
show io |
Volume access statistics |
show moveinfo |
Only for load balancing; History and how tasks are currently moving between user kernel threads |
show queues |
Queues |
show regions |
Information about the critical regions |
show rte |
Information about the runtime environment (threads, and so on) |
show runnable [dw | sv | us | gc] |
Information about runnable tasks; can also be used for specific task groups only |
show sleep |
Statistics that indicate how long the individual user kernel threads were suspended |
show state |
Operational state of the database In addition to the operational states, intermediate statuses are also displayed here. These are short-term statuses occupied by the database when it is transferred from one operational state to another, for example: STARTING, SHUTDOWN, SHUTDOWNREINIT, SHUTDOWNKILL, STOP, KILL, ABORT, UNKNOWN |
show storage |
Memory usage On Microsoft Windows, the task stack is also displayed. |
show suspends |
Reasons why tasks that are currently suspended have been suspended |
show t_cnt [dw | sv | us | gc | <taskindex>] |
Displays detailed information about all tasks in a specific task group or about the task with the index <taskindex> |
show t_move |
Only for load balancing; indicates whether tasks can currently be moved from one user kernel thread to another |
show t_queue |
Task queues |
show t_reg |
Shows semaphores (use of critical regions by the tasks) |
show t_stat |
Task statistics |
show tasks |
Statistics for all tasks |
show thrd_times |
On Microsoft Windows only. Processor time used by threads |
show versions |
Database kernel and the runtime environment versions |
time <enable | disable> |
Activates the internal time measurement function Note that this can compromise the performance of your system. |
trace_flush |
Flushes the trace file |
On Microsoft Windows, you display all active tasks of the DEMODB database. The system repeats the command 10 times at intervals of 1 second:
x_cons DEMODB show active 1 10
SERVERDB: DEMODB
ID UKT Win TASK APPL Current Timeout Region Wait tid type pid state priority cnt try item
ID UKT Win TASK APPL Current Timeout Region Wait tid type pid state priority cnt try item T2 2 0xF20 Logwr Vvectorio 0 1 35370(r) T17 7 0xB1C User 2984 LogIOwait(234) 0 0 70643(s)
[...]
Concepts of the Database System, Operating System Functions and Resources Used by Databases