<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. Note that if you specify <interval> but not <repeat>, the command is repeated indefinitely.

affinity <uktindex>

Assigns the user kernel thread with the index <uktindex> to a specific processor.

cancel <taskindex>

Cancels the command that is 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>

Only on Microsoft Windows: Permanently assigns a user kernel thread to a specific processor.

show active [dw | sv | us | gc | fs | tw | <task_type>]

Shows statistical information about active tasks

You can filter by task types: dw (Data Writer = Pager), sv (Server Task), us (User Task), gc (Garbage Collector), fs (Floating Service), tw (Tracewriter), and other task types.

For more information, see Glossary, Task.

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