Educational Seminars
IDUG Educational Seminars are an opportunity to take a deep dive into specific aspects of DB2 with some of the most renowned speakers in our industry. You will not only have the opportunity to listen to these speakers but will have the opportunity to ask them specific questions as well.
This year the seminars will be held on Friday, October 18 2013 and the full day experience includes lunch as well as hard copies of the course materials. There is an additional registration fee for these seminars of €495 + VAT. For paid full IDUG Conference delegates, the rate is reduced to €450 + VAT.
Get the most educational value out of your conference attendance by adding any of these educational seminars to your registration!

DB2 for z/OS Memory Management Masterclass - Julian Stuhler [Triton Consulting]
This class will consist of a comprehensive look at the architecture, management and performance tuning issues associated with DB2 for z/OS system storage, and is aimed at DB2 for z/OS Systems Programmers and DBAs wishing to enhance their knowledge of DB2 memory management and tuning in V9, V10 and beyond.div>
Attendees will leave with a good understanding of how to monitor and tune critical storage areas including Bufferpools, the EDM Pool, the Dynamic Statement Cache and the Coupling Facility. Both Virtual and Real Storage tuning will be covered in-depth and at the end we'll peak into the near future with a look at how DB2 11 and zEC12 hardware improvements will impact DB2 memory management.

DB2 z/OS High Performance Design and Tuning: Classic Techniques and DB2 10 Considerations - Susan Lawson [YL&A]
Achieving maximum performance from DB2 requires a different approach and stricter methodologies than simply getting a DB2 application to perform well. In today’s high volume/high performance environments the rules have changed and we must find every tuning knob in order to get another transaction through the system.
This seminar focuses on specific issues of system design, physical object design, application design and tuning methods used to achieve high performance. Topics such as table and index design, large tables and NPSI's, DPSIs, pushing logic into SQL, control and concurrency, enterprise wide performance topics are examined for OLTP, batch, and data warehousing.
Topics such as buffer pool design and utilization, concurrency and locking, DB2 compression, EDM pool sizing, RID pool sizing, Sort work and work file tuning, and parallelism are examined, and it is shown how poor memory tuning directly effects application performance. Focus is on the complete set of design points of DB2, and how they will affect performance of your applications.
Discover why many old guidelines no longer apply, how old standards can actually hurt us and learn the approaches to systems management and tuning for the DB2 environment. This course gives new ideas on achieving the new demands placed on us in today’s high volume/high availability environments. The rules have changed and certainly in DB2 10 there are many more features to take advantage of and to be careful with!

DB2 LUW Problem Determination and Troubleshooting Workshop - Pavel Sustr [IBM] & Samir Kapoor [IBM]
The popular DB2 LUW troubleshooting seminar, updated with the newest techniques and LIVE DEMOS! Learn how to identify and resolve problems such as database hangs, locking problems, crashes and optimizer or performance problems. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution. Topics covered: Performance, Optimizer, FODC, Hangs, Locking/Latching, and Crashes/Traps.

Attendees will be able to characterize a problem in order to expedite resolution, learn how and what data to collect during intermittent hangs, slow-downs, and other frequent problems, and understand DB2 Support’s methodology in troubleshooting DB2 and even non-DB2 hiccups. The seminar contains live demos, during which the audience will be given an opportunity to perform an interactive investigation of selected problems, e. g. database hang, slow performance, bad page, and DB2 instance abend.

Matching Indexes to SQL - Bonnie Baker [Bonnie Baker Corp.]
Index design in DB2 for z/OS is a whole new game today.  There have been so many changes in the last few releases that our index design techniques should be readdressed.  This seminar will not only cover DPSIs, multiple PIs, and NPSIs, it will also cover new issues, such as:
  • SQL that demands a particular index in order to pass a syntax check
  • "Random" Indexes - how they work and when they are appropriate
  • Indexes that were required in the past for good performance that are no longer needed today
  • Unique indexes with "Include" columns - how and when to use them
  • Bi-directional indexes and exactly how they are used for sort-avoidance
  • Unpadded indexes and why they may not improve performance or save disk space
  • Index compression
  • And most important - designing indexes for SQL and validating that the design is good.

Advanced SQL Coding and Performance - Dan Luksetich [DanL Database Consulting]
This is a cross-platform advanced SQL seminar with a focus on performance. Learn advanced SQL coding techniques, as well as exactly when to use these techniques for various coding situations.
This seminar address advanced SQL syntax and coding techniques with query performance in focus. Examples of complex SQL in different formulations are shown to demonstrate those that they perform efficiently versus those that perform in the worst possible manner. DB2 brought a whole new world to relational with advancements in SQL processing and object relational support.
Presented here are the more advanced examples of subqueries, joins, anti-joins, table expressions, CASE expressions, UDFs, table functions, SQL recursive processing, relational division, OLAP expressions, PureXML, and many other features of the DB2 family. There are many examples taken from real systems. An emphasis is made on the proper use of each technique for performance.