Displaying Data Source Statistics

How to:

Reference:

The ? FILE command displays information, such as the number of segment instances in a FOCUS data source and when the data source was last changed.

Syntax: How to Display Data Source Statistics

? FILE filename

where:

filename

Is the name of the data source.

Example: Displaying Data Source Statistics

Issuing the command

? FILE EMPLOYEE

produces statistics similar to the following:

    STATUS OF FOCUS FILE: D:\ibi\apps\...\employee.foc ON 07/14/2000 AT 14.59.14 ACTIVE DELETED DATE OF TIME OF LAST TRANS SEGNAME COUNT COUNT LAST CHG LAST CHG NUMBER EMPINFO 12 06/14/2000 11.04.01 FUNDTRAN 6 03/31/2000 11.16.15 6 PAYINFO 19 06/05/2000 16.07.49 ADDRESS 21 03/31/2000 11.16.15 21 SALINFO 70 03/31/2000 11.16.16 448 DEDUCT 448 03/31/2000 11.16.16 448 TOTAL SEGS 576 TOTAL CHARS 8984 TOTAL PAGES 8 LAST CHANGE 06/14/2000 11.01.01 

Reference: ? FILE Query Information

The following data source statistics are listed:

SEGNAME

Is the name of each segment in the data source. After the segments, the indexes are listed, if applicable.

Indexes are those fields specified by the attribute FIELDTYPE=I in the Master File.

ACTIVE COUNT

Is the number of instances of each segment.

DELETED COUNT

Is the number of segment instances deleted, for which the space is not reused.

DATE OF LAST CHG

Is the date on which data in a segment instance or index was last changed.

TIME OF LAST CHG

Is the time of day, on a 24-hour clock, when the last update of a file was made for that segment or index.

LAST TRANS NUMBER

Is the number of transactions performed by the last update request to access the segment. If the data source was changed under Simultaneous Usage mode, this column refers to the REF NUMB column of the CR HLIPRINT file.

TOTAL SEGS

Is the total number of segment instances in the file (shown under ACTIVE COUNT), and the number of segments deleted when the file was last changed (shown under DELETED COUNT).

TOTAL CHARS

Is the number of characters of data in the file.

TOTAL PAGES

Is the number of pages in the data source. Pages are physical records in FOCUS data sources.

LAST CHANGE

Is the date and time the data source was last changed.

If a data source is disorganized by more than 29%, that is, the physical placement of data in the data source is considerably different from its logical or apparent placement, the following message appears

FILE APPEARS TO NEED THE -REBUILD- UTILITY
REORG PERCENT IS A MEASURE OF FILE DISORGANIZATION
0 PCT IS PERFECT -- 100 PCT IS BAD
REORG PERCENT IS x%

where:

x

Is a percentage between 30 and 100.

The variable &FOCDISORG also indicates the level of disorganization. Following is an example of how to use &FOCDISORG in a Dialogue Manager -TYPE command:

-TYPE THE AMOUNT OF DISORGANIZATION OF THIS FILE IS: &FOCDISORG

This command, depending on the amount of disorganization, produces a message similar to the following:

THE AMOUNT OF DISORGANIZATION OF THIS FILE IS: 10

When using a -TYPE command with &FOCDISORG, a message is displayed even if the percentage of disorganization is less than 30%.