Monday, 10 November
  DB2 11 for z/OS DB2 for z/OS II DB2 10.5 for LUW DB2 for LUW II Analytics &
Big Data
Application
Development
09:00
-
09:30
Opening
09:30
-
10:30

Motivational Keynote
Caspar Berry
Nadir & Zenit

10:45
-
11:45
[AB1] DB2 11 for z/OS: Migration Planning and Early Experiences - Part 1
John Campbell
Tycho & Kepler
[CD1] DB2 Internals for Administrators : Updated for Latest Release - Part 1
Matt Huras
 Leo & Virgo
[E1] IBM DB2 Analytics Accelerator for z/OS: What's new.
Peter Bendel
Aquarius
[F1] Understanding Query Transformation in DB2 for z/OS
Daniel Luksetich
Taurus
  11:45 - 12:00 Coffee Break
12:00
-
13:00
[AB1] DB2 11 for z/OS: Migration Planning and Early Experiences - Part 2
John Campbell
 Tycho & Kepler
[CD1] DB2 Internals for Administrators : Updated for Latest Release - Part 2
Matt Huras
 Leo & Virgo
[E2] Investigating the IDAA with SMF
Fabio Massimo Ottaviani
Aquarius
[F2] Overview of DB2 10 and 11 SQL Enhancements
Chris Crone
Taurus
  13:00 - 14:00 Lunch
14:00
-
15:00
Vendor Solution Presentations
15:15
-
16:15
[A3] Real Customer DB2 for z/OS Version 11 early migration experiences - some magic - and why the Extended LRSN should not scare...Ute Kleyensteuber and Michael Dewert
 Tycho
[B3] Lost without a trace
Denis Tronin
Kepler
[C3] Best Practices Upgrade to DB2 10.5 with BLU Acceleration
Cris Eaton
Leo
[D3] Top 5 cool tricks with DB2 LUW
Adam Storm
Virgo
[E3] Saving 20% CPU with IDAA on OLTP data
Thomas Baumann
Aquarius
[F3] Monetary Cost of SQL
Mike Faltys
Taurus
  16:15 - 16:30 Coffee Break
16:30
-
17:30
[A4] DB2 11 Utilities Update
Haakon Roberts
 Tycho
[B4] How to use DB2 Large Objects (LOBs) efficiently
Maryela Weihrauch and Frances Villafuerte
Kepler
[C4] Keeping Data Analysts in the Pink with DB2 with BLU Acceleration on POWER7 at BlueCross BlueShield of Tennessee
Randy Wilson and Danny Arnold
Leo
[D4] Sage Advice: 20 Invaluable DB2 LUW Performance Insights from Around the Globe
Scott Hayes
Virgo
[E4] Get most out of IBM DB2 Analytics Accelerator: Latest Insights from customers and PoCs
Patric Becker
Aquarius
[F4] A comparison of different ways to represent hierarchical information in SQL
Lennart Jonsson
Taurus
Tuesday, 11 November
  DB2 11 for z/OS DB2 for z/OS II DB2 10.5 for LUW DB2 for LUW II Analytics &
Big Data
Application
Development
08:30
-
10:00
DB2 trends and directions
Namik Hrle, Paul Zikopoulos
Nadir & Zenit
  10:00 - 10:15 Coffee Break
10:15
-
11:15
[A5] What's new from the optimizer in DB2 11 for z/OS?
Terry Purcell
 Tycho
[B5] Archiving data – DB2 comes to the rescue (twice)
Steve Thomas
Kepler
[C5] SQL Enhancements for DB2 LUW
Steve La
Leo
[D5] DB2 Survival Training
Thomas Kalb and Mathias Hoffmann
Virgo
[E5] Configuration (Mis) Management - Deploying DDL changes
Ken Shaffer
Aquarius
[F5] Temporal SQL Designs : Practical Experiences
Philip Nelson
Taurus
11:30
-
12:30
Vendor Solution Presentations
  12:30 - 14:00 Lunch
14:00
-
15:00
[A6] DB2 11 for z/OS Performance Topics
Jeffrey Berger and Cristian Molaro
 Tycho
[B6] Tuning zIIPs for Fun and Profit
Julian Stuhler
Kepler
[C6] ADMIN_MOVE_TABLE(): Why would a DBA move a table? (Waiter As A Second Job?)
Andrej Furlanič
Leo
[D6] A DB2 DBA’s Guide to pureScale
Kelly Schlamb
Virgo
[E6] Herd your chickens: Ansible for DB2 configuration management
Frederik Engelen
Aquarius
[F6] Advanced pureXML Enhancements in IBM DB2 11 for z/OS
Jane Man
Taurus
15:15
-
16:15
[A7] 11 Tips for DB2 11 for z/OS
Cuneyt Goksu
 Tycho
