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

 

Connecting to the utility database

Connecting to the utility database allows you to execute database file administration statements, query connection and server properties, and connect to a running database server when it is not possible to connect to the database.

Prérequis

The -su database server option specifies the password for the utility database. To connect to a utility database on a server that was started using the -su option, you need the password that was set by the -su option.

If the -su database server option was not specified for a network server, then you cannot connect to the utility database.

If the -su database server option was not specified for a personal server, you can connect to the utility database and you do not need a password.

Contexte et remarques

You have a running database server and you want to connect to its utility database.

If the database server is a network server (dbsrv16), then it was started using the -su option and you have this password.

dbsrv16 -n server-name -su password

If the database server is a personal server (dbeng16), then either it was started using the -su option and the utility database has a password, or it was started without the -su option and the utility database has no password. 

dbeng16 -n server-name
 Task

  1. Start Interactive SQL or Sybase Central.

  2. In the Connect window, specify the following information.

    1. In the User ID field, type DBA.

    2. In the Password field:

      Option Action
      Personal server (dbeng16)

      If the -su option was not specified, then type any non-blank password. The password itself is not checked but the field must not be empty.

      If the -su option was specified, then type the set password.
      Network server (dbsrv16) Type the password specified by the -su option.

    3. In the Action dropdown list, click Connect To A Running Database On This Computer.

  3. In the Database Name field, type utility_db.

  4. In the Server Name field, type server-name.

  5. Click Connect.

Résultat

Interactive SQL connects to the utility database on the personal or network server.

When you are connected to the utility database, executing REVOKE CONNECT FROM DBA disables future connections to the utility database. No future connections can be made to the utility database unless you use a connection that existed before the REVOKE CONNECT was done, or restart the database server.

 See also
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0