Conference Agenda

Check out the full list of confirmed sessions for the North America Db2 Tech Conference organized by track or by day below. You can also download a PDF of the current grid. Session descriptions can be found on the track pages. 

Conference attendees - live sessions can be viewed on each track page at their allotted time. Link from the daily agenda page or click on the track page icons below to join the sessions. 

Db2 for z/OS Track One

Db2 for z/OS Track Two

Db2 for LUW Track One

Db2 for LUW Track Two

Developers Track

on_demand.png

On Demand Sessions

Week Two


Monday    Tuesday    Wednesday     


Monday, June 7


10:30 AM EDT

Conference Welcome and Opening Keynote address

IBM Db2 Vision and Future

Db2 for z/OS - Accelerating Enterprise AI and Cloud Leadership 

Db2 for z/OS is the best-in-class hybrid cloud server, adapting to support new hybrid cloud applications and workloads while continuing to meet transaction processing expectations. Db2 for z/OS will continue to deliver secure, reliable, direct access to systems of record and offer embedded AI acceleration for highly efficient IT operations within the hybrid cloud. The key to future value will be the ability for Db2 for z/OS to both inform and be informed by its ecosystem.

Join Sharon Cocco, VP Development, Db2 for z/OS and Regtech, to hear how Db2 for z/OS is supporting your organization’s hybrid cloud and AI journey now and into the future.

Sharon Cocco

IBM VP Data and AI on IBM Z & RegTech

Challenges and Opportunities in Hybrid Data Management 

What is Hybrid Data Management doing to help clients deal with the current environment and challenges? Come learn about latest features in our world-class database offerings released in 2020, our vision, and our roadmap into the future.

Vikram Murali is vice president of Hybrid Data Management which includes Db2, Netezza, and Cloud Pak for Data (CP4D) Systems development within IBM Data and AI.

Vikram Murali

IBM Vice President
11:45 AM EDT
z track image
Db2 for z/OS Spotlight Session:
Future of Db2 for z/OS: The Latest Updates from the Lab

Maureen Townsend, IBM
11:45 AM EDT
luw track image

Db2 (LUW) Spotlight Session

Keri Romanufa & Piotr Mierzejewski, IBM

1:10 PM EDT


Session 1

2:10 p.m. EDT
 Spring Cleaning – Efficient Ways of Removing Data and Purging Best Practices
 Scott Walker, Navy Federal Credit Union
Taming Python and Db2 for z/OS
  Jørn Thyssen, Rocket Software

Understanding the Recipe for Near Real-Time Data Delivery Using Q-Replication
Aish Khare, Xtivia Inc. 
The Db2 Access Plan Troubleshooting Handbook
John Hornibrook, IBM
 A World Beyond Data
 Marcel Hartog, denNS Nederlandse Spoorwegen

Session 2

3:20 p.m. EDT

 Db2 For z/OS Index Performance Recommendations
  Daniel Luksetich, DanL Database Consulting
 JC Greatest Hits, War Stories, & Best Practices: Part 1
John Campbell, IBM
 A "TSA-Less" Db2 Integrated Solution for Automated Failover to HADR Standby
 Gerry Sommerville, IBM 
 Unstoppable Force vs. Immovable Object: DevOps and the DBA
  Michael Krafick, Sherwin-Williams
 Db2 Schema Management in a DevOps World Using Git
 Mark Turner, Natwest Group

Session 3

4:30 p.m. EDT

 Optimization Hints Grow Up
 Chad Reiber, BMC Software
 JC Greatest Hits, War Stories, & Best Practices: Part 2
 John Campbell, IBM
 Db2 AIX to RHEL X86 Migration
 Dale McInnis, IBM 
 Db2's External Tables: A Deep Dive
 Mike Springgay, IBM
 Db2 Batch Processing with Spring Batch
 David Morris, Leidos

back to top

Tuesday, June 8

10:30 am EDT

Rocket Software Keynote address

Optimizing Db2 for z/OS Application Development and Administration

