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: EMPLOYEEFOCUS   A1 ON 03/12/99 AT 12.29.51
              ACTIVE  DELETED    DATE OF   TIME OF     LAST TRANS
SEGNAME       COUNT   COUNT      LAST CHG  LAST CHG    NUMBER
 
EMPINFO           12             12/21/93  11.01.32          1
FUNDTRAN           6             11/16/89  16.19.19         12
PAYINFO           19             11/16/89  16.19.20         19
ADDRESS           21             11/16/89  16.19.21         21
SALINFO           70             11/16/89  16.19.22        448
DEDUCT           448             11/16/89  16.19.22        448
TOTAL SEGS       576
TOTAL CHARS     8984
TOTAL PAGES        8
LAST CHANGE                      01/29/96  11.01.32          1

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%.

Information Builders