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.
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.
Context and remarks
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
Start Interactive SQL or Sybase Central.
In the Connect window, specify the following information.
In the User ID field, type DBA.
In the Password field:
|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.|
In the Action dropdown list, click Connect To A Running Database On This Computer.
In the Database Name field, type utility_db.
In the Server Name field, type server-name.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|