ASA Database Administration Guide
Database Administration Utilities
dbinfo [ options ]
| Option | Description |
|---|---|
| –c "keyword=value; ..." | Database connection parameters |
| –o filename | Log output messages to a file |
| –q | Operate quietly |
| –u | Output page usage statistics |
The dbinfo utility displays information about a database. It reports the time when the database was created, the name of any transaction log file or log mirror, the page size, the version of installed Java classes, the collation name and label, and other information. Optionally, it can also provide table usage statistics and details. Note that if your database does not have a SYSCOLLATION table, the collation name is not returned.
Exit codes are 0 (success) or non-zero (failure).
For more information about the options, see Information utility options.
This utility accepts @filename parameters.
For more information, see @filename server option.
Connection parameters (–c) Specify connection parameters.
For a description of the connection parameters, see Connection parameters.
Any valid user ID can run the Information utility, but to obtain page usage statistics you need DBA authority.
Log output messages to file (–o) Write output messages to the named file.
Operate quietly (–q) Do not display output messages. This option is available only when you run this utility from a command prompt.
Page usage statistics (–u) Display information about the usage and size of all tables, including system and user-defined tables.
You can only request page usage statistics if no other users are connected to the database.
SQL Anywhere Studio 9.0.1
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.