Operation Commands › STALL - Produce Additional Statistics

STALL - Produce Additional Statistics

Purpose

Administrators or Support personnel may need certain statistics when managing the system and they may ask you to provide them. The DQL Mode STALL command displays statistics about total joins, valid joins, estimated I/O and estimated rows during display of the FIND Statistics (DQEF0) panel. Pressing the STATS PF key during query output displays the basic FIND statistics. Entering the STALL command next displays the additional statistics and the TABLE STATS PF key.

Entering the STALL command during query output (without pressing the STATS key at all) displays the FIND statistics panel with the additional statistics and with the TABLE STATS key. See (DQEF0) Query Statistics for additional information about the Find Statistics (DQEC0) panel.

When to Use It

Enter the STALL command when requested by the CA Dataquery Administrator or CA Support.

Syntax

Example

 =>
 CURRENT DATAQUERY FIND/SELECT STATISTICS.
 ------------------------------------------------------------------------DQEF0
 DATAQUERY:  FIND STATISTICS                       QUERY NAME:
 -----------------------------------------------------------------------------
 
      NUMBER REQUESTED:                            COMPLETION DATE:
      NUMBER FOUND:                                COMPLETION TIME:
 
      FIND TERMINATED BECAUSE:
 
                                OVERALL    OPTIMIZATION     SEARCH
                                -------    ------------    -------
      ELAPSED TIME (SECONDS):
      I/O EVENTS:
      SELFR TOTAL:
      SELNR TOTAL:
      TOTAL BYTES:
 
 
 
 -----------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN

Result

 =>
 CURRENT DATAQUERY FIND/SELECT STATISTICS.
 ------------------------------------------------------------------------DQEF0
 DATAQUERY:  FIND STATISTICS                       QUERY NAME:
 -----------------------------------------------------------------------------
 
      NUMBER REQUESTED:                            COMPLETION DATE:
      NUMBER FOUND:                                COMPLETION TIME:
 
      FIND TERMINATED BECAUSE:
                                OVERALL    OPTIMIZATION     SEARCH
                                -------    ------------    -------
      ELAPSED TIME (SECONDS):
      I/O EVENTS:
      SELFR TOTAL:
      SELNR TOTAL:
      TOTAL BYTES:
      TOTAL JOINS:
      VALID JOINS:
      ESTIMATED I/O:
      ESTIMATED ROWS:
 -----------------------------------------------------------------------------
 <PF1> HELP        <PF2> RETURN        <PF3> TABLE STATS