Database Instance Information Request 
Database Instance Information Request
Use
You request database instance information, for example about statistics, the mode, or tasks. The
show command obtains and outputs information from program x_cons.Prerequisites
You have the DBM operator authorization
DBInfoRead.Syntax
show <command>
Possible values for <command>
|
IO |
Input/output activities in regular database operation |
|
AIO |
Input/output activities for data backup |
|
STORAGE |
Configuration and current status of the various storage areas |
|
TASKS |
List of tasks |
|
ACTIVE [DW|SV|US] |
Active tasks for [Datawriter-Task|Server-Task|User-Task] |
|
RUNNABLE [DW|SV|US] |
Runnable tasks (waiting for CPU) |
|
T_C [DW|SV|US|Tx] |
Task-specific information on [Datawriter_Task | Server Task | User Task | Task No.x} |
|
VERSIONS |
Current variant of database kernel and runtime environment |
|
REGIONS |
Information about the critical regions used in the kernel |
|
STATE |
Mode of database instance |
|
RTE |
Runtime environment |
|
QUEUES |
Queues of runnable tasks (waiting for CPU) |
|
SUSPENDS |
Information about suspend states anywhere in the overall system |
|
SLEEP |
The CPU load from user kernel threads measured by the database kernel. |
|
THRD_TIMES |
Information from the system about the CPU load from user kernel threads (Windows NT operating system only) |
|
ALL |
All of the information provided by the database console |
Reply
OK<NL>
[CONTINUE]<NL>
<info_record><NL>
<info_record><NL>
|
Continue |
More result data ready |
|
<info_record> |
Information |