Run Profiling window

Use this window to select optional monitor elements to include in the report that is generated when you run a procedure using SQL profiling. All profiling reports always include the routine schema, the specific name, line number information, the number of iterations for each statement, the elapsed time for each statement, the CPU time for each statement, and statement text.

The following section describes the optional monitor elements that are available. Select a monitor element to generate the information that is described for that element in the profiling report. For more information, see the DB2® System Monitor Guide and Reference.

FETCH_COUNT
Number of Successful Fetches. The number of successful fetches that were performed on a specific cursor.
INT_ROWS_DELETED
Internal Rows Deleted. The number of rows that were deleted from the database as a result of internal activity.
INT_ROWS_INSERTED
Internal Rows Inserted. The number of rows that were inserted into the database as a result of internal activity caused by triggers.
INT_ROWS_UPDATED
Internal Rows Updated. The number of rows that were updated from the database as a result of internal activity.
POOL_DATA_L_READS
Buffer Pool Data Logical Reads. The number of logical read requests for data pages that went through the buffer pool.
POOL_DATA_P_READS
Buffer Pool Data Physical Reads. The number of read requests that required I/O to get data pages into the buffer pool.
POOL_INDEX_L_READS
Buffer Pool Index Logical Reads. The number of logical read requests for index pages that went through the buffer pool.
POOL_INDEX_P_READS
Buffer Pool Index Physical Reads. The number of physical read requests to get index pages into the buffer pool.
POOL_TEMP_DATA_L_READS
Buffer Pool Temporary Data Logical Reads. The number of data pages that were requested from the logical buffer pool for temporary table spaces.
POOL_TEMP_DATA_P_READS
Buffer Pool Temporary Data Physical Reads The number of data pages that were read in from the physical table space containers for temporary table spaces.
POOL_TEMP_INDEX_L_READS
Buffer Pool Temporary Index Logical Reads. The number of index pages that were requested from the logical buffer pool for temporary table spaces.
ROWS_READ
Rows Read. The number of rows that were read from the table.
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.

Feedback