Expert Stored Procedure Monitoring, Analysis and Tuning on System z
Project and Program: Information Management
, SHARE in Boston 2013
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. Steven Fafard IBM Corporation
Steven Fafard , IBM Corporation
Back to Proceedings File Library