DB2 Version 9.7 for Linux, UNIX, and Windows

query_card_estimate - Query Number of Rows Estimate monitor element

An estimate of the number of rows that will be returned by a query.

Table 1. Snapshot Monitoring Information
Snapshot Level Logical Data Grouping Monitor Switch
Application stmt Statement
DCS Statement dcs_stmt Statement
Activities event_activity -
Usage
This estimate by the SQL compiler can be compared with the run time actuals.

This element also returns information for the following SQL statements when you are monitoring DB2 Connect™.

  • INSERT, UPDATE, and DELETE

    Indicates the number of rows affected.

  • PREPARE

    Estimate of the number of rows that will be returned. Only collected if the DRDA® server is DB2® for Linux, UNIX, and Windows, DB2 for VM and VSE, or DB2 for OS/400®.

  • FETCH

    Set to the number of rows fetched. Only collected if the DRDA server is DB2 for OS/400.

If information is not collected for a DRDA server, then the element is set to zero.

Parent topic: Database system monitor elements
Related reference:
query_cost_estimate - Query cost estimate monitor element