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

SQL Anywhere 11.0.1 (Français) » SQL Anywhere Server - Database Administration » Administering Your Database » Database administration utilities


SQL Anywhere Console utility (dbconsole)

Provides administration and monitoring facilities for database server connections.

dbconsole [ options ]
Option Description

Use this option to read in options from the specified environment variable or configuration file. See Using configuration files.

If you want to protect passwords or other information in the configuration file, you can use the File Hiding utility to obfuscate the contents of the configuration file. See File Hiding utility (dbfhide).

-c "keyword=value; ..."

Specify connection parameters. See Connection parameters.

-datasource DSN-name Specify an ODBC data source to connect to. You do not need to be using the iAnywhere JDBC driver to use this option.
-host hostname Specify the hostname or IP address of the computer on which the database server is running. You can use the name localhost to represent the current computer.
-port port-number Specify the port number on which the database server is running. The default port number for SQL Anywhere is 2638.

The SQL Anywhere Console allows you to monitor the server from a client computer. This utility is also called the Network Server Monitor. You can use it to track who is logged on to a database server elsewhere on your network. You can also display both server and client statistics on your local client screen, disconnect users, and configure the database server. The SQL Anywhere Console can display information for multiple connections.

♦  To disconnect a user from a database
  1. Connect to the database from the SQL Anywhere Console.

  2. In the User ID column, right-click the user and choose Disconnect.

    You can configure the columns that appear in the SQL Anywhere Console in the Options window, which can be accessed by choosing File » Options. See Using the SQL Anywhere Console utility.

The SQL Anywhere Console is available on all supported platforms except Windows Mobile, AIX, HP-UX, and HP-UX Itanium. On these platforms, you can use the connection-level, server-level, and database-level properties to obtain information or you can monitor your server from a computer running an operating system that supports the SQL Anywhere Console (such as Windows, Mac OS X, or Linux).

For more information about obtaining property values, see Connection, database, and database server properties.