Reference Manual
   CHAPTER 4. Database Administration Utilities     

The Information utility

With the Information utility, you can display information about a database file or write file. The database should not be running when you run the Information utility. 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.

You can access the Information utility in the following ways:

• From the system command line, using the dbinfo command-line utility.

  The DBINFO command-line utility

Syntax 

dbinfo [switches] filename

Windows 3.x
syntax 

dbinfow [switches] filename

Switch	Description
-c "keyword=value; ..."	Database connection parameters
-o filename	Output log messages to a file
-q	Suppress any messages
-u	Output page usage statistics

Description 

The DBINFO command-line utility allows you to display information about a database file or write file. It 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.

     For more information about the command-line switches, see Information utility options.

  Information utility options

Connection parameters (-c)     Specify connection parameters. See Connection parameters 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.

Output log messages to a file (-o )     Redirect log messages to the named file.

Operate quietly (-q )     Do not display the information. The return code may still provide useful information (see Software component Return codes). This option is available only from the command-line utility.

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.