These Full-Day Seminars are held on Monday, May 14 and provide a great start to your IDUG week by giving you access to some of the top speakers in the DB2 industry. The additional fee includes breakfast, lunch and course materials for the seminar you attend.
- Educational Seminar With Full Conference Registration: $425
- Educational Seminar Without Full Conference Registration: $475
Select from these 6 topics of interest:
DB2 10 for z/OS DBA Certification Crammer Course:
Susan Lawson, YL&A
This course is a certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 10 for z/OS Database Administration exam (612). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 10 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 9 for z/OS and basic knowledge of DB2 10 features. Susan’s latest book will also be available, for sure before the conference and hopefully at the conference.
Recommended Best Practices from Customer DB2 Health Check
Studies: John Campbell, IBM DB2 for z/OS Development
This one day seminar will introduce and discuss the major lessons to be learned from customer DB2 Health Check Studies carried out by DB2 for z/OS Development and provide recommended best practices in each area. The objectives are to: introduce and discuss the most common issues, share the experience gained from customer health check studies, share the experience from live customer production incidents, provide proven recommended best practice, and to encourage proactive behavior. The following topics will be covered: WLM Policy Setup, Balanced Design across CICS and DB2 Disaster Recovery, use of Flashcopy, Continuous Availability vs. Fast Failover, Preventative Software Maintenance, Multiple Data Sharing Groups., Running Multiple DB2 Subsystems on same LPAR, Normal DB2 Warm Restart vs. Restart Light, Storage Tuning. Download John’s Flashbook for free: DB2 for z/OS Planning Your Upgrade: Reduce Costs. Improve Performance (3.36MB)
DB2 9.7 for Linux, UNIX and Windows DBA Certification
Crammer (Exam 541): Roger Sanders, EMC Corporation
This training is designed to introduce you to the concepts a test candidate must know in order to take and pass the DB2 9.7 DBA for Linux, UNIX and Windows certification exam (Exam 541). The material for this course is aligned with the 541 exam objectives. After completion of this class, you will be familiar with the concepts you will be expected to know and understand in order to take and pass the DB2 9.7 for Linux, UNIX and Windows Database Administration Certification Exam (Exam 541). Get Roger’s book about this exam: DB2 9.7 for Linux, UNIX, and Windows Database Administration: Certification Study Notes
DB2 LUW Problem Determination and Trou bleshooting Workshop: Pavel Sustr, IBM Toronto Lab
The popular DB2 LUW troubleshooting seminar, updated with 9.7 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.
DB2 for LUW Performance Analysis and Tuning Workshop -
Everything You Need to Know: Scott Hayes, DBI
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. Attendees will receive over 36 SQL Snapshot commands that can be used against DB2 9.1, 9.5 and 9.7 databases.
I Didn't Know DB2 did THAT!: Bonnie Baker,
Bonnie Baker Corp.
Have you ever wondered what goes on inside DB2 when your SQL is being executed? This seminar is designed to answer exactly that question and more by taking a look at DB2 Components and the Optimizer's instructions for various SQL access paths. While simple paths will be reviewed, this class will also focus on those difficult to understand access paths. Topics include RIDPOOL failures, Hybrid Joins and a "Type C" Hybrid Join, coding both a GROUP BY and an ORDER BY on the same columns to insure that my GROUPs are returned in ORDER, using a 64-partition DPSI for SORT Avoidance, how does DB2 know if Index-Only data is "clean" or "dirty", result sets built at OPEN CURSOR, DSNZPARMs affects on access path selection and operation and much, m uch more! Platform: DB2 for z/OS
Take advantage of this additional conference option and register today!
Be an IDUG Mentor
IDUG is proud to offer an incomparable loyalty reward program for those who have attended three or more IDUG conferences - the opportunity to bring a first-time attendee for an unprecedented 80% discount! For IBM Champions, the number of years of attending a conference and the restriction that the mentor must pay a full conference registration, is being waived. If they are a speaker or volunteer, using thier well-deserved speaker or volunteer discount no longer prevents them from applying for the discount to mentor a first time attendee. To learn more, visit the IDUG Web site.