IDUG DB2 Tech Conference in Dublin, Ireland 2015
DB2 Advanced Programming, Automation and Performance
Speaker: Daniel Luksetich [DanL Database Consulting]
DB2 for z/OS fundamentals, explaining what everybody expects you to know
Speaker: Kurt Struyf [Suadasoft]
This class covers the basics in DB2, but explains them in detail. It is the ideal one day in depth explanation of concept and techniques. It’s a full overview of the most critical parts of DB2. If you are at a junior level, you don’t want to miss this class as new insights will be given. If you are a senior level DBA, you might want to refresh some of your knowledge. This class provide a full understanding of
- The different address spaces
- DB2 objects and how they work
- Security concepts
- Buffer and other pools
- SQL performance 101
- Recovery basics and system recovery introduction
OMG! Experience is a Hard Teacher – Lessons Learned that You Should Know!
Speaker: Melanie Stopfer [IBM]
- Utilizing product enhancements and features that make your life easier
- Tips and Techniques to get the most from DB2 Utilities
- Getting more out of your error messages by decoding the secrets
- Monitoring, tuning
- and many more lessons learned will be discussed
By learning from others mistakes, you can learn how to make things right!
DB2 LUW Problem Determination and Troubleshooting Workshop
Speaker: Pavel Sustr and Anthony Reina [IBM]
The popular troubleshooting seminar, updated with the newest problem determination techniques and LIVE DEMOS! Learn how to identify and resolve database hangs, locking problems, crashes, optimizer issues, and 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: database hang, abnormal termination, sub-optimal access plan, bad page, and slow performance.