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 27
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 28
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