As a database administrator, systems programmer, or an application developer, how do you enable the need to support faster innovation cycles while maintaining quality and stability, and onboarding those building new skills?

Tim Willging, VP and chief architect, Rocket Software, and Paul Bartak, distinguished engineer, Rocket Software, team up in this visionary keynote to share ideas, strategies, and innovations that allow you to support greater agility across Db2 administration and development. With superior automation, intelligent assistance, and optimized user experiences, you will have the tools to align and elevate Db2 for z/OS with your enterprise’s broader innovation initiatives.

Whether you are an expert, or an early career professional, please join us for this session.

Tim Willging

VP and Chief Architect, Rocket Software

Paul Bartak

Distinguished Engineer, Rocket Software

Session 4

11:25 a.m. EDT

 Optimizing Data Transformation with Db2 for z/OS and Db2 Analytics Accelerator
 Maryela Weihrauch, IBM
 A Very Untraditional Approach Implementing Schema Changes!
  Steen Rasmussen, Broadcom
 Db2 with Spatial Analytics
 Christian Zentgraf, IBM
 Lessons Learned While Migrating our Db2 Systems From 9.7 (on AIX ) to 11.1 (on Linux )
 Özgür Armağan, AvivaSA Life and Pension
 Data Gate: Current and Consistent Db2 for z/OS Data on Any Cloud
 Daniel Martin, IBM

Session 5

12:35 p.m. EDT

 Are You Happy or Are You Still Deprecated?
 Roy Boxwell, Software Engineering GmbH
 The Latest Real Customer Experiences With Db2 12
  Ute Kleyensteuber, Commerzbank AG
 Monitoring and Optimizing Db2 Prefetching and I/O
 Christopher Drexelius, IBM
 Disaster - Oh No! What Now?
 Olaf Stephan, BaFin
 Go Db2 - Use Go Language to Develop IBM Db2 Database Applications
 Andreas Christian

Vendor Sponsored Presentations

1:45 p.m. EDT

Please note that the VSPs do not follow the same track designations as other sessions. Though they may be slotted to a track-specific room, you’ll need to check the VSP session titles and information to determine whether the technology and topics are relevant to you. Check the daily agenda page to see which room to join. 
 Imagine How Much You Can Learn Exploring Db2 Statistics Data 
 Todd Havekost, Intellimagic
 Db2 z/OS Tools Trends & Directions: DevOps, AIOps, Data Protection 
  Chris Crone, Broadcom
 New Ideas for DBA’s to Manage Data as a Capital Asset
  Bob Bersano, Rocket Software
 World-class Db2 DataOps for the Autonomous Digital Enterprise
 John Barry, BMC
 Db2 - State of the Nation Strategy Update
 Les King, IBM

Session 6

2:55 p.m. EDT

 Newton's 3rd Law of Motion: Techniques for Addressing ++HOLDDATA
 SMike Toppins
 Using Db2 Stored Procedures and REST Services
 Tom Ulveman Jensen, Rocket Software
 Db2 Support Tools for Db2 Warehouse and the IBM Integrated Analytics System (IIAS)
  James Sobieski, Fourth Millennium Technologies
 The Data Pioneer: Recovery
  Martin Hubel, MHC Inc.
  -805 Explained
  Emil Kotrc, Broadcom

3:35 PM EDT


Session 7

4:35 p.m. EDT

 Db2 Trivia and Reasoning – It Is All So Obvious in Hindsight
  Brian Laube, Manulife Financial
 Db2 for z/OS Utilities - The Latest News
 Haakon Roberts, IBM
 Improving ETL Performance
 Calisto Zuzarte, IBM
 A Db2 Security Primer (Updated)
 Paul Bird, IBM
  Db2 Java Performance Best Practices
  Dave Beulke, Dave Beulke and Associates

back to top

Wednesday, June 9

10:30 AM EDT

Broadcom Keynote address

MainframeFlix for your Education Fix

