Database performance data gathered when running a routine

When you run a routine and gather database performance data, the information is displayed in SQL Results view.

These columns contain information about the routine.

Table 1. Database routine information
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.

Table 2. DB2 Monitor Elements
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.

Feedback