The Query Cost Estimate data element (query_cost _estimate) now 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. |