O'Reilly logo

Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS by Yasuhiro Ohmori, Cathy Drummond, Adrian Burke, Felipe Bortoletto, Paolo Bruni

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required