Attend this keynote session to have some fun and discover new ways to amplify the value of your mainframe investment while also making your day-to-day life working with Db2 for z/OS easier. Get a sneak peek of binge-worthy sessions available through the IDUG NA conference Expo portal and what will sure to be the most talked-about mainframe education of the season.
Greg Lotko
Senior Vice President and General Manager, Mainframe Software Division

Session 8

11:25 a.m. EDT

 Db2 for z/OS Performance Improvement Opportunities
 Akiko Hoshikawa, IBM
 Squeeze Your Data with Db2: A History of Compression
  Jim Dee, BMC Software
 Migrating Db2 to the AWS Cloud: Mission Impossible – Completed!
  Damir Wilder, Triton Consulting Ltd.
 Going the Distance - Testing Network Impacts on Db2
 Mark Murnane, IBM
 Socialize This -  Have Fun Using Graph Databases to Explore Social Media
  Paul Turpin, Truist

Vendor Sponsored Presentations

12:35 p.m. EDT

Please note that the VSPs do not follow the same track designations as other sessions. Though they may be slotted to a track-specific room, you’ll need to check the VSP session titles and information to determine whether the technology and topics are relevant to you. Check the daily agenda page to see which room to join.

 Imagine How Much You Can Learn Exploring Db2 Accounting Data 
 Todd Havekost, Intellimagic
 How Broadcom is Bringing the z/OS Db2 DBA Into DevOps
  Denis Tronin & Toine Michielse, Broadcom
 Extending the scope of Db2 for z/OS Performance Monitoring and Management with the OMEGAMON Family 
  Kevin Hosozawa, Rocket Software
 Mainframe-inclusive DevOps and Db2 DevOps with BMC
 Devanand Karunakaran,  David Linsell, & Neil Gilford, BMC Software
 IBM Cloud Pak for Data and IBM Z - The Best of Both Worlds
 Jonathan Sloan, IBM

Session 9

1:45 p.m. EDT

 Db2 12 for z/OS User Experience at Worldpay from FIS
  Lethika Panicker, Worldpay
 Maybe Profiling Isn’t So Bad After All…In Db2 That Is
 Adrian Burke, IBM
 Db2 Basics: Monitoring and Troubleshooting Db2
  Ember Crooks
 Db2 Security Unscrambled: The Hybrid (Cloud) Edition
 Henrik Loeser, IBM
  The Joy of Joins
  Emil Kotrc, Broadcom

2:55 PM EDT


Session 10

3:55 p.m. EDT

 New Announcement Db2 AI for z/OS
 Jim Pickel, Bharat Verma, & Tom Beavin IBM
 Encryption of Db2 for z/OS Data "at Rest" using Key Label
 Manik Kainth, Broadcom
 Restore Strategies
Sebastian Zok, Dirk Rossmann GmbHDb2
How Does the Db2 LUW Machine Learning Optimizer Train Models
 Liam Finnie, IBM
  Software in Space - What Can IT Earthlings Learn from Space Missions
 Joe Winchester, IBM

Session 11

4:35 p.m. EDT

 A Guide to Visual Studio Code for Db2 for z/OS Developers and DBAs
 Patrick Bossman, IBM
 Easy Communication with Db2
 Leila Hosseini, Ontario Government
 Db2 (LUW) Expert Mini Panel
 Les King, IBM
 Keri Romanufa, IBM
 Mike Springgay, IBM
 Pavel Sustr, IBM
 Dale McInnis, IBM
  Ember Crooks
  Philip Gunning, Gunning Technology Solutions
 Using Db2 z/OS as a NoSQL Solution
 Dan Ferree &  Ryan Mullaney, BlueCross BlueShield of South Carolina

back to top

Thursday, June 10

9:15 - 10:15 AM EDT

Regional User Group meeting

RUG leaders: RSVP Here

10:30 AM EDT

 IBM Champions Information Session

