Show TOC

db_enumLocate this document in the navigation structure

Use

Use this command to display a list of all the databases registered on the database computer.

The display is in tabular form. The individual columns are separated by tabs.

Prerequisites

You do not need to log on to Database Manager to execute this DBM command.

You do not require a server permission either.

Structure

db_enum [<option>] [INSTANCE] [PATH] [VERSION] [SPEED] [STATE]

<option> :: = ALL | SYSTEM | INSTANCENAME <instance_name>

Option

Description

ALL

Displays all databases (also the system-internal databases are listed)

SYSTEM

Only displays the system-internal databases

INSTANCENAME <instance_name>

Only displays the databases of this instance

INSTANCE

Displays the instance which contains the database

PATH

Displays the directory that contains the database version-dependent server software

VERSION

Displays the version of the database software

SPEED

Displays the different kernel variants

STATE

Displays the operational state of the database

Result

OK

<database_name><TAB><dependent_path><TAB><database_version><TAB><kernel_version><TAB><operational_state>

<database_name><TAB><dependent_path><TAB><database_version><TAB><kernel_version><TAB><operational_state>

...

Value

Description

<database_name>

Name of the database

<dependent_path>

Directory, which contains the database version-dependent server software

<database_version>

Version of the database software

<kernel_version>

Kernel variant

<operational_state>

Operational state of the database

Example

Call Database Manager CLI, display the list of all databases registered on the computer GENUA:

> dbmcli -n GENUA db_enum

OK

DEMODB C:\Program Files\sdb\DEMODB 7.6.00.10 fast running

DEMODB C:\Program Files\sdb\DEMODB 7.6.00.10 slow offline