Function documentationCalling Database Manager CLI Locate this document in the navigation structure

 

Database Manager CLI is part of the SAP MaxDB Software installation package. On Windows you find dbmcli.exe in the pgm directory of an installation. On Unix and Linux you find dbmcli.exe in the bin directory of an installation.

To call Database Manager CLI, open a command prompt and change into the respective directory. Make sure that you navigate to the executable of that installation you want to administer.

When you call Database Manager CLI, you can enter DBM options and a maximum of one DBM command.

You can enter additional parameters for DBM options. The parameters are explained in the description of the respective DBM option.

If you use DBM options with parameters, mark the beginning of the subsequent DBM command with the option –c (see: -c: Indicating as DBM command). By doing so, you prevent the Database Manager program from interpreting the beginning of the DBM command as a parameter of the previous DBM option.

You can also enter additional command options for the DBM command. These command options are explained in the description of the respective DBM command.

You can call Database Manager in three different operating modes (See: Operating Modes in Database Manager CLI).

Input help is provided for long DBM commands.

For information about the format of the return values for DBM commands, see Reply Format.

Syntax

>dbmcli [<dbm_options>] [<dbm_command> [command_options]]

Example

Entering DBM Options with Parameters and a DBM Command

Log on to Database Manager CLI as the operator OLEG with the password MONDAY, connect to the database DEMODB on the remote computer PARMA, and display the operational state of the database:

>dbmcli -u OLEG,MONDAY -d DEMODB -n PARMA db_state

OK

State

ONLINE

Entering a DBM Option without Parameters and a DBM Command

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB on the local computer and start the backup operation using the backup template DemoDataCompl.

Open the utility session with the operator data of the first DMB operator. For that purpose, enter the option for opening the utility session without parameters. Mark the beginning of the DBM command for starting the backup operation with –c:

>dbmcli -u OLEG,MONDAY -d DEMODB -uUTL -c backup_start DemoDataCompl

OK

Returncode 0

Date 20060418

Time 00131245

Server GENUA

Database DE

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