-uUTL: Opening a Utility Session 
Several DBM commands require a utility session before they can be executed.
If you enter this DBM option additionally when logging on to Database Manager CLI, then a utility session is opened with the database specified.
If you additionally specify a database user's data, then the utility session is opened with this data. If you do not specify a user, the system uses the data of the first DBM operator (system default).
When you exit Database Manager CLI, the utility session is also ended.
Note the different meanings of the command with uppercase and lowercase spelling:
Use -uUTL to specify the user name and password of the database user.
Use -UUTL to specify the user key stored in the XUSER file of the database user.
When the utility session is opened, any database name stored under the specified XUSER key is ignored.
If you do not specify a user key with the -UUTL option, 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)
Prerequisites
The database user specified with the user name and password, or with a user key, has been created for the database specified under the DBM option -d.
If you want to execute administration commands, you need the AccessUtility server permission.
If you want to execute SQL statements, you need the AccessSQL server permission.
Structure
-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 |
Example
Using -uUTL
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database DEMODB, open a utility session, and start the backup operation using the backup template DemoDataCompl.
Open the utility session with the data of the first DBM operator. Thus, enter the option for opening the utility session without parameters. Mark the DBM command for starting the backup operation with the 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
...
...
Using -UUTL
Call Database Manager CLI, log on as the operator OLEG with the password MONDAY, connect to the database 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. Thus, enter the option for opening the utility session without parameters. Mark the DBM command for starting the SELECT operation with the 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)
More Information
Utilities, XUSER