Join Stuart Litel from the IBM Champions and IBM Community Team, Tanmay Sinha, Program Director IBM Db2 (LUW) Offering Management and Marius Ciortea, IBM Chief Community Officer
to talk about he IBM Champion program. Meet a few Db2 Champions and let them tell you in their words what it means to be an IBM Champion and Libby and Stuart will tell you how you too can be an IBM Champion and become one of the top IBM Champions in the world. (Rumor is IBM Champions also get some cool shirts and other SWAG!!) Want to learn more about the IBM Champions? Visit ibm.biz/champions - we might even have Libby sing a rendition of We Are The Champions!

Session 12

11:25 a.m. EDT



Monitor Even When Z Is 100% Busy
 María Belén Francés Foz & Carlos Guardia Rivas, Bankinter
 Dynamic Query Performance Diagnosis and Tuning
 Thomas Baumann, Swiss Mobiliar
 Backup and Recovery 101 - What Do We Really Need to Do
 Dale McInnis, IBM
 Performance Fun with Sandbox Databases
 Ruben Boer, Triodos Bank
  You Can’t Automate Mainframe Testing! Or Can You?
 Sujit Neb, BMC Software

12:35 PM EDT


Special Interest Groups (SIGs)

1:35 p.m. EDT



 
 
 
 Db2 Modernization
  Frank Fillmore, The Fillmore Group, Inc.
 Haakon Roberts, IBM
 Jonathon Sloan, IBM
 AppDev Discussion 
  Dan Luksetich, DanL Database Consulting
  Chris Crone, Broadcom
 George Baklarz, IBM
 Calisto Zuzarte, IBM
 Security and Encryption
  Dave Beulke, Dave Beulke and Associates
  Steve Mazer, DeNOVO Solutions
 Greg Stager, IBM
 Roy Boxwell, Software Engineering GmbH
 Max Lewis, IBM
 Appliances
 Les King, IBM
 John Bell, IBM
 Dennis Lukas Mayer, IBM
 Martin Dirk Schneider, IBM
 Content Committee Deep Dive
  Javier Estrada Benavides, Broadcom 
  Brian Laube, Manulife Financial
  Dave Simpson, Transamerica
 Joe Geller, JPMorgan Chase
    John Maenpaa, db2solutions LLC

Vendor Sponsored Presentations

2:45 p.m. EDT



Please note that the VSPs do not follow the same track designations as other sessions. Though they may be slotted to a track-specific room, you’ll need to check the VSP session titles and information to determine whether the technology and topics are relevant to you. Check the daily agenda page to see which room to join.

 Imagine How Much You Can Learn Integrating Db2 with Other Types of SMF Data 
 Todd Havekost, Intellimagic
 Beyond Concurrency: Broadcom's Solution for Restartable z/OS Batch Applications 
  Julia Carter & Robert Andresen, Broadcom
 Data Studio/DSM Strategic Replacement News
 Pat Bossman, IBM &
  Peter Fandel, Rocket Software
 Detecting Db2 Performance Issues and Tuning Your Database in Minutes
 Ousama Shamma, DBI Software

Session 13

3:55 p.m. EDT



Virtual Indexes Explained
 Ryszard Stepien, Broadcom
 Db2 for z/OS: All About APPLCOMPAT
 Robert Catterall, IBM
 Using Q Replication with Db2 Columnar Tables
 Serge Bourbonnais, IBM
 Decoding Db2 Security Bulletins
 Nataliya Prokoshyna, IBM
  Shared-Schema, Multi-Tenancy Database with Recovery by Tenant
 Bill Hulsizer

Session 14

4:35 p.m. EDT



 Db2 for z/OS Expert Mini Panel
 Jim Reed, IBM
 Haakon Roberts, IBM
 John Campbell, IBM
 Akiko Hoshikawa, IBM
  Frank Fillmore, The Fillmore Group
  Daniel Luksetich, DanL Database Consulting
 Maureen Townsend, IBM
 Patrick Bossman, IBM
 Db2 Historical Monitoring
 Pavel Sustr & Yunpeng Wang, IBM
 How to Implement Unidirectional Q Replication Setup on Four Node HADR Clusters
 Tirupati Balaga, Huntington National Bank
 Welcome to Db2 Graph
 Quentin Presley, IBM

