The command-line Information utility dbinfo displays information about a database Catalog Store. The utility indicates when the database was created, the name of any transaction log file or log mirror that is maintained, the Catalog Store page size, the version of installed Java classes, and other information. Optionally, it can also provide Catalog table usage statistics and details. Note that if your database does not have a SYSCOLLATION table, the collation name is not returned.
The information returned by the dbinfo utility
is only about the Catalog Store and does not reflect the IQ Store.
dbinfo [ options ]
The following table lists the available options for the dbinfo utility.
Option |
Description |
|---|---|
-c "keyword=value; ..." |
Database connection parameters |
-o filename |
Log output messages to a file |
-q |
Operate quietly |
-u |
Output page usage statistics |
Connection parameters (-c) Specify connection parameters. See Chapter 4, “Connection and Communication Parameters” in the Sybase IQ System Administration Guide for a description of the 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.
Page usage statistics (-u) Display information about the usage and size of all Catalog Store tables, including system and user-defined tables.
You can only request page usage statistics if no other users are connected to the database.
