SQL Anywhere Console utility (dbconsole)

dbconsole [ options ]

Option	Description
@data	Reads in options from the specified environment variable or configuration file. See Configuration files. 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; ..."	Specifies connection parameters. See Connection parameters.
-datasource DSN-name	Specifies an ODBC data source to connect to. You do not need to be using the SQL Anywhere JDBC driver to use this option.
-host hostname	Specifies 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	Specifies the port number on which the database server is running. The default port number for SQL Anywhere is 2638.

None.

The SQL Anywhere Console utility 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 database 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.

The SQL Anywhere Console is available on all supported platforms except Windows Mobile, IBM 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.

SQL Anywhere Console utility (dbconsole)

The following command connects to the default database using the user ID DBA and password sql:

dbconsole -c "UID=DBA;PWD=sql"

SQL Anywhere Console utility (dbconsole)

Syntax

Privileges

Remarks

See also

Example