[B7] Migrating from IMS to DB2 with DL/2
Bernie O'Connor
Kepler
[C7] Getting the most out of DB2's BLU Acceleration: How to populate columnar tables easily and efficiently!
Adam Storm
Leo
[D7] Best Practices for Achieving Reliable Query Performance
John Hornibrook
Virgo
[E7] IBM Data Retrieval Technologies: RDBMS, BLU, IBM Netezza, and Hadoop
Frank Fillmore
Aquarius
[F7] SQL stored procedures, why, when and how?
Kurt Struyf
Taurus
  16:15 - 16:30 Coffee Break
16:30
-
17:30
[A8] DB2 11 internals changes that system DBA must know
Ken McDonald
 Tycho
[B8] The Weakest Link in DB2
Isaac Yassin
Kepler
[C8] High availability disaster recovery and performance – a marriage made in heaven
Dale Mcinnis
Leo
[D8] The Latest in Advanced Performance Diagnostics for SQL
David Kalmuk
Virgo
[E8] Hadoop and DB2 11 just got engaged! How long before the wedding?
Emil Kotrc
Aquarius
[F8] DB2 Rules Of Thumb
Svenn-Aage Soenderskov
Taurus
Wednesday, 12 November
  DB2 11 for z/OS DB2 for z/OS II DB2 10.5 for LUW DB2 for LUW II Analytics &
Big Data
Application
Development
08:30
-
09:30
[A9] DB2 11 - Application Compatibility (APPLCOMPAT)
Chris Crone
 Tycho
[B9] DB2 for z/OS Trends and Directions
John Campbell
Kepler
[C9] THE BI Blu’s
Jill Anderson
Leo
[D9] Getting Top Performance from DB2 pureScale - An Application Migration Guide
Steve Rees
Virgo
[E9] NoSQL and DB2 - How to get the most out of both
Jane Man
Aquarius
[F9] How to save REAL money with SQL Tuning
Phil Grainger
Taurus
09:45
-
10:45
[A10] DB2 11 for z/OS - Application Enablement, Rollout & Experiences
Jörg Maier and Bernd Kohler
 Tycho
[B10] Experiences from applying RELEASE(DEALLOCATE)
Pawel Hryb
Kepler
[C10] DB2 10.5 New Features - A Query Optimizer Perspective
John Hornibrook
Leo
[D10] DB2 LUW in 2014 : The Latest from the Lab
Matt Huras
Virgo
[E10] Generic design is generic performance can be good!
Marc van der Valk
Aquarius
[F10] DB2 SQL/PL Tips, Tricks, and Bloopers
Elwin Harrison
Taurus
  10:45 - 11:00 Coffee Break
11:00
-
12:00
[A11] Transforming DB2 for z/OS Management with Advanced Autonomics
Haakon Roberts
 Tycho
[B11] SYSLGRNX from darkness to light
Alain Pary
Kepler
[C11] Monitoring BLU Acceleration In-Depth
David Kalmuk
Leo
[D11] DB2 LUW Performance FAQs: Wait ... Tell me that again?
Steve Rees
Virgo
[E11] Big Data – get familiar with Hadoop to use your unstructured data
Udo Brede
Aquarius
[F11] Parlez-vous Klingon - DB2 Recursion SQL for Database Magicians
Alexander Kopac
Taurus
  12:00 - 13:15 Lunch
13:15
-
14:15
Expert Panel for z/OS
Tycho & Kepler
Expert Panel for LUW
Leo & Virgo
14:30
-
15:30
[A12] Access Path Repository: The new Hints in DB2 10 and What is new in DB2 11
Ramon Menendez
 Tycho
[B12] How to Enable High Availability for distributed DB2 z/OS workloads
Paul Stoker
Kepler
[C12] Tuning SAP with DB2 for LUW
Martin Hubel
Leo
[D12] DB2 and Datastage - What about this successful team?
Michael Tiefenbacher
Virgo
[E12] The power of DB2 - more than just tables, views and indexes
Paul Murray
Aquarius
[F12] Application development goodies - what’s HOT in DB2 10 and 11 – make your favorite DBA love You !!
Steen Rasmussen
Taurus
  15:30 - 15:45 Coffee Break
15:45
-
16:45
[A13] What’s new about buffer management using DB2 11 for z/OS
Jeffrey Berger
 Tycho
