User's Guide

Part VI. SQL Anywhere Reference

Chapter 39. SQL Anywhere Components

With the Information utility you can display information about a database file or write file. The database you wish to examine 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 ISQL Database Tools window.
• From the ISQL DBTOOL statement.
• From the system command line, using the DBINFO command-line utility.

Obtaining database information in the ISQL Database Tools window

To use the Information utility from the ISQL Database Tools window:

1. Select Database Tools from the Window menu.
2. Click Database Information on the Tools list.
3. Enter the database filename (with path).
4. Click Display to show information about the database.
5. Click Page Usage to show information on database pages.

Obtaining database information using the DBTOOL statement

Syntax

The syntax for the Information utility from the ISQL DBTOOL statement is as follows:

     DBTOOL DBINFO DATABASE database-file TO output-file

         ...    [ [ WITH ] PAGE USAGE ]

         ...    USING connection-string

A database or write filename, with path, must be supplied. The database you wish to examine should not be running when you run the Information utility.

Example

The following statement gets information about the sample database and puts it in the file C:\TEMP.TXT.

     DBTOOL DBINFO DATABASE 'c:\sqlany50\sademo.db'

     TO 'c:\temp.txt'

     WITH PAGE USAGE

     USING 'uid=dba;pwd=sql'

The DBINFO command-line utility

Syntax

     dbinfo[switches] filename

Windows 3.x syntax

     dbinfow[switches] filename

Switch	Description
-ofilename	Output messages to file
-q	Suppress any messages
-u	Output page usage statistics

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

Information utility options

Database file name A database or write file name, with path, must be supplied. The database you wish to examine should not be running when you run the Information utility.

Output log messages to 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 only available from the command-line utility.

Page usage statistics Information about the usage and size of all tables, including system and user-defined tables, is available as an option by using the -u command-line switch.