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.