IDUG DB2 Tech Conference in Denver, Colorado, USA 2012
Denver Colorado Convention Center, Denver, Colorado
May 14-18, 2012

View Printable Version

DB2 for LUW Performance Analysis and Tuning Workshop - Everything You Need to Know

Session Number: 212
Track: Educational Seminars
Session Type: Podium Presentation
Primary Presenter: Scott Hayes [President & CEO - DBI Software]

Room 106 => Mon, May 14, 2012 (08:30 AM - 05:30 PM)

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: Beginner, Intermediate, Advanced
Presentation Category: Managing Performance
Presentation Platform: DB2 for Linux, UNIX, Windows
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), New Release (DB2 for LUW)
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

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, and 9.7 databases.

More Information:

For questions or concerns about your event registration, please contact