Topic: 2011 NA
Subtopic: DB2 for LUW
DATE: 2011-5-4 (11:00 AM - 12:00 PM)
SPEAKERS: Brad Price (Werner Enterprises )
SQL has evolved over many years from a wild and CPU-thirsty beast to a highly refined and extremely robust set of capabilities for accessing your database. Treated with kindness, care and understanding, you can have a long and rewarding relationship with your SQL. However, when ignored, abused or carelessly treated, you may soon find yourself struggling with SQL that is difficult to control and a potential danger to you or your database. Too often, people make emergency visits to the database store to purchase more memory or faster CPU in an attempt to calm a pack of nasty SQL. Instead, come learn how to deal with bad SQL and save yourself from a not-so-pleasant visit from the S.P.C.D. (Society for the Prevention of Cruelty to Databases).
EXP. LEVEL: Beginner,Intermediate,Advanced
How to find and identify bad SQL
How to effectively utilize Visual Explain to understand what is causing the bad SQL behavior
How to use db2batch, snapshots and Administrative Views to zero in on specific problems in an SQL statement
How to identify the best corrective action for the SQL - new/modified indexes, rewrite SQL, database configuration changes, etc.
How to apply benchmarking techniques to quantify improvements
Click Here to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.