DB2 Version 10.1 for Linux, UNIX, and Windows

mon_rtn_data - Monitoring routine capture configuration parameter

The mon_rtn_data configuration parameter controls the capture of routine invocations. It is a parent parameter to the mon_rtn_execlist configuration parameter.

Configuration type

Database

Applies to

Database server with local and remote clients
Database server with local clients
Partitioned database server with local and remote clients

Parameter type

Configurable online

Propagation class

Next routine invocation

Default [range]

NONE [NONE,BASE]

If the value of mon_rtn_data is set to BASE, then routine monitoring is enabled. Information about executed routines can be accessed using the MON_GET_ROUTINE and MON_GET_ROUTINE_DETAILS interfaces. Routine information is stored in the database heap memory pool. Routine statement monitoring can also be enabled using the mon_rtn_execlist configuration parameter when mon_rtn_data is set to BASE.

If the value of mon_rtn_data is set to NONE, then routine monitoring is disabled. No information is reported in the MON_GET_ROUTINE, MON_GET_ROUTINE_DETAILS, and MON_GET_ROUTINE_EXEC_LIST interfaces. When the mon_rtn_data value is changed to NONE, all preexisting routine monitoring information is deleted.