Topic: 2011 NA
Subtopic: DB2 for LUW
DATE: 2011-5-3 (03:15 PM - 04:15 PM)
SPEAKERS: Alexander Kopac (Home Depot)
Are you the database magician in your shop? Did it take 3 years to build the latest performance mess from the mom & pop cots low bidder thrown over the wall from that irkle design? Are you asked to fix it in 30 minutes or less? Has the regular dba just put in another 70 hour week and is now on catatonic r&r? Here are real sql's and techniques from live customer experiences that will help you see short term bottlenecks and help predict long term failures from poor data type selection, physical/logical design flubs, and strategic storage implementation snags.We'll see the "pick of the litter" performance sql and commands for filtering thru mountains of monitoring parameters/tuning knobs. Learn about quick techniques for viewing the various logs. See simple methods for predicting constraint issues & juggernauts, see index/log bottlenecks, "lack of preparation" issues, rollback/commit snags, and how to look for the "common/unnecessary" application SQL miscodes.
EXP. LEVEL: Beginner
Objective 1: Finding physical design & index flaws
Objective 2: Signature & common SQL flubs from java
Objective 3: Tricks, Techniques, Tuning Knobs in the Toolbag
Objective 4: Finding storage failures & flaws
Objective 5: Forecasting future failures
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.