Procedure documentationDisplaying Information about the Database Locate this document in the navigation structure

 

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:

Prerequisites

XCONS is installed on the database computer.

Procedure

Syntax

x_cons <database_name> <command> [<interval> [<repeat>]]

XCONS: Options

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.

XCONS: Commands

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

Example

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)

[...]

More Information

Concepts of the Database System, Operating System Functions and Resources Used by Databases