These columns contain information about the routine.
Column | Description |
---|---|
Line Number | The routine line number. |
SQL | Routine SQL code. Database performance information is gathered for SQL statements that run on the database. |
The following table describes the columns that contain the performance information. The performance information is gathered from DB2® monitor elements. For more information about the DB2 monitor elements, see the DB2 System Monitor Guide and Reference.
Column | Monitor Element | Description |
---|---|---|
Buffer Pool Data Logical Reads | pool_data_l_reads | The number of logical read requests for data pages that went through the buffer pool. |
Buffer Pool Data Physical Reads | pool_data_p_reads | The number of read requests that required I/O to get data pages into the buffer pool. |
Buffer Pool Index Logical Reads | pool_index_l_reads | The number of logical read requests for index pages that went through the buffer pool. |
Buffer Pool Index Physical Reads | pool_index_p_reads | The number of physical read requests to get index pages into the buffer pool. |
Buffer Pool Temporary Data Logical Reads | pool_temp_data_l_reads | The number of data pages that were requested from the logical buffer pool for temporary table spaces. |
Buffer Pool Temporary Data Physical Reads | pool_temp_data_p_reads | The number of data pages that were read in from the physical table space containers for temporary table spaces. |
Buffer Pool Temporary Index Logical Reads | pool_temp_index_l_reads | The number of index pages that were requested from the logical buffer pool for temporary table spaces. |
Buffer Pool Temporary Index Physical Reads | pool_temp_index_p_reads | The number of index pages that were requested from the physical table space containers for temporary table spaces. |
Elapsed Time | stmt_elapsed_time | Total elapsed time for the statement. |
Number of Executions | num_executions | The number of times the routine statement was run. |
Rows Read | rows_read | The number of rows that were read from the table. |
Rows Returned | rows_returned | The number of rows that have been selected and returned to the application. |
Rows Written | rows_written | The number of rows that were changed (inserted, deleted, or updated) in the table. |
Total Sort Time | total_sort_time | The total elapsed time in milliseconds for all sorts that were run. |
Total Sorts | total_sorts | The total number of sorts that were run. |
User CPU Time | user_cpu_time | The total user CPU time that was used by the statement. |