Previous Topic: PanelNext Topic: Executing in Batch


Viewing Query Statistics

If you press <PF6> STATS while viewing a report on your terminal screen, you can display a panel like the following example.

=> Current Dataquery FIND/SELECT Statistics. --------------------------------------------------------------------------DQEF0 DATAQUERY:  FIND STATISTICS                       QUERY NAME:  TESTSQL001 -------------------------------------------------------------------------------      NUMBER REQUESTED:  ALL                       COMPLETION DATE:  08/06/2011      NUMBER FOUND:  9                             COMPLETION TIME:  15:37:40      FIND TERMINATED BECAUSE:  NORMAL END OF SEARCH WAS REACHED                                OVERALL    OPTIMIZATION     SEARCH                                -------    ------------     ------      ELAPSED TIME (SECONDS):         1               0          0      I/O EVENTS:                     0               0          0      SELFR TOTAL:                    0               0          0      SELNR TOTAL:                    0                          0      TOTAL BYTES:                    0 ------------------------------------------------------------------------------- <PF1> HELP        <PF2> RETURN

The FIND STATISTICS panel gives you information about how the query functioned when you executed it. Details about the meaning of each field are available in the CA Dataquery Reference Guide and from your CA Dataquery Administrator.

You may need to pass this information to your CA Dataquery Administrator if you experience problems in executing a query.