Skip to content
CA Datacom Core - 15.1
Documentation powered by DocOps

(DQEF0) Query Statistics

Last update November 18, 2015

 =>
 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

Description

The Query Statistics panel appears when you display query output on your video screen and press <PF6> STATS. It also appears at the front of query output routed to the printer, if your user profile is set up to print it automatically. It contains information about how your query processed.

Note: Total Joins, Valid Joins, Estimated I/O, Estimated Rows, and <PF3> OVERALL STATS appear only if the STALL command has been issued during this session. See (DQEC0) FIND Statistics and for more information.

Action

Note the query statistics if a problem occurs during query execution and be prepared to report the information to your CA Dataquery™ for CA Datacom® Administrator for help with problem resolution.

Display Fields

Refer to the following for explanations of the display fields intended to contain variable data.

  • QUERY NAME:
    Name of the query to which these statistics apply.
  • NUMBER REQUESTED:
    Number of rows requested in your query.
  • NUMBER FOUND:
    Number of rows found in the database.
  • COMPLETION DATE:
    Date that the row search for this query ended.
  • COMPLETION TIME:
    Time that the row search for this query ended.
  • FIND TERMINATED BECAUSE:
    NORMAL END OF SEARCH WAS REACHED-- The FIND process completed normally.
    SITE I/O LIMIT (DQOPTLST.SRCHLIM) EXCEEDED -- the FIND exceeded The value set for the I/O limit in the System Option Table parameter SRCHLIM=. Either reduce the number of rows which CA Dataquery™ for CA Datacom® is to FIND, or ask your CA Dataquery™ for CA Datacom® Administrator to increase the value in the SRCHLIM parameter so that your query can finish the FIND processing.
    MAX WORK TABLE BLOCKS EXCEEDED -- Exceeds the FNDBLKS parameter in the System Option Table or your row. See the CA Dataquery™ for CA Datacom® Administrator.
    MAX ELAPSED TIME EXCEEDED -- The maximum time allowed for the processing of a query FIND has been exceeded. Either simplify the FIND so that the FIND processing time is shorter or ask the CA Dataquery™ for CA Datacom® Database Administrator to increase the maximum time allowed.
    FIND CANCELED FROM REQUESTING TERMINAL -- This query has been canceled from the requesting user's terminal.
    FIND CANCELED FROM ANOTHER TERMINAL -- This query was canceled from a terminal that is not the requesting user's terminal.
  • ELAPSED TIME (SECONDS):
    The overall time elapsed in seconds to process the FIND statement.
    OPTIMIZATION -- The process of determining the search strategy for searching the database efficiently.
    SEARCH -- The actual search time against the database for the FIND statement.
  • I/O EVENTS:
    OVERALL -- The overall number of CA Datacom®/DB physical I/O events for the processing of the FIND statement.
    OPTIMIZATION -- The number of CA Datacom®/DB physical I/O events used for determining the database search strategy.
    SEARCH -- The number of CA Datacom®/DB physical I/O events used for the search of the database by the FIND statement.
  • SELFR TOTAL:
    OVERALL -- The overall number of CA Datacom®/DB Compound Boolean Selection SELFR (select first) commands that were issued to execute the FIND statement.
    OPTIMIZATION -- The number of CA Datacom®/DB Compound Boolean Selection SELFR (select first) commands that were issued for determining the database search strategy.
    SEARCH -- The number of CA Datacom®/DB Compound Boolean Selection SELFR (select first) commands that were issued for the search of the database by the FIND statement.
  • SELNR TOTAL:
    OVERALL -- The overall number of CA Datacom®/DB Compound Boolean Selection SELNR (select next) commands that were issued to execute the FIND statement.
    OPTIMIZATION -- The number of CA Datacom®/DB Compound Boolean Selection SELNR (select next) commands that were issued for determining the database search strategy.
    SEARCH -- The number of CA Datacom®/DB Compound Boolean Selection SELNR (select next) commands that were issued for the search of the database by the FIND statement.
  • TOTAL BYTES:
    OVERALL -- The overall number of bytes that were required to hold the internal control blocks that CA Dataquery™ for CA Datacom® built to process the FIND statement.
    OPTIMIZATION -- The number of bytes that were required to hold the internal control blocks that CA Dataquery™ for CA Datacom® built for determining the data base strategy.
    SEARCH -- The number of bytes that were required to hold the internal control block that CA Dataquery™ for CA Datacom® built for the search of the database by the FIND statement.

The following statistics appear on this panel if the STALL command has been used:

  • TOTAL JOINS:
    The number of times tables were joined during query processing.
  • VALID JOINS:
    The number of joins that could be used. Valid joins never exceed total joins. The more tables there are involved, the smaller the percentage of joins that are valid. CA Dataquery™ for CA Datacom® considers every possible join and chooses the optimum combination.
  • ESTIMATED I/O:
    An estimate from the lowest cost join.
  • ESTIMATED ROWS:
    An estimate from the lowest cost join.

PF Keys

The following lists the PF keys for this panel, with a brief description of each function.

  • <PF1> HELP
    Displays Help information about the current panel.
  • <PF2> RETURN
    Exits panel.
Was this helpful?

Please log in to post comments.