|
Snapshot Level Application DCS Statement |
Logical Data Grouping stmt dcs_stmt |
Monitor Switch Statement Statement |
|
Resettable |
No |
|
|
Element Name Element Type |
query_card_estimate information |
Description: An estimate of the number of rows that will be returned by a query.
Usage: This estimate by the SQL compiler can be compared with the run time actuals.
This data element also returns information for the following SQL statements when you are monitoring DB2 Connect.
Indicates the number of rows affected.
Estimate of the number of rows that will be returned. Only collected if the DRDA server is DB2 Universal Database, DB2 for VM and VSE, or DB2 for OS/400.
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 data element is set to zero.