SHARE in Boston

13824: Expert Stored Procedure Monitoring, Analysis and Tuning on System z

Friday, August 16, 2013: 9:30 AM-10:30 AM
Room 305 (Hynes Convention Center)
Speaker: Steven Fafard(IBM Corporation)
  • SHARE 13824 (1.7 MB)
  • 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.

    Tracks: Application Development, Software Architecture and z/OS Systems Programming
    Share |

    See more of Project: Database
    See more of Program: Information Management