Monday, 16 November
  DB2 for z/OS I DB2 for z/OS II DB2 for LUW I  DB2 for LUW II

App Dev &

Analytics I

App Dev &

 Analytics II

08:30
-
09:00

Opening

Lansdowne Suite
09:00
-
10:00
Disruption and innovation: its effect on the database and vice versa 

Philip Howard
Lansdowne Suite
 
10:15
-
11:15

[A1] DB2 and System z - The Latest on Technical Synergy

Chris Crone 
Lansdowne Suite

[B1] DB2 for z/OS, get started on the system!! System administration for DBAs

Kurt Struyf
Ulster

CHANGED!

[C1] What's New in BLU: Tips and Insights on the Newest Breakthroughs

Matthias Nicola
Author: Sam Lightstone
Munster

[D1] Advanced Performance Diagnostics for SQL

David Kalmuk
Leinster

 

[E1] SQL for the 21st Century: Overlooked Enhancements

David Simpson
Meeting Room1/2

[F1] What's in a Module?

Steve La 
Meeting room 6
  11:15 - 11:30 Coffee Break
11:30
-
12:30

[A2] Getting the Best Query Performance in DB2 11 for z/OS

Kewei Wei 
Lansdowne Suite

[B2] Too Many Fights in Your Marriage with Runstats – Get Your Life Back

Steen Rasmussen
Ulster

[C2] Doing the Long Jump : Upgrading DB2 (for LUW) By Four Releases in One Step

Philip Nelson 
Munster

[D2] Facilitate WLM Functions and Tools to Improve Your Monitoring

Michael Tiefenbacher
Leinster

[E2] What I Could Have Used Instead of Triggers

Paul Ruane
Meeting room 6

[F2] Discover the New Data Server Manager

Saghi Amirsoleymani
Meeting Room 1/2
  12:30 - 13:15 Lunch - Sussex 1/2
13:15
-
14:15

V01: BMC Next Generation Technology for DB2 – The New Paradigm

Lutz Becker

Gothaer Systems

Phil Grainger
BMC Software

Ulster

V02: Big Iron/Big Data: Big Headaches or Big Deal?

Marcel den Hartog
CA Technologies

Munster

V03: IBM DB2 BigXML Data Analytics Using Hadoop Framework for DB2’s Large Scale XML Data Processing

George Wang
IBM Corporation
Leinster

V04: Efficient Auditing of DB2 for z/OS and LUW with Imperva SecureSphere

William Arledge
Imperva

Meeting Room 1/2
14:30
-
15:30

[A3]  Conquer Your Fears. Episode 1 - Fear of REBIND

Bart Steegmans
Lansdowne Suite

[B3] DB2 Data Sharing Group - Deleting Quiesced Members : Things Can Happen !

Jarmo Männikkö
Ulster

[C3] DB2 Memory Management -- Have You Lost Your Memory?

Melanie Stopfer 
Munster

[D3] Setting Up the Most Reliable PureScale Cluster

Steve Rees
Leinster

[E3] Leveraging Data Studio to Test Database Application Code

Ben Anderson 
Meeting room 6

[F3] SQL Refinements Since SQL92, How to Improve Both Efficiency and Readability of Your Code by Understanding Constructions Beyond SQL92

Lennart Jonsson
Meeting Room 1/2
  15:30 - 15:45 Coffee Break
15:45
-
16:45

[A4] DASD for DBAs – The Stuff You Need To Know

Julian Stuhler 
Lansdowne Suite

[B4]  DB2 11 for z/OS Data Sharing and Availability Enhancements

John Campbell
Ulster

[C4] DB2 PureScale for the Economically-Minded

Kelly Schlamb
Munster

[D4]  The 5 W's of DB2 Database Encryption

Ian Bjorhovde
Leinster

[E4]A Tricky Conversion with Just (Advanced?) 

 Sirpa Vepsa 
Meeting room 6

[F4] Changing Your Relational Mindset to Get the Most Out of Big SQL

Eugen Stoianovici
Meeting Room 1/2
17:00
-
18:00

[A5] DB2 for z/OS - Backup and Recover in a Flash

Bryan Paulsen 
Ulster

[B5] DB2 11 for z/OS Performance Topics

Jeffrey Berger 
Lansdowne Suite

[C5] Shadow Tables – CDC or No CDC: The Pros and Cons

Mark Gillis 
Munster

[D5] DB2 Battle: Statement Concentrator vs. Optimization Profile

