x_cons <database_name> <command> [<interval> [<repeat>]]
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. |
time <enable | disable> |
Activates the internal time measurement function. Note that this can reduce the performance of your system. |
cancel <taskindex> |
Cancels the command that is currently being executed by the task with the index taskindex |
pagecache_release |
Releases the page cache |
diagnose_pagecache |
Analyzes the page cache. The results are written to the log file knldiag. |
kill <taskindex> |
Closes the session of the task with the index taskindex |
affinity <uktindex> |
Note that this command was designed for development tasks and for this reason should not be used in production operation. Only use this command if requested to do so by Support. This command allows the user kernel thread with the index uktindex to be assigned to one processor. |
procmask <procmask> |
Note that this command was designed for development tasks and for this reason should not be used in production operation. Only use this command if requested to do so by Support. On Microsoft Windows only. User kernel threads are permanently assigned to individual processors. |
trace_flush |
Flushes the trace file |
show io |
Shows volume access statistics |
show aio |
Only for backups; shows volume access statistics |
show storage |
Shows the memory utilization. On Microsoft Windows, the task stack is also displayed. |
show tasks |
Shows statistics for all tasks |
show active [dw | sv | us | gc] |
Shows statistics for active tasks. You can also show the statistics just for specific task groups: DW (data writer=pager), SV (server task), US (user task), GC (garbage collector). |
show runnable [dw | sv | us | gc] |
Shows information about runnable tasks; you can also use this command just for specific task groups |
show moveinfo |
Only for load balancing; shows history and how tasks are currently moving between user kernel threads |
show t_cnt [dw | sv | us | gc | <taskindex>] |
Shows detailed information about all tasks in a specific task group or for the task with the index taskindex |
show t_queue |
Shows task queues |
show t_reg |
Shows semaphores (use of critical regions by the tasks) |
show t_stat |
Shows task statistics |
show t_move |
Only for load balancing; indicates whether tasks can currently be moved from one user kernel thread to another |
show versions |
Shows the version of the database kernel and the runtime environment |
show regions |
Shows information about the critical regions |
show state |
Shows the operational state of the database instance |
show rte |
Shows information about the runtime environment (threads, and so on) |
show queues |
Shows queues |
show suspends |
Shows the reasons why tasks that are currently suspended have been suspended |
show sleep |
Shows statistics that indicate how long the individual user kernel threads were suspended |
show thrd_times |
For Microsoft Windows only. Shows how much processor time the threads have used |
show all |
Shows all available information and statistics |
Displaying all the active tasks of the database instance HOTELDB and repeating this ten times at intervals of one second:
x_cons HOTELDB show active 1 10
Displaying the help
for all XCONS commands:
x_cons HOTELDB help
See also:
· Database Manager CLI, Displaying Information About the Database Instance
·
Calling XCONS in
the Database Wizard in an SAP system:
Database
Administration in the CCMS: MySQL MaxDB, Database
Console
Database
Administration in the CCMS: SAP liveCache,
Console