Speaker: Company: Presentation Title: Abstract:    
Suresh Sane DST Systems Inc. V8 SQL for the Application Developer - My Favorite Features This presentation provides an in-depth look at the top five important DB2 V8 SQL features. We present a clear and detailed explanation of each feature showing the pros and cons along with benchmarks. We present real-life case studies that can serve as models for your shop. We will not just scratch the surface but cut through the hype and explain what works (and what does not!) based on hands-on experience.
Recursive SQL – Unleash the Power! Recursive SQL is one of the most fascinating and powerful (and dangerous!) features offered in DB2 V8. In this session, we will introduce the feature and show numerous examples of how it can be used to achieve things you would not have imagined being possible with SQL – all in one SQL statement! Fasten your seat belts and come join us in this exciting journey!
 
Bryan Paulsen John Deere DB2 9 for z/OS - John Deere's ESP Experience John Deere participated in the IBM Early Ship Program (ESP) for DB2 9 for z/OS. This presentation will introduce you to some of the new features available in DB2 9 that we tested at John Deere. These features include the DB2 9 migration path, the new Universal Tablespaces, Clone Tables, Partition by Growth, Index Compression, Not Logged Tables, Roles and Trusted Context and several utility enhancements including new functionality for BACKUP SYSTEM and RESTORE SYSTEM. You will gain a general understanding of these features along with some items of interest that we found while testing. Just for fun, I’ll compare some of the DB2 9 features with the equipment we make at John Deere.
BEST USER SPEAKER - IDUG-NA 2007
Terry Purcell IBM Silicon Valley Lab More Ways to Challenge the DB2 z/OS Optimizer Ever wondered what can the DB2 z/OS optimizer choose a non-optimal access path? The more that you understand the challenges that make query optimization difficult to perfect, the better equipped you will be to manage the performance of your SQL queries. This presentation will cover more than simple correlation and data skew challenges for optimal access path selection. BEST OVERALL SPEAKER - IDUG-NA 2007
What's new from DB2 z/OS optimizer in V8 DB2 V8 has been available for many years, and is no longer the current release with the GA of DB2 9 for z/OS. But the reality is that many customers are new to V8 or at least migration to DB2 9 is not in the immediate future. So while it's nice to know what's coming in DB2 9, it's important to understand what can benefit you today.
This presentation will provide an update of the optimization enhancements delivered in DB2 z/OS for V8. Including a focus on "why do you care?" about each. The GA enhancements include (1) Complex Join, (2) Star Join optimization, (3) Predicate Sargability, (4) Visual Explain, (5) REOPT (ONCE) bind option, (6) Runstats enhancements, (7) Materialized Query Tables and (8) Page range screening.
 
   
Randy Ebersole IBM DB2 for z/OS Lab Services What's New in DB2 9 for z/OS This presentation will cover the many new features available in DB2 9 for z/OS. The presentation groups the DB2 9 for z/OS features into three sets, those which provide insight for the business, those which provide cost savings, and those which improve business resiliency. This presentation will provide valuable information for planning and exploitation of this latest version of Db2 for z/OS.
 
Michael Harper IT Specialist, Database Engineering (z/OS) -
TD Bank Financial Group
Error Handling using GET DIAGNOSTICS A programmer's look at using GET DIAGNOSTICS for DB2 error handling.  Via COBOL sample code, presentation will compare the old (DSNTIAR) and the new (GET DIAGNOSTICS) methods .  It will illustrate the pros and cons, benefits and pitfalls of each in order to give the attendee a strong understanding of how to handle DB2 errors from V8 onwards.
   
Susan Lawson President - YL&A DB2 9 for z/OS DBA Administration Certification Crammer Course This is a high-level certification preparation course intended to help you take DB2 9 Family Fundamentals exam (730) and DB2 9 for z/OS Database Administration exam (732). Passing of these exams will result in certification as an IBM Certified Solutions Expert - DB2 V9 z/OS Database Administration. Participants are expected to have fundamental knowledge of relational principles in addition to applied working knowledge of DB2 z/OS V8 and basic knowledge of V9 features. This will be a lecture-only class with no labs. This session offers an intense, overall review of those areas that will be on the certification exams (both the 730 – DB2 9 Family Fundamentals and the 732 – DB2 9 for z/OS), providing a comprehensive review for those planning on taking the certification exams to become an IBM Certified Solutions Expert - DB2 9 for z/OS Database Administration.
     
Hari Shanmugadhasan President, Hari's Database Analysis and Consulting Ltd. V8 Trigger Tales This session will examine some design, SQL coding, performance and usage topics for those who already know the basics about triggers or those who want to be aware of more advanced aspects:
o “Seven with one blow!” – 7 bugs slain with one trigger!
  - Workload “pattern” scenario
  - CPU overhead rationale
  - Multi-edit BEFORE trigger example SQL
  - V8 “tailoring” to exploit some new capabilities
o Comedy of Errors
  - V8 SIGNAL SQLSTATE vs. RAISE_ERROR
  - Diagnostic string expressions to create more informative error messages
  - “They shall not pass!” – triggers as the last line of data integrity defence
  - The finger in the dike – triggers as a “quick and dirty” quick fix
o Paths of Glory? TRIGGR?
  - REBIND TRIGGER PACKAGE
  - The Trigger, the Condition and the EXPLAIN? Or, when is WHEN EXPLAINed?
o Death to the Workfile!
  - A V8 AFTER ROW Trigger Performance Improvement
  - V8 ROW vs. STATEMENT, AFTER Trigger Performance Implications
o Tricky Triggers
  - Some items that come to mind
o To trigger or not to trigger?
  - Considering some alternatives to triggers
o A trigger by any other name?
  - Considering some naming conventions