IDUG DB2 Tech Conference EMEA 2011
Clarion Congress Hotel, Prague, Czech Republic
14 - 18 November, 2011

View Printable Version

Back to the Fifties... 50 Fabulous ways for forecasting failures, flaws, & finding flubber in DB2 LUW

Session Number: 2027
Track: DB2 for LUW Lessons Learned (D)
Session Type: Podium Presentation
Primary Presenter: Alexander Kopac [Database-Brothers]
Time: Nov 16, 2011 (02:15 PM - 03:15 PM)
Room: Taurus

Speaker Bio: Alexander Kopac (Austin, TX) is IBM Certified for DB2 Database Admin for DB2 LUW & z/OS and an IBM Information Champion. He has 15+ yrs of DBA experience and was a consultant for 10 years working with automotive manufacturing, airline fares marketing, finance & insurance company marketing systems. He has delivered more than 30 presentations for ISACA, IDUG Regional User Groups, IDUG Europe 2001-10, IDUG North America 2002-10, CA-World, IBM's DB2 Data Management Technical Conference, INFOTEC and many others. He’s had a lot of fun helping folks with Oracle, DB2 z/OS & DB2 for LUW auditing & performance issues. He was an IDUG North America Conference Planning Committee (NACPC) member 2004-7 and was awarded the 2010 IDUG North America Best User presentation.
Audience experience level: Beginner
Presentation Category: Managing Performance
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), User Experiences
Objective 1: Objective 1: Finding physical design & index flaws
Objective 2: Objective 2: Signature & common SQL flubs from java
Objective 3: Objective 3: Tricks, Techniques, Tuning Knobs in the Toolbag
Objective 4: Objective 4: Finding storage failures & flaws
Objective 5: Objective 5: Forecasting future failures

Abstract:  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.

For questions or concerns about your event registration, please contact