Displaying Command Statistics

How to:

Reference:

The ? STAT command lists statistics for the most recently executed command.

Each statistic applies only to a certain command. If another command is executed, the statistic is either 0 or does not appear in the list at all. When you execute commands in stored procedures, these statistics are automatically stored in Dialogue Manager statistical variables. See your Dialogue Manager documentation for details.

Syntax: How to Display Command Statistics

To display command statistics, issue the command:

? STAT

Example: Displaying Command Statistics

Issuing the command

? STAT

produces information similar to the following:

                   STATISTICS OF LAST COMMAND 
RECORDS        =     0           SEGS DELTD      =     0 
LINES          =     0           NOMATCH         =     0 
BASEIO         =     0           DUPLICATES      =     0 
SORTIO         =    47           FORMAT ERRORS   =     0 
SORT PAGES     =     0           INVALID CONDTS  =     0 
READS          =     0           OTHER REJECTS   =     0 
TRANSACTIONS   =     0           CACHE READS     =     0 
ACCEPTED       =     0           MERGES          =     0 
SEGS INPUT     =     0           SORT STRINGS    =     0 
SEGS CHNGD     =     0           INDEXIO         =     0 

INTERNAL MATRIX CREATED:   YES     AUTOINDEX USED: NO 
SORT USED:               FOCUS     AUTOPATH USED:  NO 
AGGREGATION BY EXT.SORT:    NO     HOLD FROM EXTERNAL SORT: NO

Reference: ? STAT Query Information

The following information displays:

RECORDS

Is for TABLE, TABLEF, and MATCH commands. It indicates the number of data source records used in the report. The meaning of a record depends on the type of data source used.

LINES

Is for TABLE and TABLEF commands. It indicates the number of lines displayed in a report.

BASEIO

Is for TABLE and TABLEF commands, and the Developer Studio MODIFY command. It indicates the number of I/O operations performed on the data source.

SORTIO

Is for TABLE, TABLEF, and MATCH commands. It indicates the number of I/O operations performed on the FOCSORT file, which is a work file invisible to the end user.

SORTPAGES

Is for TABLE and TABLEF commands. It indicates the number of physical records in the FOCSORT file.

READS

Is for the Developer Studio MODIFY command. It indicates the number of fixed format records read in external files by the FIXFORM command.

TRANSACTIONS

Is for the Developer Studio MODIFY command. It indicates the number of transactions processed.

ACCEPTED

Is for the Developer Studio MODIFY command. It indicates the number of transactions accepted.

SEGS INPUT

Is for the Developer Studio MODIFY command. It indicates the number of segment instances accepted in the data source.

SEGS CHNGD

Is for the Developer Studio MODIFY command. It indicates the number of segment instances updated in the data source.

SEGS DELTD

Is for the Developer Studio MODIFY command. It indicates the number of segment instances deleted from the data source.

NOMATCH

Is for the Developer Studio MODIFY command. It indicates the number of transactions rejected for lack of matching values in the data source. This occurs on an ON NOMATCH REJECT condition.

DUPLICATES

Is for the Developer Studio MODIFY command. It indicates the number of transactions rejected because the matching field values already exist in the data source. This occurs on an ON MATCH REJECT condition.

FORMAT ERRORS

Is for the Developer Studio MODIFY command. It indicates the number of transactions rejected because field values for data fields do not conform to the field formats defined in the Master File.

INVALID CONDTS

Is for the Developer Studio MODIFY command. It indicates the number of transactions rejected because field values for data fields do not conform to the field formats defined in the Master File.

OTHER REJECTS

Is for the Developer Studio MODIFY command. It indicates the number of transactions rejected for reasons other than those listed above.

CACHE READS

Is the number of cache reads performed. For details, see CACHE in Customizing Your Environment.

MERGES

Is the number of times that merge routines were invoked.

SORT STRINGS

Is the number of times that the sort capacity was exceeded.

INTERNAL MATRIX CREATED

Indicates how report sorting was handled. If an external sort handled it entirely, the value is NO. If both the application and an external sort handled it, the value is Y.

SORT USED

Is the type of sort facility used. It can have a value of FOCUS, EXTERNAL, SQL, or NONE. NONE means that the report did not require sorting.

AGGREGATION BY EXT. SORT

Uses external sorts to perform aggregation.

AUTOINDEX USED

Automatically takes advantage of indexed fields to speed data retrieval.

AUTOPATH USED

Selects an optimal retrieval path for accessing a data source.

HOLD FROM EXTERNAL SORT

Creates hold files with an external sort.


WebFOCUS