back to top

Friday, June 11

10:30 AM EDT

Women in Technology Keynote Address

When the Only Way Forward Is Through:
Three Stories of Leading During the Pandemic

Join us as three industry experts reflect on their leadership experiences over the last year. They'll explore how the pandemic has changed their leadership styles and influenced the ways they interact with their teams. They'll also discuss the challenges they faced in managing remote teams and encouraging work-life balance. With a look to the past and an eye on the future, this WIT keynote will be filled with ideas you can incorporate into your own leadership style.

Saghi Amirsoleymani
Global Vice President, System Z
Rocket Software
Malloy.pngTracey Malloy
Senior Manager of Software Engineering 
Broadcom
Irina.pngIrina Delidjakova
Program Director, Db2 Development Ecosystem
IBM

Session 15

11:40 a.m. EDT

 Let My Data Go: Using z/OSMF REST APIs to set Your Data Free
 Mmeharban Mmeharban, BMC Software
 SMF'em All - Reporting to Keep Your Application's Performance Under Control
 Jacek Rafalak, Comarch S.A.
 Db2 Basics: All About Indexes
  Ian Bjorhovde, XTIVIA
 Database Performance Insights Using Db2mon on Db2 v11.5
 Toby Haynes, IBM
  Integrating Db2 with Mobile Technology
 Tom Kolanko, IBM

12:50 PM EDT


Session 16

1:50 p.m. EDT

 Performance Monitoring: Experience in Customer Situations - Best Practices
  Norbert Jenninger, Rocket Software
 Favorite Db2 Performance and Optimization Features V9-V12
  Tony Andrews, Themis Inc. 
 Automated HADR with Pacemaker Updates
 Gerry Sommerville, IBM
 Foreign Affairs: Understanding Foreign Keys and Their Impact
  Mark Gillis, Triton Consulting Ltd.
  (Re-)Emergence of Open Source on Mainframe
 Chris Blum, The Linux Foundation

Session 17

3:00 p.m. EDT

 Bridging the Gap Between Db2 and Enterprise Metrics and Data Science
 Kevin Harrison, Broadcom
 Valuable Actionable Tidbits for Db2 Professionals
 Anthony Ciabattoni, IBM


Db2 LUW: A Handbook to pureScale Instance Administration Utilities
 Phil Stedman, IBM
Row and Column Access Control: A Deep Dive
Greg Stager, IBM
  Mainframe Modernization - Field Notes
  Frank Fillmore, Jr., The Fillmore Group, Inc.

back to top

On-Demand Sessions


REST Without Stress - How to Secure Db2 for z/OS REST Services (and Db2 for z/OS in General) via AT-TLS, Christoph Theisen, IBM

New Frontiers in Leveraging z/OS Real Storage for Optimal Db2 Performance, Robert Catteralll, IBM

Tuning SQL that Still Works!,  Sheryl Larsen, BMC Software

Stop Fantasizing and Start Virtualizing!, Jim Wankowski, Rocket Software

An Introduction to IBM Watson Machine Learning for z/OS, Roger Sanders, IBM
What Db2 Can Do, I Can Do Too: First Steps Towards AI, Toine Michielse, Broadcom

What New Modern Programming Languages You Can Use with Db2 and How, Petr Plavjanik, Broadcom

Optimize Db2 for z/OS with Machine Learning Using IBM Db2 AI for z/OS, James Pickel, IBM
Application Journaling Costs: Our Long Struggle Has Finished, Pawel Hryb, PKO Bank Polski
 
 


Adaptive Workload Management: Best Practices + What's New, David Kalmuk, IBM

Bringing AI into the Database with Db2's New Python UDFs and Built-In Machine Learning Procedures, Kelly Schlamb, IBM

