DB2 Version 9.7 for Linux, UNIX, and Windows
DB2 Version 9.7 for Linux, UNIX, and Windows
The total elapsed time spent on application requests; this is the total time spent by coordinator agents on the server executing application requests. This value is reported in milliseconds.
| Table Function | Monitor Element Collection Level |
|---|---|
| MON_GET_CONNECTION table function - Get connection metrics | REQUEST METRICS BASE |
| MON_GET_CONNECTION_DETAILS table function - Get detailed connection metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
| MON_GET_SERVICE_SUBCLASS table function - Get service subclass metrics | REQUEST METRICS BASE |
| MON_GET_SERVICE_SUBCLASS_DETAILS table function - Get detailed service subclass metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
| MON_GET_UNIT_OF_WORK table function - Get unit of work metrics | REQUEST METRICS BASE |
| MON_GET_UNIT_OF_WORK_DETAILS table function - Get detailed unit of work metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
| MON_GET_WORKLOAD table function - Get workload metrics | REQUEST METRICS BASE |
| MON_GET_WORKLOAD_DETAILS table function - Get detailed workload metrics (reported in DETAILS XML document) | REQUEST METRICS BASE |
Use this monitor element to determine the time that the application request spent in the DB2® data server. This value can be used to help determine if the data server is the source of an observed performance problem.
For example, if a user reports that there is a problem with an application and it has taken 20 minutes to return, and if you determine that total application request time is 1 minute and there are currently no application requests in progress for the connection, then the performance problem might lie outside of the DB2 data server.