The Information utility
96
The Information utility
With the Information utility, you can display information about a database.
The utility indicates when the database was created, the name of any
transaction log file or log mirror that is maintained, the page size, and other
information. Optionally, it can also provide table usage statistics and details.
The Information is available as the
dbinfo
command-line utility.
The dbinfo command-line utility
dbinfo [
switches
]
Switch 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
command-line utility allows you to display 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, and other information.
Optionally, it can also provide table usage statistics and details.
$ For more information about the command-line switches, see
"Information utility options" on page 96.
Information utility options
Connection parameters (–c) Specify connection parameters. See
"Connection parameters" on page 64 of the book ASA User’s 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. This option is
available only from the command-line utility.
Syntax
Description
To Next Page
Loading...