[B13] Present and Future of Large Memory with DB2 for z/OS
John Campbell
Kepler
[C13] Shadow Tables To Speed Up Analytic Queries In Your OLTP Environment
Steve La
Leo
[D13] Performance "Worst Practices" for DB2 LUW
Steve Rees
Virgo
[E13] To Do IT(IL) or Not ...
Zeljen Stanic
Aquarius
[F13] Attack of the Blob! (Managing BLOBs within a DB2 database)
Michael Krafick
Taurus
17:00
-
18:00
[A14] The DB2 11 catalog – something new, something old, something changed
Steen Rasmussen
Taurus
[B14] Partitioning and indexing - query performance considerations
Terry Purcell
Kepler
[C14] Better than in-memory - How BLU Acceleration Keeps Performance High When Memory is Runing Low
Gopi Attaluri
Leo
[D14] New lessons learned by setting-up and querying the Protein Data Bank with DB2
Gerd Anders
Virgo
[E14] Database Statistics - good practices not only for experienced administrators
Jacek Rafalak
Aquarius
[F14] Fun with SQL
Daniel Luksetich and Kurt Struyf
Tycho
Thursday, 13 November
  DB2 11 for z/OS DB2 for z/OS II DB2 10.5 for LUW DB2 for LUW II Analytics &
Big Data
Application
Development
08:30
-
09:30
[A15] Setting Yourself Up for Success with DB2 11 Extended LRSN / RBA Support
Michael Dewert
Tycho
[B15] Where is the Problem in My z/OS Transaction?
Martin Hubel
Kepler
[C15] Experiences using BLU Acceleration with a financial Risk Management system
Philip Källander
Leo
[D15] DB2 HADR Automation, where is the magic?
Danny Arnold and Dale Mcinnis
Virgo
[E15] Auditing DB2 Tables Cross-Platform
Daniel Luksetich
Aquarius
[F15] IBM DevOps: a collaborative approach for continuous software delivery
Loic Julien
Taurus
09:45
-
10:45
[A16] Hit The Ground Running with DB2 11 Features!
Lori Ann Galluzzo
Tycho
[B16] Let's talk recovery
Florence Dubois
Kepler
[C16] Access Paths for DB2 V10.5 Column-based tables – what is the optimizer not telling us?
Mark Gillis
Leo
[D16] What’s Brewing at MetLife – A Choice Blend to Deepen DB2 LUW Value
Susan Sterling
Virgo
[E16] Can migration from DB2 for z/OS to DB2 for LUW be easy?
Adam Pesta
Aquarius
[F16] Java Application Performance on DB2 for z/OS
Ludovic Janssens
Taurus
  10:45 - 11:15 Coffee Break
11:15
-
12:15
[A17] Partitioning strategy and space management best practice
Frances Villafuerte
Tycho
[B17] EXPLAIN Yourself and Improve DB2 Performance!
Jim Dee
Kepler
[C17] The Latest and Greatest on DB2 pureScale: Highlights of New Features & Enhancements in DB2 10.5 and Fix Packs
Kelly Schlamb
Leo
[D17] A Deep Dive into Jump Scan: How Does it Work and What Can it Do
Gopi Attaluri
Virgo
[E17] Backup and Clone your (LUW) Database in a Snap
Philip Nelson
Aquarius
[F17] XML and JSON: Guidelines and Examples for DB2 z/OS
Jane Man
Taurus
12:30
-
13:30
Closing keynote/session: Information Strategy: More than just data priorities
Jan Henderyckx
Nadir & Zenit
Friday, 14 November (additional fee applies)
  Full Day Seminar A Full Day Seminar B Full Day Seminar C Full Day Seminar D
09:00
-
12:00
[ODS1] Understanding DB2 accounting information - "The full monty"
Bart Steegmans
Virgo
[ODS2] Advanced SQL Coding and Performance
Daniel Luksetich
Leo
[ODS3] DB2 LUW Problem Determination and Troubleshooting Workshop
Pavel Sustr and Anthony Reina
Aquarius
[ODS4] DB2 for LUW Practical Performance
Martin Hubel
Taurus
  12:00 - 13:00 Lunch
13:00
-
17:00
[ODS1] Understanding DB2 accounting information - "The full monty"
Bart Steegmans
Virgo
[ODS2] Advanced SQL Coding and Performance
Daniel Luksetich
Leo
[ODS3] DB2 LUW Problem Determination and Troubleshooting Workshop
Pavel Sustr and Anthony Reina
Aquarius
[ODS4] DB2 for LUW Practical Performance
Martin Hubel
Taurus