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.