Expert stored procedure monitoring, analysis and tuning on System z
Speaker: Charles Lewis, DB2 Advisor and Senior Certified System z Software Technical Professional, IBM
Replay: Available for your convenience, register now.
Developed for: Application programmers and managers; database administrators and managers
Technical level: Intermediate
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. Join us for this complimentary teleconference as we 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.
Join us after the teleconference for a live question-and-answer session. The teleconference will also be available for replay after the event.