View Printable Version

F20 - Taming the Dynamic SQL Beast

Session Number: 2347
Track: A La Carte'
Session Type: Podium Presentation
Primary Presenter: Adrian Burke [DB2 SWAT Team - IBM]

Adams => Fri, May 08, 2015 (09:15 AM - 10:15 AM)

Speaker Bio: Adrian Burke is an Open Group Master Certified IT Specialist on the DB2 SWAT team based out of the Silicon Valley Lab, lead by John Campbell. In this role as a technical advocate for DB2 for z/OS Adrian conducts consulting and educational workshops, DB2 health checks, and availability studies for DB2 for z/OS customers. Previously, as a DB2 Advisor, Adrian supported hundreds of DB2 for z/OS customers from a technical sales perspective delivering consultative and educational workshops. Adrian has spoken at numerous DB2 Regional User Groups both in the U.S. and abroad as well as presented at IDUG, SHARE, and IOD. He is also a published Redbook author on material dealing with DB2 performance.
Audience experience level: Beginner, Intermediate
Presentation Category: Managing Database Resources, Managing Performance
Presentation Platform: DB2 for z/OS
Audiences this presentation will apply to: Application Developers, Database Administrators, Systems Programmers, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for z/OS), SQL and XML Performance, Tools and Utilities
If Tools and Utilities was selected which products: IBM Data Studio
Objective 1: Overview of the dynamic statement cache(s)

Objective 2: Traces and EXPLAIN support to monitor cached statements
Objective 3: DB2 10 (NFM) - Special Register CURRENT EXPLAIN MODE
Objective 4: Mining through the Dynamic Statement Cache using IBM Data Studio
Co-speaker Name: Saghi Amirsoleymani
Co-speaker Bio: Saghi Amirsoleymani is a Solutions Architect in Optim Enablement team at IBM's Silicon Valley Lab in San Jose, CA, where she enables customers and partners on IBM Optim Data Studio technologies. Prior to joining this team, Saghi was part of the DB2 z/OS L2 team. She joined IBM in 1999, after finishing her degree at University Southern California. She has presented on various topics related to Data Studio and Performance at the Information on Demand and IDUG conferences, various user groups, and events.

Abstract:  With the proliferation of the use of dynamic SQL, it has become more challenging for database professionals to manage performance. This presentation will look at ways to assist in meeting these challenges. First, it will introduce the principles of dynamic statement caching and provide general rules of thumbs for overall performance. It will then look into the DB2 trace and EXPLAIN support to collect and externalize statement-level statistics. Finally, it will show how IBM Data Studio can be used to simplify the end-to-end tuning process.

For questions or concerns about your event registration, please contact