Statistics Report

Generating a statistics report is a good way to determine whether a file can be logged by the database engine's transaction durability feature. The report shows whether the file has system data and if a key is unique. (A unique key lacks the "D" flag, which indicates that duplicates are allowed.) The statistics report provides metadata about the file. This information can be used when you troubleshoot problems or to help you create similar files.

Statistics Report Tasks

You perform the following tasks pertaining to owner names:

Create a statistics report (page 13-26)

To create a statistics report for an existing data file

Click Options 4 Create Stat Report from the menu on the main window. The Maintenance utility displays the Statistics Report dialog box.

Figure 13-9 Statistics Report Dialog Box

Specify a data file to use and a report file name. If you want to view the report when it is created, select the View Report check box.

If you choose to view the report, the Maintenance utility displays the View File window shown next.

Figure 13-10 Statistics Report Example

The informational headings in a status report correspond to the controls in the File Information Editor, which is described in File Information Editor .

The legend at the bottom of the statistics report explains the symbols used in the key/segment portion of the report. This information includes items such as the number of keys and key segments, the position of the key in the file, and the length of the key:

Legend:

< = Descending Order D = Duplicates Allowed I = Case Insensitive M = Modifiable R = Repeat Duplicate A = Any Segment (Manual) L = All Segments (Null) * = The values in this column are hexadecimal. ?? = Unknown -- = Not Specified