Looking Behind the Curtain of IBM DB2 for z/OS 10 Performance and Scalability: Stored Procedure Analysis

Monitoring and tuning stored procedure workloads has become more robust with new DB2 engine enhancements and IBM Tivoli OMEGAMON XE Performance Expert (OMPE) for DB2 for z/OS Extended Insight functionality. This session will cover end-to-end stored procedure analysis and demonstrate new OMPE Extended Insight for stored procedures. Statement-level performance analysis will be covered for both stored procedure and non-nested applications. A core understanding of DB2 engine-generated metrics and OMPE exploitation can enable optimal system tuning.