info 

Use

You display information about a database instance.

You specify what information you want to display using the info ID. The most important info IDs are described below. You can display a list of available info IDs by entering the info ID INFOS.

Prerequisites

●      You have the DBInfoRead server authorization.

●      You have opened a database session (see db_connect).

Syntax

info <info_ID>

Options

Option	Description
<info_ID>	ID of the information to be displayed The most important info IDs are: CACHES: Access to the cashes and hit rates DATA: Path, size and load of the data volumes LOG: Comprehensive information about the log area STATE: Information about the current state of the database instance. VERSIONS: Version of the database software INFOS: All available info IDs

Reply

OK

END|CONTINUE

<description_record>

<info_record>

<info_record>

Values for the Reply Fields

Field	Description
END	The complete result set was output.
Continue	More results data is available
<description_record>	Name of the fields of the subsequent information lines
<info_record>	Information

Example

Call the Database Manager CLI, log on as operator OLEG with password MONDAY, connect to the database instance DEMODB, display the version of the database software:

>dbmcli –u OLEG,MONDAY –d DEMODB info VERSIONS

OK

END

Name                | Value

 

Kernel              = Kernel    7.6.00   Build 016-123-109-428

Runtime Environment = W32/INTEL 7.6.00   Build 016-123-109-428