Applications: Statement (DB2 UDB for UNIX and
Windows) 
To display information on performance data of the current SQL statements for your selected application(s), call the DBA Cockpit.
...
1. In the navigation frame, choose Performance ® Applications.
The Application Snapshot screen appears.
2.
To display more detailed
information, select one or more applications and choose 
Details.
A detail Application Snapshot screen appears.
3. Choose Statement.
If you have selected more than one application, you can use the page buttons on the screen to navigate between them.
|
Field |
Description |
|
Statement |
|
|
Start Time |
Date and time when unit of work starts, the statement starts or a deadlock is detected |
|
Stop Time |
Date and time when the statement stopped executing |
|
Elapsed Time(s) |
Duration of unit of work in seconds |
|
Elapsed Time (µsec) |
Duration of unit of work in microseconds |
|
Rows |
|
|
Rows Read |
Number of rows read from the table |
|
Rows Written |
Number of rows changed (inserted, deleted or updated) in the table |
|
Sort |
|
|
Sort Overflow |
If the storage area allocated for sorting is not large enough, a sort overflow occurs. The hard disk is then temporarily used. |
|
Total Sort Time |
Total time for all sort processes |
|
Number of Statement Sorts |
Total number of sorts that have been executed |
|
Data |
|
|
Logical Reads |
Number of read accesses to data in the buffer pool |
|
Physical Reads |
Number of read accesses to data on disk |
|
Temporary Logical Reads |
Number of logical read requests that required I/O to get data pages into the temporary tablespace |
|
Temporary Physical Reads |
Number of physical read requests that required I/O to get data pages into the temporary tablespace |
|
Index |
|
|
Logical Reads |
Number of read accesses to data in the buffer pool |
|
Physical Reads |
Number of read accesses to data on disk |
|
Temporary Logical Reads |
Number of logical read requests that required I/O to get index pages into the temporary tablespace |
|
Temporary Physical Reads |
Number of physical read requests that required I/O to get index pages into the temporary tablespace |