Background documentation-uUTL: Opening a Utility Session Locate this document in the navigation structure

 

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.

Prerequisites

  • 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.

Structure

-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

Example

Using -uUTL

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

...

...

Using -UUTL

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)

More Information

Utilities, XUSER

Database Manager CLI Tutorial, Operating Modes in the Database Manager CLI