DB2 Version 10.1 for Linux, UNIX, and Windows
DB2 Version 10.1 for Linux, UNIX, and Windows
This parameter controls the monitoring of statements executed by routines. This is done at the database level and takes effect for any routine invocation within the database.
Routine executable lists are a list of sections (compiled SQL statements) executed by any procedures, external functions, compiled functions, compiled triggers, and anonymous blocks. Routine executable lists include a set of metrics for each section aggregated over all the executions of the section by a routine. Each section in the output executable lists is uniquely identified by an executable ID which can be used to find additional information about the sections, such as statement text, with package cache interfaces like MON_GET_PKG_CACHE_STMT. Memory for the routine executable lists file is allocated from the monitor heap. Routine executable list monitoring is limited to at most 20% of the available monitor heap.
When the value of mon_rtn_execlist is set to ON, then executable ID list collection is enabled for routine monitoring, and MON_GET_RTN_EXEC_LIST returns monitoring data.
When the value of mon_rtn_execlist is set to OFF, then executable ID list collection is disabled for routine monitoring, and MON_GET_RTN_EXEC_LIST does not return monitoring data. When the value of mon_rtn_execlist is changed to OFF, all preexisting routine execution list metrics is deleted.
For a list of metrics gathered when this parameter is enabled, refer to the MON_GET_RTN_EXEC_LIST documentation.