DB2 Version 9.7 for Linux, UNIX, and Windows

routine_id - Routine ID monitor element

This monitor element is a unique routine identifier. It returns zero if the activity is not part of a routine.

Table 1. Table Function Monitoring Information
Table Function	Monitor Element Collection Command and Level
MON_GET_ACTIVITY_DETAILS table function - Get complete activity details (reported in DETAILS XML document)	Always collected

Table 2. Event Monitoring Information
Event Type	Logical Data Grouping	Monitor Switch
Activities	event_activitystmt	-
Unit of work	Reported in the package list.	-

Usage

The value of this element matches a value from column ROUTINEID of view SYSCAT.ROUTINES. When the activity is part of a routine declared within another SQL PL routine, the value of this element is the ROUTINEID of the outer routine.