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.


Top of page

x
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 

Top of page

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


WebFOCUS