Stop Them Rustling Your Data,  Pav Kumar-Chatterjee, CJPK Enterprises
Lessons Learned when Implementing Pacemaker with SAP on Db2, Thomas Rech & Hans-Juergen Zeltwanger, IBM

Explain Essentials for Query Optimization, John Hornibrook, IBM




Anomalize This, Javier Estrada Benavides, Broadcom

Db2 Database Design Mistakes: Learn What Not to Do,  Craig Mullins, Mullins Consulting, Inc.

Secure by Design: Best Practices to Design Security into Your Database and Applications,  Dave Beulke, Dave Beulke and Associates

Distributed Data in Db2: Coding Techniques and Accessing Distributed Data, Neeraj Ahuja, BMC Software


back to top

Monday, June 14

Educational Seminars
Advance registration required. More information here. 


10:30 a.m. - 2:00 p.m. EDT
 Replication Made Simple Using InfoSphere Data Replication 11.4
  Mohan Saraswatipura, Kronsys, Inc.


10:30 a.m. - 5:30 p.m. EDT

 Db2 12 Certification Crammer Course
  Susan Lawson, YL&A 
 SQL Performance and Tuning Using Data Studio
  Tony Andrews, Themis Inc. 


2:15 - 5:30 p.m. EDT
 Preparing for the Db2 11.5 Foundations Exam 
 Jason Shayer and Steve Darling, IBM
 Db2 v11.5 pureScale and Implementation Principles
  Mohan Saraswatipura, Kronsys, Inc

Tuesday, June 15

Hands-On Labs and Workshops

educational-01.png

Hands On Labs and Workshops
Tuesday, June 15

Instructions with the link to join closed sessions will be emailed to registered attendees. Links for open sessions will be posted prior to the session.

Please email any questions to idug@idug.org. 

10:30 a.m. - 2 p.m. EST
Db2 Problem Determination - Part 1
(closed session)
Pavel Sustr, IBM
Link emailed to registered participants
10:30 a.m. - 2 p.m. EST
Infusing Db2 for z/OS with AI
(closed session)
John Goodyear & Martin Dinh, IBM
Link emailed to registered participants 
10:30 a.m. - 5:30 p.m. EST
Next Generation of Db2 Development - Parts 1 & 2
(closed session)
Vin Agrawal, IBM
Link emailed to registered participants
10:30 a.m. - 5:30 p.m. EST
Db2 V11.5.6 Deep Dive - Parts 1 & 2
(open session)
Download Session Slides
Les King, IBM
2:15 - 5:30 p.m. EST
 
Db2 12 for z/OS: Business and Technical Value of Db2 12 New Function Beyond M500
(open session)
Download Session Slides
Robert Catterall and Mark Radar, IBM
 

Wednesday, June 16

Hands-On Labs and Workshops


10:30 a.m. - 2:00 p.m. EDT
 Getting Used to DMC and dmctop
 Maryia Rakina, IBM
Link to join will be posted prior to the session. 
 Db2 Problem Determination - Part 2 
 Advanced registration required. Learn more.
 Pavel Sustr, IBM
Instructions to join will be sent to approved attendees prior to the session.
 Db2 V11.5 Architecture Deep Dive
 Keri Romanufa, IBM
Link to join will be posted prior to the session. 
 An Introduction to IBM Cloud Pak for Data on IBM Z
Session is full. Join waitlist. 
 John Goodyear and Guillaume Arnould, IBM    
Instructions to join will be sent to approved attendees prior to the session.


2:15 - 5:30 p.m. EDT
 Click to Containerization - Moving to the Cloud in Minutes 
 Advanced registration required. Learn more.
 George Baklarz, IBM
Instructions to join will be sent to approved attendees prior to the session.
 Building a Secure Db2 Environment 
 Advanced registration required. Learn more.
 Alvin Fung and Mitchell Waite, IBM
Instructions to join will be sent to approved attendees prior to the session.

back to top