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

SQL Anywhere 11.0.0 » SQL Anywhere Server - Database Administration » Administering Your Database » Database administration utilities

 

Information utility (dbinfo)

Displays information about the specified database.

Syntax
dbinfo [ options ]
Option Description
@data

Reads 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; ..."

Specifies connection parameters. See Connection parameters.

Any valid user ID can run the Information utility, but to obtain page usage statistics you need DBA authority.

-o filename Writes output messages to the named file.
-q Runs in quiet mode—messages are not displayed.
-u

Displays information about the usage and size of all tables, including system and user-defined tables, as well as materialized views.

You can only request page usage statistics if no other users are connected to the database and you have DBA authority. The page usage information is obtained using the sa_table_page_usage system procedure.

Remarks

The dbinfo utility displays information about a database. It reports the name of the database file, the name of any transaction log file or log mirror, the page size, the collation name and label, whether table encryption is enabled, and other information. Optionally, it can also provide table usage statistics and details.

Exit codes are 0 (success) or non-zero (failure).

For more information about exit codes, see Software component exit codes.