Henrik Loeser 
Leinster

[E5] Analyze youR data (with R)

Emil Kotrc 
Meeting room 6

[F5] Learning Exciting JSON Features in DB2 for z/OS

Jane Man
Meeting Room 1/2
Tuesday, 17 November
  DB2 for z/OS I DB2 for z/OS II DB2 for LUW I DB2 for LUW II

App Dev &

Analytics I

App Dev &

Analytics II

Spark
08:30
-
10:00
DB2 Trends and Directions
John Campbell
DB2 LUW and dashDB Trends and Directions
Berni Schiefer
Lansdowne Suite
  10:00 - 10:15 Coffee Break
10:15
-
11:15

[A6] Optimizing Complex Queries, Optimizing Analytics on DB2 for z/OS

Kewei Wei
Meeting Room 6

[B6]  DB2 Utilities Update

Haakon Roberts
Lansdowne Suite

[C6] Block Party! Techniques for Tuning DB2 LUW Buffer Pools

Martin Hubel 
Munster

[D6]  Run Your Data Warehouse with BLU in the Cloud

Ian Bjorhovde
Meeting Room 2

[E6] Taking Advantage of DB2’s Advanced SQL Features

Daniel Luksetich
Ulster

[F6] DB2 for z/OS in a Service Oriented Architecture

 Ludovic Janssens
Meeting Room 1

[G6] Apache Spark: What's in It for Your Business?

Chris Fregly  
Meeting Room 2
11:30
-
12:30

V05: Real Time DB2 to Big Data


Scott Quillicy
Infotel

Ulster

V06: DB2 LUW Performance Tips and Tricks Your Hardware & Software Vendors Don’t Want You to Know

Scott Richard Hayes
DBI Software
Munster

V07: 25 Years of Missed Opportunities? SQL Tuning Revisited


Roy Boxwell
SOFTWARE ENGINEERING GmbH
Leinster
  12:30 - 14:00 Lunch -  Pembroke/Hebert
14:00
-
15:00

[A7] Customer Query Performance Experiences and DB2 Development Answers

Walter Janißen
Kewei Wei
Ulster

[B7] Exploiting Larger Real Memory Size with DB2 for z/OS to Reduce CPU Resource Consumption and Improve Application Elapsed Time

John Campbell  
Lansdowne Suite

[C7] Handyman's Cheatsheet for Common Monitoring Questions

Steve Rees
Author: Paul Bird 
Munster

[D7] Best Practices for Minimizing and Eliminating Planned Outages with DB2 LUW

Matt Huras 
Leinster

[E7] Hadoop and DB2 11 - Both Sides of the Story

Emil Kotrc
Meeting room 6

[F7] I'm a DBA not a Developer! - With Apologies to Dr. Leonard McCoy

Ken Shaffer
Meeting Room 1

[G7] Apache Spark: What’s Under the Hood?

Chris Fregly
Meeting Room 2
 
15:15
-
16:15

[A8] Tuning with Virtual Indexes - A Brute-Force-Approach

Rolf Drees 
Lansdowne Suite

[B8]  Lost without a trace

Denis Tronin
Ulster

CHANGED!

[C8] To BLU or Not to BLU, Some Examples Where ROW Beats COL

Mika Lindholm
Munster

[D8] Zen and the Art of Database Performance

Steve Rees 
Leinster

[E8]  DB2 Text Search - In Action!

Somu Chakrabarty
Meeting Room 6

[F8] Build a DB2 for z/OS Mobile Application

Jane Man
Meeting Room 1

[G8] Using Apache Spark With DB2 for z/OS and z Systems Data

Eberhard Heckler 
Meeting Room 2
  16:15 - 16:30 Coffee Break
16:30
-
17:30

[A9] DB2 11 for z/OS SQL Enhancements

Chris Crone
Lansdowne Suite

[B9] Everything You Wanted to Know About DB2 Prefetch

Jeffrey Berger 
Ulster

[C9] MPP Cluster Scale-out for BLU Acceleration in dashDB

David Kalmuk
Author: Sam Lightstone 
Munster

[D9] DB2 BLU: Concepts and Best Practices

Matt Huras 
Leinster

[E9] Our Road to Success with the DB2 Analytics Accelerator

Roberta Barnabe 
Meeting Room 6

[F9] Features Lost in Documentation

Steve La
Meeting Room 1

[G9] Apache Spark and DB2 BLU: Making ‘People Flow’ in Cities Measurable and Analyzable

