The utility database is a phantom database with no physical representation. This feature allows you to execute database file administration statements such as CREATE DATABASE without first connecting to an existing physical database. The utility database has no database file, and therefore it cannot contain data.
The utility database is named utility_db. If you attempt to create or start a database with this name, the operation fails.
Executing the following statement after connecting to the utility database creates a database named new.db in the directory c:\temp.
CREATE DATABASE 'c:\\temp\\new.db';
You can also retrieve values of connection properties and server properties using the utility database.
For example, executing the following statement on the utility database returns the default collation sequence that is used when creating a database:
SELECT PROPERTY( 'DefaultCollation' );
For information about connection and database server properties, see:
In a mirroring system sometimes you cannot connect to a database even though the database server is running. In these cases, you can connect to the utility database to shut down the server or to force a database to become the primary server. See Stopping a database server in a mirroring system and Forcing a database server to become the primary server.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|