Show TOC

How Database Manager CLI WorksLocate this document in the navigation structure

Use

Database Manager CLI is the client program of Database Manager. With this program you connect to the DBM server on the computer on which you want to create a new database or manage an existing database.

When you create a database, you define the very first user of the database. This user is called the first DBM operator.

Initially, only this operator can log on to the new database using Database Manager. During the configuration of a new database, you define the database system administrator.

Only the database system administrator and DBM operators can log on to Database Manager and execute DBM commands for managing the database for which they were created.

The first DBM operator and the database system administrator can log on to all database tools. They have the most comprehensive permissions for working with a database. They can use DBM commands and DBM options to create database users and, if required, more DBM operators for a database.

To be able to execute DBM commands, the respective user needs to have the necessary server permissions. The first DBM operator and the database system administrator have all server permissions.

To execute DBM commands, the current database has to be be in the ONLINE operational state. Exceptions to this rule are explicitly specified in the “Prerequisites” section of a DBM command description.

Calling up Database Manager CLI is equivalent to opening a session with Database Manager. Once the specified DBM command has been processed, the system closes the session with Database Manager. If you want to execute a series of DBM commands, you call Database Manager CLI in session mode.

The activities logged by Database Manager are written to the log files of Database Manager.

More Information

Database Administration, Managing Users, Log Files