Displaying Information About Installed Software and Database Instances 

Use

You can use DBM commands to display information about the installed versions of the database software, installation paths as well as the registered database instances on a particular computer.

To read the prerequisites, see Database Manager CLI, dbm_version, dbm_getpath, db_enum, info

Procedure

Display the version number of the Database Manager

>dbmcli dbm_version VERSION

OK

7.6.00

Display the installation directory of the version-dependent database software (dependent path)

>dbmcli dbm_version INSTROOT

OK

c:\program files\sdb\DEMODB

Display installation directories of the version-independent database software

●     Display the independent program path:

>dbmcli dbm_getpath IndepProgramPath

OK

c:\program files\sdb\programs

●     Display the independent data path:

>dbmcli dbm_getpath IndepDataPath

OK

c:\documents and settings\all users\application data\sdb\data

Display registered database instances and their software versions

>dbmcli db_enum

OK

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

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

TESTDB  C:\Program Files\sdb\TESTDB        7.6.00.16       slow    offline

TESTDB  C:\Program Files\sdb\TESTDB        7.6.00.16       fast    running

Display the software version of the current database instance

>dbmcli –u DBM,DBM –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