Top10

The Top10 window shows information about the Top 10 statements activity. 

The grid located at the top of the window shows each database partition. It allows you to filter top statements for each database partition.

The next grid shows each individual statement with top Frequency of execution with the following information for each one:

Partition Database partition number.
Num Execs The number of times that an SQL statement has been executed.
Avg Time (sec) The average time that was spent executing a particular statement in the SQL cache.
Num Sorts The total number of times that a set of data was sorted in order to process a operation.
Sorts Per Stmt The average number of times that a set of data was sorted.
SQL Stmt This is the text of the dynamic SQL statement.

By default, the last snapshot is displayed in the grid. Use the slidder (or the arrow buttons) located at the top of the grid to navigate through the collected snapshots. In monitoring, the "Update" button must be unchecked to be able to navigate through the collected snapshots.

The grid located at the middle of the window shows each individual statement with top Execution time with the following information for each one:

Partition Database partition number.
Num Execs The number of times that an SQL statement has been executed.
Avg Time (sec) The average time that was spent executing a particular statement in the SQL cache.
Num Sorts The total number of times that a set of data was sorted in order to process a operation.
Sorts Per Stmt The average number of times that a set of data was sorted.
SQL Stmt This is the text of the dynamic SQL statement.

The grid located at the bottom of the window shows each individual statement with top Long Running SQL with the following information for each one:

Partition Database partition number.
Elapsed (min) The elapsed execution time of the most recently completed statement.
Status The current status of the application.
Auth ID The authorization ID of the user who invoked the application that is being monitored. On a DB2 Connect(TM) gateway node, this is the user's authorization ID on the host.
IP Address This is the communication address of the client. For example, it could be an SNA net ID and LU partner name, or an IP address and port number for TCP/IP.
SQL Text This is the text of the dynamic SQL statement.

See also:





Go back to the Learning center:


Copyright © AgileLoad. All rights reserved.
Agile Load testing tool| Contact AgileLoad | Terms of Use | Sitemap