|
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.
Represents the relative cost of the prepared SQL statement.
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. |