Function documentationDBM Options Locate this document in the navigation structure

 

When you call Database Manager CLI, you can enter various DBM options and exactly one DBM command.

You can enter parameters for many of the DBM options. If you do not specify a parameter, the default values are used.

If you enter DBM options with parameters, mark the beginning of the subsequent DBM command with the DBM option -c. In this way you prevent Database Manager from interpreting the subsequent DBM command as a parameter of the previously entered DBM option.

Features

You can use the following DBM options:

Option

Description

-c

Indicating as DBM command

-d

Name of the database instance

-e

Activating Encryption

-i | -ic | -is | -ics

Name of the input script

-n

Name of the database computer

-o

Name of the Output File

-R

Installation directory of the database instance

-t

Name of the Log File

-uSQL

Opening an SQL Session

-uSRV

Opening a Service Session

-uUTL

Opening a Utility Session

-ud

Deleting XUSER Entries

-uk

User key

-us

Creating or Changing XUSER Entries

-ux

Logging on to the XUSER program

-ul

Displaying XUSER Data

Example

Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the DEMODB database, and display the content of the users database system table without explicitly specifying a database user.

(Mark the beginning of the DBM command with the option -c. The system default, that is the data of the database system administrator, is used for the database user):

>dbmcli -u OLEG,MONDAY -d DEMODB -uSQL -c db_execute SELECT * FROM users

OK

END

'OLEG';'';'OLEG';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'00104503';'20050602';'00104503';'20050602';'00104503';'DEMODB';'p59963.dhcp.ber.sap.corp';0;'NO';(null)

'DBADMIN';'';'DBSERVICE';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'00104508';'20050602';'00104508';'20050602';'00104508';'DEMODB';'p59963.dhcp.ber.sap.corp';6;'YES';(null)

'DBADMIN';'';'DBADMIN';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'00104503';'20050602';'00104506';'20050602';'00104503';'DEMODB';'p59963.dhcp.ber.sap.corp';10;'NO';(null)

'DBADMIN';'';'MONA';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20050602';'00104523';'20050602';'00104523';'20050602';'00104523';'DEMODB';'p59963.dhcp.ber.sap.corp';24;'NO';(null)