Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » SQL Anywhere database connections » Database file types


The utility database

The utility database is a phantom database with no physical representation. The utility database has no database file, and therefore it cannot contain data. This feature allows you to:

  • Execute database file administration statements such as CREATE DATABASE without first connecting to an existing physical database.

  • Retrieve values of connection properties and server properties using the utility database.

  • Connect to a running database server when it is not possible to connect to the database. For example, in a mirroring system, you can connect to the utility database to stop a mirroring server or force a database to become the primary server.

The utility database is named utility_db. If you attempt to create or start a database with this name, the operation fails.

The utility database has one user named DBA. The password for the DBA user is set using the -su database server option. You can use the -su database server option to set the utility database password for the DBA user, or to disable connections to the utility database. If the -su option is not specified when starting the utility database, then the user ID and password requirements are different for the personal server and the network server.

You can start the utility database on a database server by specifying utility_db as the database name when connecting to the server.

 Allowed statements for the utility database
 The util_db.ini file and network database servers (deprecated)
 See also

Connecting to the utility database