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

XCONS: Commands

Command

Description

affinity <uktindex>

Caution Caution

This command was designed for development and testing purposes only. Do not use it in production operation, but only when requested to do so by the support team.

End of the caution.

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>

Caution Caution

This command was designed for development and testing purposes only. Do not use it in production operation, but only when requested to do so by the support team.

End of the caution.

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

Example

To display all active tasks of the DEMODB database on Microsoft Windows and then refresh the information 10 times in intervals of 1 second, enter the following command:

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