You need a utility session on the database instance to execute a range of DBM commands.
If you enter this DBM option additionally when you log on to the Database Manager CLI, then a utility session is opened with the database instance.
If you additionally specify a database user's user data, then the utility session is opened with this data and the specified database instance. If you do not specify a user, the system uses the data of the first DBM operator (default value of the Database Manager).
When you end the Database Manager CLI, the utility session is also ended.
Note the different meanings of the command with uppercase and lowercase specification.
-uUTL: Specifying the database user with user name and password
-UUTL: Specifying a database user’s user key stored in the XUSER file
You use this DBM option to transfer the desired database user's data. The utility session is then opened with this user data for the specified database instance. If no operator is specified for -uUTL, the Database Manager CLI uses the data of the first DBM operator.
If you do not specify a user for -UUTL, the Database Manager attempts to use the user data stored under the XUSER key c. It is therefore advisable to create an XUSER entry with the key name c and the data of the first DBM operator (see: Utilities, Creating of Changing XUSER Entires)
The database user specified with the user name and password or with a user key must have been created for the database instance specified, otherwise the command fails.
When the utility session is opened, any database name stored under a specified XUSER key is ignored.
If you want to execute administration commands, you need the AccessUtility server authorization.
If you want to execute SQL statements, you need the AccessSQL server authorization.
-uUTL [<database_user>,<database_user_password>] | -UUTL [<user_key>]
Option |
Description |
---|---|
<database_user> |
Name of the database user |
<database_user_password> |
Password of the database user |
<user_key> |
User key |
Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB, open a utility session and start the backup operation using the backup template DemoDataCompl
Open the utility session with the operator data of the first DMB operator. You therefore enter the option for opening the utility session without parameters. The DBM command for starting the backup operation must be indicated with option –c:
>dbmcli -u OLEG,MONDAY -d DEMODB -uUTL -c backup_start DemoDataCompl
OK
Returncode 0
Date 20060418
Time 00131245
Server GENUA
Database DEMODB
Kernel Version Kernel 7.6.00 Build 016-123-109-428
...
...
Call the Database Manager CLI, log on as operator OLEG with the password MONDAY, connect to the database instance DEMODB, open a utility session and execute a SELECT statement to display the contents of the users table:
Open the utility session with the data stored under the user key c. You therefore enter the option for opening the utility session without parameters. The DBM command for starting the SELECT operation must be indicated with option -c:
>dbmcli -u OLEG,MONDAY -d DEMODB -UUTL -c db_execute SELECT * FROM users
OK
END
'DBM';'';'DBM';'ADMIN';'MULTIPLE';(null);(null);(null);'DEFAULT';'20060406';'00145004';'20060406';'00145004';'20060406';'00145004';'DEMODB';'GENUA';0;'NO';(null)
'DBADMIN';'';'DBADMIN';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20060406';'00145004';'20060406';'00145006';'20060406';'00145004';'DEMODB';'GENUA';10;'NO';(null)
'DBADMIN';'';'MONA';'DBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20060406';'00145012';'20060406';'00145012';'20060406';'00145012';'DEMODB';'GENUA';27;'NO';(null)
'DBADMIN';'';'DAVID';'RESOURCE';'MULTIPLE';(null);(null);(null);'DEFAULT';'20060413';'00133340';'20060413';'00133507';'20060413';'00133340';'DEMODB';'GENUA';29;'NO';(null)
Utilities, XUSER
Database Manager CLI Tutorial, Operating Modes in the Database Manager CLI