Articles & Content

Archives

The Database Whisperer: When SQL Attacks! (C07)

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

OBJECTIVES:

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.