The command-line Information utility dbinfo displays information about a database catalog store. The information returned by dbinfo does not reflect the IQ store.
Any valid user ID can run dbinfo, but to obtain page usage statistics you need DBA authority.
dbinfo [ options ]
Table 3-6 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 |
The dbinfo 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.
Connection parameters (-c) Specify connection parameters. See Chapter 4, “Connection and Communication Parameters” in the System Administration Guide: Volume 1.
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.
