Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS

Stored procedures, user defined functions, and triggers

Stored procedures, user defined functions (UDFs), and triggers are considered “nested” activities. DB2 provides separate Class 1 and Class 2 (elapsed and CPU) timers for stored procedures, UDFs, and triggers. IFCID 3 provides plan level information and aggregates all executions of stored procedures or user defined functions into common fields. DB2 accounting data can distinguish between these activities:

•Non-nested activity

•Nested activity:

 – Triggers

 – Stored procedures

 – User defined ...