With this command you can display information about the database, including statistics, the operational state, tasks, and so on. For this purpose, the DBM command obtains and outputs information of the XCONS program .
You have the DBInfoRead server permission.
show <command>
Option |
Description |
---|---|
<command> |
XCONS command to be executed You can use all the XCONS commands that begin with show (see: show_list). |
OK
[CONTINUE]
<info_record>
<info_record>
Value |
Description |
---|---|
Continue |
More results data is available To display it, use the DBM command show_next. |
<info_record> |
Information |
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, and display the statistics about the access to the database volumes:
>dbmcli -u OLEG,MONDAY -d DEMODB show io
OK
SERVERDB: DEMODB
Volume Devs. Read(s) Write(s) Total
Name No. Count Count Count
knltrace 0 0 1 1
C:\Documents and Set...DEMODB\data\DISKD0001 1 54 59 113
C:\Documents and Set....DEMODB\log\DISKL0001 3 14 14 28
C:\Documents and Set....DEMODB\data\DISKD0003 4 1 9 10
total I/O: 69 83 152
Utilities, XCONS Options for Displaying Information about the Database