Looking Behind The Curtain of DB2 for z/OS 10 Performance and Scalability: End-to-End Stored Procedure Performance Analysis

Session Number: 1824
Track: DB2 10 for z/OS (A)
Session Type: Podium Presentation
Primary Presenter: Maryela Weihrauch [IBM Silicon Valley Laboratory]
Time: Nov 15, 2011 (01:00 PM - 02:00 PM)
Room: Kepler

Speaker Bio: Maryela Weihrauch is an IBM Distinguish Engineer with DB2 z/OS development. She has been working with customers around the world to design their DB2 systems and applications for optimum performance and availability. Currently, she drives DB2's technology in support of Service Oriented Architecture (SOA), leads the DB2 z/OS Solution performance efforts in SVL and is involved in many customer projects with special focus on-demand and SOA transformation. Maryela is frequently sharing her experience at conferences.
Audience experience level: Select a Value
Presentation Category: Implementing New DB2 Releases and Features
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Data Architects, Database Administrators, Systems Programmers
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), User Experiences
Objective 1: How the basic accounting metrics apply in external and native SQL stored procedures
Objective 2: How to drill down into specific stored procedure executions using package accounting and performance trace
Objective 3: How to drill down into specific statements a stored procedure executes
Objective 4: How to drill down into specific statements of a non-nested application executes
Objective 5: Understand SQL statement level statistics counters

Abstract:  Two primary focuses for DB2 for z/OS 10 are scalability and performance. In order to maximize the potential of DB2 for z/OS 10, an understanding of storage scalability metrics and DB2 transaction accounting is a must. Part 2 of a 2 part series will cover end-to-end stored procedure analysis. Statement level performance analysis will be covered for both stored procedure and non-nested applications.