Without visibility into the performance of stored procedures, true analysis is often not possible, especially when basic performance metrics are hidden deep within nested stored procedures and statements. Further, package-level analysis can be difficult if a stored procedure executes different paths and SQL based on parameters. How do you differentiate between the invocations? Even when review and analysis is possible, an easy method is needed to tune the store procedure for optimum performance.
Monitoring and tuning stored procedure workloads have become more robust with new DB2® engine enhancements and functionality in IBM Tivoli® OMEGAMON® XE Performance Expert for DB2 for z/OS® Extended Insight. In this session we will cover end-to-end stored procedure analysis and demonstrate new Extended Insight for stored procedures. You’ll learn about statement-level performance analysis for both stored procedure and non-nested applications. With a core understanding of DB2 engine-generated metrics and Tivoli OMEGAMON XE for DB2 exploitation, you can enable optimal system tuning.