Articles & Content
Topic: 2008 NA
Subtopic: DB2 for LUW
DATE: 2008-05-21 (01:30 PM - 02:30 PM)
SPEAKERS: Phil Gunning (Gunning Technology Solutions, LLC)
Attend this session to learn how to first identify, and then fix suboptimal SQL. Usually 80% of performance problems are caused by suboptimal SQL. One suboptimal, high frequency SQL statement can drive a 16-way processor to its knees. Actual client experiences and examples will be presented. In this day and age where development time is short and deadlines tight, suboptimal SQL makes it's way into production. This session will show you how to capture suboptimal SQL with DB2 provided administrative routines and convenience views, without needing a third party vendor tool. You will be shown how to rank and review the top 10 SQL. Methods and techniques will be presented that you can use to then tune this suboptimal SQL. SQL best practices as well as index best practices will be presented. At the end of this session you will be able to capture suboptimal SQL, tune it, implement corrective action, and learn how to verify that the problem has been corrected.
EXP. LEVEL: Beginner,Intermediate,Advanced
Learn how to identify suboptimal SQL
Identifying the Top 10 SQL
Ways you can rewrite or tune the SQL
Index Solutions, DB2 Explain, Design Advisor
Implementing and verifying the solution
This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.