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

View Printable Version

Rocket Science: DB2 for LUW Performance Analysis and Tuning Workshop

Session Number: 1900
Track: Full Day Seminars
Session Type: Podium Presentation
Primary Presenter: Scott Hayes [President & CEO - DBI Software]
Time: Nov 18, 2011 (09:00 AM - 05:00 PM)
Room: Taurus

Speaker Bio: Scott Hayes is an IBM DB2 GOLD Consultant and IBM Information Management Champion, a frequent speaker at IDUG and regional DB2 User Group Events, is the host of The DB2Night Show‚Ñ¢ Webinar series, and author of the widely read DB2 LUW Performance Blogs. He has worked with DB2 on distributed platforms since V1 and he reads IBM documentation instead of novels for entertainment. Scott is also President & CEO of DBI, an IBM Advanced Business Partner focused on DB2 LUW and Oracle performance. Most importantly, Scott enjoys helping people.
Audience experience level: Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: Select a Value
Audiences this presentation will apply to: Application Developers, Data Architects, Database Administrators, New Users
Technical areas this presentation will apply to: Database Performance (DB2 for LUW), High Availability (DB2 for LUW), New Release (DB2 for LUW), SQL and XML Performance, User Experiences
Objective 1: Advanced SQL Snapshots, db2pd, and Measuring Performance. Let's have a look at your numbers and isolate opportunities for improvement.
Objective 2: Configuration Settings. What is AUTOMATIC, what should be set to AUTOMATIC, what shouldn't be set to AUTOMATIC, and, based on measured performance, what should the settings be?
Objective 3: Self Tuning Memory Manager. When to use it and how.
Objective 4: Design Techniques. In light of AUTOMATIC settings and capabilities, what is left for you to do and how can you further improve and optimize performance?
Objective 5: Miscellaneous Tidbits, Cool commands, and Tricks of the Trade. Did you miss the 36+ SQL Snapshot commands in the abstract? This class is a GOLDMINE of Performance Analysis and Tuning.

Abstract:  The performance rules and best practices are changing as DB2 LUW advances. Configuration parameters we used to have to care about are now AUTOMATIC, but are the AUTOMATIC settings ideal? And what about Self Tuning Memory Manager best practices? Most importantly, what ISN'T automatic and what DO you need to pay attention to? What should you measure and how? What are the ‚Äúnew‚Äù and most important configuration and design techniques that will deliver optimized performance results for your organization? Participants will be encouraged to run certain commands in advance and bring performance data to the class. We‚Äôll discuss your numbers, what they mean, and what to do next, and all participants should expect to ‚Äúlearn vicariously‚Äù through the seminar experience. From A to Z, this class will cover the important performance topics for your success with the latest releases. Attendees will receive over 36 SQL Snapshot commands that can be used against DB2 9.1, 9.5, 9.7, and 9.8 databases.

For questions or concerns about your event registration, please contact