-uUTL: Opening a Utility Session

Use

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

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.

Syntax

-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 for -uUTL

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

...

...

Example for -uUUTL

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)