Background documentationshow Locate this document in the navigation structure

 

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 .

Prerequisites

You have the DBInfoRead server permission.

Structure

show <command>

Options

Option

Description

<command>

XCONS command to be executed

You can use all the XCONS commands that begin with show (see: show_list).

Result

OK

[CONTINUE]

<info_record>

<info_record>

Values for the Reply Fields

Value

Description

Continue

More results data is available

To display it, use the DBM command show_next.

<info_record>

Information

Example

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