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.
You do not need to log on to Database Manager to execute this DBM command.
You do not require a server permission either.
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 |
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 |
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