Query Cost Estimate

 
Snapshot Level
Application
DCS Statement

 
Logical Data Grouping
stmt
dcs_stmt

 
Monitor Switch
Statement
Statement

Resettable

No

Element Name
Element Type

query_cost_estimate
information

Description:  Estimated cost, in timerons, for a query, as determined by the SQL compiler.

Usage:  This allows correlation of actual run-time with the compile-time estimates.

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

• PREPARE

  Represents the relative cost of the prepared SQL statement.

• FETCH

  Contains the length of the row retrieved. Only collected if the DRDA server is DB2 for OS/400.

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

Note:

If the DRDA server is DB2 for OS/390, this estimate could be higher than 2**32 - 1 (the maximum integer number that can be expressed through an unsigned long variable). In that case, the value returned by the System Monitor for this data element will be 2**32 - 1.