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, 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 you do not specify a user with –uUTL, the Database Manager CLI uses the data of the first DBM operator.
If you do not specify a user with –UUTL, the Database Manager attempts to use the user data stored under the XUSER key c. We therefore recommend you create an XUSER entry with the key name c and the data of the first DBM operator (see: Utilities, Creating or Changing XUSER Entries).
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.
See also:
Utilities, XUSER
Database Administration Tutorial, Operating Modes in the Database Manager CLI
● 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>]
Options
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 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 –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 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 backup operation must be indicated with –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';'001
45004';'20060406';'00145004';'20060406';'00145004';'DEMODB';'GENUA';0;'NO';(null)
'DBADMIN';'';'DBADMIN';'SYSDBA';'MULTIPLE';(null);(null);(null);'DEFAULT';'20060
406';'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';'20060
413';'00133340';'20060413';'00133507';'20060413';'00133340';'DEMODB';'GENUA';29;'NO';(null)