NA21 Agenda

Check out the full list of confirmed sessions for the North America Db2 Tech Conference organized by day below. 

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
Maureen Townsend, IBM
11:45 AM EDT
luw track image
Db2 (LUW) Spotlight Session
Keri Romanufa, IBM

Session 1

2:10 p.m. EDT


 New Announcement Db2 AI for z/OS
Jim Pickel, IBM
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
 Migrating Db2 from P-Series to X86
 Dale McInnis, IBM 
 Db2's External Tables: A Deep Dive
 Mike Springgay, IBM
 Db2 Batch Processing with Spring Batch
 David Morris, Leidos

Tuesday, June 8

10:30 am EDT

Keynote address

Session 4

11:25 a.m. EDT

 Building Universal Db2 Monitoring Package
 Mariusz Koczar, Tieto Czech s.r.o.
 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
 Securing Your Db2 for Z Databases: The Practicalities Faced
 Paul Murray, Westpac New Zealand Ltd
 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

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

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

Wednesday, June 9

10:30 AM EDT

Keynote address

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

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

Session 10

3:55 p.m. EDT

 Spring Cleaning – Efficient Ways of Removing Data and Purging Best Practices
 Scott Walker, Navy Federal Credit Union
 Encryption of Db2 for z/OS Data "at Rest" using Key Label
 Manik Kainth, Broadcom
 Backup and Recovery 101 - What Do We Really Need to Do
 Dale McInnis, IBM
 Workload Manager - Intro and Customer Success Story
 Gopinath Kamalakkannan, Huntington National Bank
  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
 Mini Panel
 Les King, IBM
 Using Db2 z/OS as a NoSQL Solution
 Dan Ferree & Ryan Mullaney, BlueCross BlueShield of South Carolina

Thursday, June 10

10:30 AM EDT

Keynote address

Session 12

11:25 a.m. EDT



Monitor Even When Z Is 100% Busy
 María Belén Francés Foz, Bankinter
 Dynamic Query Performance Diagnosis and Tuning
 Thomas Baumann, Swiss Mobiliar
 Restore Strategies
 Sebastian Zok, Dirk Rossmann GmbHDb2
 Performance Fun with Sandbox Databases
 Ruben Boer, Triodos Bank
  You Can’t Automate Mainframe Testing! Or Can You?
 Sujit Neb, BMC Software

Special Interest Groups (SIGs)

1:35 p.m. EDT



 Db2 Modernization
 Frank Fillmore 
 AppDev Discussion 
 David Morris
 Security and Encryption
 Dave Beulke & Greg Stager
 Appliances
 Les King, IBM
 Content Committee Deep Dive
 IDUG Content Committee

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 Mini Panel
 Jim Reed, IBM
 Db2 Historical Monitoring
 Pavel Sustr, 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

Friday, June 11

10:30 AM EDT

Keynote address

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

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

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

The Latest Real Customer Experiences With Db2 12, Ute Kleyensteuber, Commerzbank AG

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, Terry Purcell, IBM
Optimizing Data Transformation with Db2 for z/OS and Db2 Analytics Accelerator, Maryela Weihrauch, 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

How Does the Db2 LUW Machine Learning Optimizer Train Models?,
Liam Finnie, IBM
Lessons Learned when Implementing Pacemaker with SAP on Db2, Thomas Rech, 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


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. 
 Replication Made Simple Using InfoSphere Data Replication 11.4
 Mohan Saraswatipura, Kronsys, 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


10:30 a.m. - 2:00 p.m. EDT

 Next Generation of Db2 Development - Part 1
 Vin Agrawal, IBM
 Db2 Problem Determination Workshop - Part 1
 Pavel Sustr, IBM
 Db2 V11.5.6 Deep Dive - Part 1
 Keri Romanufa, IBM
 Infusing Db2 for z/OS with AI
 John Goodyear & Martin Dinh, IBM


2:15 - 5:30 p.m. EDT

 Next Generation of Db2 Development - Part 2
 Vin Agrawal, IBM
 Db2 Performance Tuning  - Part 1
 Calisto Zuzarte, IBM
 Db2 V11.5.6 Deep Dive - Part 2
 Keri Romanufa, IBM
 An Introduction to IBM Cloud Pack for Data on IBM Z
 Speaker Details TBA

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
 Db2 Problem Determination Workshop - Part 2
 Pavel Sustr, IBM
 Db2 V11.5 Architecture Deep Dive
 Keri Romanufa, IBM
 Db2 12 for z/OS: Business and Technical Value of Db2 12 New Function Beyond M500
 Robert Catterall, IBM


2:15 - 5:30 p.m. EDT



 Click to Containerization - Moving to the Cloud in Minutes
 George Baklarz, IBM
 Db2 Performance Tuning  - Part 2
 Calisto Zuzarte, IBM
 Building a Secure Db2 Environment 
 Alvin Fung, IBM

On-Demand Workshop


Converting Db2 SQW Workloads to DataStage, James Sobieski, Fourth Millennium Technologies