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
The following task lists the steps to create a statistics report.
►
To create a statistics report for an existing data file
1
Click Options > Create Stat Report from the menu on the main window. The Maintenance utility displays the Statistics Report dialog box.
Figure 26 Statistics Report Dialog Box
2
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 27 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