Seminar Program

Date: May 11, 2016 - Seminar Agenda

Location: The Crowne Plaza Hotel , Novi Michigan

8:15am - 9:00am Check In / Continental Breakfast
9:00 am - 9:05 am Meeting kickoff and Opening Remarks
9:05 am - 10:20 am "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
Speaker: Robert Catterall (IBM)
Download "Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)"
10:20 am - 10:40 am Break
10:40 am - 12:00 pm "DB2 for z/OS Distributed Data Facility Questions -- and Answers"
Speaker: Robert Catterall (IBM)
Download "DB2 for z/OS Distributed Data Facility Questions -- and Answers"
12:00 pm - 1:00 pm Lunch - included as part of the seminar
1:00 pm - 2:15 pm "Query Optimization and Performance in DB2 11 for z/OS"
Speaker: Troy Coleman (IBM)
Download "Query Optimization and Performance in DB2 11 for z/OS"
2:15 pm - 2:30 pm Break
2:30 pm - 3:45 pm "DB2 for Linux on System Z"
Speaker: Troy Coleman (IBM)
Download "DB2 for Linux on System Z"


Presentation Abstracts

Presentation #1:

Robert Catterall (IBM) Let Me Make This Clear (Things That Plenty of DB2 for z/OS People Get Wrong)


Some aspects of DB2 for z/OS technology are plain as day; others, less so. Questions I get from DB2 users worldwide have highlighted for me things that a lot of folks - even very experienced DB2 people - get wrong. In this session I'll try to bring clarity to oft-misunderstood areas of DB2 for z/OS technology.

Presentation #2:

Robert Catterall (IBM) DB2 for z/OS Distributed Data Facility Questions -- and Answers


The DB2 distributed data facility (DDF) is, increasingly, the primary channel through which DB2 for z/OS data is accessed. As DB2 people deal with the growing volume and variety of DDF workloads, associated questions come to the fore. How do you effectively monitor DDF activity? How should DDF-using applications be architected? How can a DDF workload be managed and controlled? How do I secure data accessed via DDF? This session will provide answers to these and related DDF questions -- questions asked by real users in the real world.

Presentation #3:

Troy Coleman (IBM) Query Optimization and performance in DB2 11 for z/OS


Query performance and optimization are critical to total cost of ownership for DB2 for z/OS applications. 12 months after GA, learn about the latest updates and feedback about the DB2 11 enhancements to query performance and optimization. DB2 11 for z/OS is packed with query performance improvements - predicate rewrites to improve indexability, hash join optimizations, duplicate removal enhancements, DPSIs, subqueries ... If you are interested in improving performance for your DB2 applications, then don't miss this session.

Presentation #4:

Troy Coleman (IBM) DB2 for Linux on System Z


Come learn about the power and benefits of running DB2 LUW on Linux for System z. This presentation will look at the 16 year history, including the latest advances in DB2 technology. This session will show the advantages of DB2 BLU acceleration when running on z13 hardware. Learn new ways to exploit using your mainframe and DB2.


Speaker Biographies

Robert Catterall (IBM)
Robert Catterall works for IBM as a Senior Consulting DB2 for z/OS specialist. He started his IT career with IBM in 1982, and worked throughout the 1990s as a member of the Company's DB2 for z/OS National Technical Support team. From 2000 to 2007, Robert worked as a database technology strategist for CheckFree (now part of Fiserv). After working for three years as an independent DB2 consultant, he rejoined IBM in 2010. Robert is a past President of IDUG, and a member of IDUG's Speakers Hall of Fame. He presents frequently at conferences, and blogs about DB2 for z/OS at

Troy Coleman (IBM)
Troy Coleman is currently an IBM DB2 Advisor for z/OS. He brings a variety of skills focused around DB2: product management, DB2 systems programmer, installing and configuring DB2, application DBA, and application developer. Troy writes a weekly DB2 for z/OS blog for IBM Systems Magazine called DB2utor. Troy has been active in the DB2 community as a board member for the Chicago Midwest Database User Group (MWDUG) and as a former board member of IDUG. He holds the prestigious title of IBM Information Management Champion from 2011-2015. He is an internationally recognized consultant and lecturer specializing in DB2 database administration and application architecture. Troy has experience on many leading hardware platforms, including DB2 for z/OS, Windows, AIX, Solaris and Linux. Troy was the architect and lead developer of the first wireless database management software for DB2 UDB, PocketDBA, by Expand Beyond Corp.