System z Events

Expert stored procedure monitoring, analysis and tuning on System z

Teleconference

Register Now

Highlights

Topics:

  • Identifying and exposing the mystery behind slow performing stored procedures
  • Drilling down to explore every facet of a stored procedure’s performance breakdown
  • Identifying SQL performance problems quickly throughout layers of complex applications
  • Grouping SQL statements into workloads to compare and track performance improvements

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.

Register Now

Upcoming Events