Peter Kohlman
Meeting Room 2
Wednesday, 18 November
  DB2 for z/OS I DB2 for z/OS II DB2 for LUW I DB2 for LUW II

App Dev &

Analytics I

App Dev &

Analytics II

08:30
-
09:30

[A10] Using Thread reuse and RELEASE (DEALLOCATE) to achieve performance gains

John Campbell
Lansdowne Suite

[B10] VW experience in using digital certificates to access DB2 for z/OS

James Pickel 
Ulster

[C10] Useful TSM secrets for the DB2 admin

Gerd Anders 
Munster

[D10] More Sage Advice: Invaluable DB2 LUW Performance Insights from Around the Globe

Scott Hayes 
Leinster

[E10] Is IDAA Tuning Worth It?

Thomas Baumann 
Meeting Room 6

[F10] Migrate Your IMS Transaction into a DB2 LUW Stored Procedure...

Anders Bergh
Meeting Room 1/2
09:45
-
10:45

[A11] Distributed Workload Balancing - Myth or Legend?

Gareth Jones
Lansdowne Suite

[B11] DB2 z/OS Performance & Tuning (It's All About The SQL)

Michael Wingfield 
Ulster

[C11] Take a Hint with DB2 for Linux, UNIX and Windows Optimization Profiles

John Hornibrook
Munster

[D11] Lessons Learned from a Successful Warehouse Move to BLU

Leo Pedron
Leinster

[E11]  IBM DB2 Analytics Accelerator VNext Beta Customer Experiences

Patric Becker
Meeting Room 6

[F11] How We code SQL - Does it matter?

Jacek Rafalak
Michal Bialecki 
Meeting Room 1/2
  10:45 - 11:00 Coffee Break
11:00
-
12:00

[A12] Recent DB2 for z/OS Customer Pain Points and How to Address Them

Bart Steegmans 
Lansdowne Suite

[B12] Real Customer DB2 for z/OS Version 11 Experiences and Interesting Things to Know about

Ute Kleyensteuber 
Ulster

[C12] Peeking through the middleware curtain

Matthias Nicola
Munster

[D12] DB2 BLU Acceleration: Best Practices and Lessons from the Field

David Kalmuk 
Leinster

[E12] XML - Essentials for the DB2 z/OS DBA

Thanikachalam "Billy" Sundarrajan 
Meeting Room 6

[F12] DB2 Test Data Management Using IBM OPTIM TDM – Migration Case Study

Frank Petersen
Meeting Room 1/2
  12:00 - 13:15 Lunch
13:15
-
14:15

z/OS Expert Panel

John Campbell, Thomas Baumann, Cristian Molaro, Maryela Weihrauch, Julian Stuhler, Peter Bendel
Lansdowne Suite

LUW Expert Panel

Matt Huras, Steve Rees, Melanie Stopfer, Kelly Schlamb, Ian Bjorhovde, Fred Sobotka, Chris Eaton 
Ulster

Application Development Expert Panel

Matthias Nicola, Daniel Luksetich, Cris Crone, Philip Nelson, Ludovic Janssens, Jane Man 
Munster
14:30
-
15:30

[A13] Recovery Tales from Experience

Ken McDonald 
Lansdowne Suite

[B13] Joining Data - A Performance Marriage from Heaven or a Divorce Waiting to Happen

Paul Murray 
Ulster

[C13] Materialized Query Tables - Deep Dive

Melanie Stopfer
Munster

[D13] DB2 Resiliency for DBaaS in IBM's Cloud Offerings

Dale Mcinnis 
Leinster

[E13] Tune My Queries But Do Not Touch Them!

Thomas Baumann 
Meeting Room 6

[F13] What a DBA Needs to Know about Distributed Shells and SSH

Larry Sokoloski 
Meeting Room 1/2
  15:30 - 15:45 Coffee Break
15:45
-
16:45

[A14] Explain Yourself and Improve DB2 Performance!

 Jim Dee 
Lansdowne Suite

[B14]  DB2 11 and z13 for Hybrid Transactional and Analytical Applications

Johannes Schuetzner
Ulster

[C14] DB2 BLU Acceleration and the BaFin Analytic Data Warehouse

Olaf Stephan
Munster

[D14] DB2: Partition Like a Magician!

Enda McCallig 
Leinster

[E14] Fun with SQL

Kurt  Struyf
Meeting Room 6

[F14] DB2 Maintenance Implementation Across 112 Subsystems

Neil Dyer
Meeting Room 1/2
17:00
-
18:00

[A15] Copying Data with Pipes

Ludovic Janssens
Lansdowne Suite

[B15] A Deep Dive in Ways to Protect Your Mainframe Data in DB2

James Pickel
Ulster

[C15]  Hidden Gems: The Top 10 Most Under-Utilized Functions in DB2

Matthias Nicola
Munster

[D15] DB2 LUW Performance FAQs, volume 5 - Solving More Puzzles!

Steve Rees
Leinster

[E15] How to Fall in Love with XML in DB2 for z/OS - The Real Customer Experience!

Mattia Michelazzo 
Meeting Room 6

[F15] Enriching Insight on DB2 for z/OS by Leveraging Hadoop

Eberhard Hechler 
Meeting Room 1/2
Thursday, 19 November
  DB2 for z/OS I DB2 for z/OS II DB2 for LUW I DB2 for LUW II

App Dev &

Analytics I

App Dev &

Analytics II

08:00
-
09:00

[A16] Are You Getting the Most Value from RTS?

Steve Thomas
Lansdowne Suite

 

[B16] How to Gain Insight on DB2 Performance Using IDAA

Timm Zimmermann 
Leinster

[C16]  Top Ten DB2 for Linux, UNIX and Windows Query Access Plan Tuning

John Hornibrook
Meeting Room 1

[D16] How to Rebalance Your Workload Using DB2 Utilities

Dale Mcinnis 
Meeting Room 2

[E16] Trusted Context and Roles - How Are You Serving Up Your Security?

Daniel Lohmeier
Meeting Room 6

[F16] Beyond Query Acceleration: New Use Cases for DB2 Analytics Accelerator for z/OS

Peter Bendel
Meeting Room 18
09:15
-
10:15

[A17] How To Extract Data From The Dynamic Statement Cache And Really Use

Gareth Jones 
Ulster/Munster

[B17] Flashcopy, Truecopy, Timefinder, Oh My!

Dennis Jones 
Leinster

[C17] Demystifying Logging & Recovery in DB2 LUW

Kelly Schlamb 
Meeting Room 1

[D17] DB2 Security Unscrambled

Henrik Loeser
Meeting Room 2

[E17] Temporal and Recursive - Has SQL Gone Crazy?

Phil Grainger
Meeting Room 6

[F17] DB2 Stored Procedures - The Good, the Bad and the Ugly

Lauri Pietarinen
Meeting Room 18
  10:15 - 10:30 Coffee Break
10:30
-
12:00
A Perfect Storm: Challenges of the Digital Tomorrow
Jonathan Adams
Ulster/Munste/Leinster
 
13:00
-
17:00

[WS1] Fast Start! DB2 for z/OS Application Development Topics 

Gareth Jones
Meeting Room 18

 

[WS2] DB2 for z/OS and Cloud Computing 

Maryela Weihrauch
Kewei Wei 
Meeting Room 1

[WS3] DB2 in the Cloud Hands on Workshop 

Chris Eaton 
Meeting Room 2

 

[WS4] DB2 LUW Basic Administration 

Saeid Mohseni 
Meeting Room 9

[WS5] IBM DB2 Analytics Accelerator Architecture Workshop

Patric Becker
Peter Bendel
Meeting Room 6

 

Friday, 20 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] DB2 Advanced Programming, Automation, and Performance

Daniel Luksetich
Meeting Room 1

[ODS2] DB2 for z/OS fundamentals, explaining what everybody expects you to know

Kurt Struyf
Meeting Room 9

[ODS3] OMG! Experience is a Hard Teacher – Lessons Learned that You Should Know!

Melanie Stopfer 
Meeting Room 2

[ODS4] DB2 LUW Problem Determination and Troubleshooting Workshop

Pavel Sustr
Anthony Reina 
Meeting Room 6
  12:00 - 13:00 Lunch
13:00
-
17:00

[ODS1] DB2 Advanced Programming, Automation, and Performance

Daniel Luksetich
Meeting Room 1

[ODS2] DB2 for z/OS fundamentals, explaining what everybody expects you to know

Kurt Struyf
Meeting Room 9
 

[ODS3] OMG! Experience is a Hard Teacher – Lessons Learned that You Should Know!

Melanie Stopfer 
Meeting Room 2

 

[ODS4] DB2 LUW Problem Determination and Troubleshooting Workshop

Pavel Sustr
Anthony Reina
Meeting Room 6