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 support@idug.org


    Copyright © 2014 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact