Registration Information
2-Day Conference Registration $350CAD
Includes
- Presentation material downloads
- Breakfast, Lunch, & Catered Expo Hall on Monday
- Breakfast & Lunch on Tuesday
- Vendor reception
Important dates:
- Early registration cut-off date: Friday August 19th, 2022 [for early bird prize draw – $100 Gift Certificate]
- Final registration cut-off date: Friday September 16th, 2022 [sorry – no walk-ins]
Conference Agenda
*subject to change*
Monday September 19
Z/OS
LUW
AppDev
IMS
8:00 – 9:00
Registration & Badge Pickup
Breakfast
9:00 – 9:15
Welcome & Introduction
9:15 – 10:00
Keynote

Coffee Break – Sponsored by SEGUS
10:15 – 11:15
Z01
Getting Ready for Db2 13
John Lyle, IBM
The purpose of this presentation is to introduce the new migration process for the new Db2 13 for z/OS release. The Db2 13 release migration process is significantly different from any previous Db2 release migration. The changes are, in fact, revolutionary. We will detail the Db2 12 to Db2 13 migration process, the Db2 13 Installation process, and go into details regarding application compatibility and the Continuous Delivery process as it relates to Db2 13. Each release brings new migration processes and challenges we will detail the nuts and bolts of the significant Db2 13 process and procedure changes.
Speaker Bio
John Lyle has worked for IBM at the Silicon Valley Laboratory in the Db2 organization since 1985. Joining Db2 development in 1995, he has worked in the RDS area focusing mostly on the Db2 system catalog, migration and fallback and the data definitional language (DDL) areas as well as the index manager area. He has been the lead designer and implementer of the catalog and fallback changes since V5 and has worked on numerous other development items over the years. John was the lead designer for Db2 9’s Clone table function. In V8 – V11 John was the Utility lead for all of the ENFM changes that were made to the Db2 catalog and directory. In V12 John was a development leader and designer in the move to Db2’s new continuous development process and also the new Online Migration capabilities. In Db2 13, John was the lead designer in the changes to the migration process. John is currently working in Db2’s Provisioning-Deployment-Migration team as the team leader.
L01
Latest from the Lab
Keri Romanufa, IBM
Db2 v11.5 has been the continuous development release for the last 4 years. Currently at v11.5.8, there have been a number of mod packs for both traditional install and Db2U containerized installs.
This session will first review key enhancements in 11.5.8, and then take a look at what is still to come in the 11.5 stream. To finish off, we’ll take a sneak peek into Db2 beyond 11.5
Speaker Bio
Db2 Chief Architect
A01
SQL Tuning and Indexes
David Simpson, Themis Inc.
Indexes are an essential component of relational databases. In this session we will discuss the appropriate use of indexes with plenty of real world use cases. Topics include:
-Index structure in Db2
-Index benefits and costs
-Things that prevent index usage
-Explain to determine how indexes are use
-Recent indexing features
Speaker Bio
BIOG
I01
IMS Trends and Directions
Deepak Kohli & Haley Fung, IBM
ABSTRACT
Speaker Bio
BIOG
Coffee Break – Sponsored by Broadcom
11:30 – 12:30
Z02
Why DBAs should embrace Db2 Database DevOps
Steve Solomon, BMC Software
The current generation of Db2 DBAs need to pass their knowledge of their companies Db2 environments and how to successfully make changes that meet company standards while avoiding performance pitfalls. In this session attendees will hear how leading companies are taking this knowledge and using it in DevOps automation to ensure fast and accurate Db2 schema changes. The presenters will also cover Db2 Database DevOps for application developers where SQL in applications can be passed through an automated QA process ensuring that the next generation of developers don’t have performance issues with their applications. This session is applicable to DBAs using BMC, Broadcom, and IBMs tools for managing changes to Db2.
Attendees will leave this session understanding:
A. How DBAs can reduce toil and errors by embracing Database DevOps
B. How Db2 Database DevOps can help keep Bad SQL from reaching production
C. Opportunities available to develop a custom solution by leveraging products from BMC, Broadcom, and IBM
D. If your application developers are pushing to be able to manage DDL in development what you will need as a DBA to manage that process
Speaker Bio
Steve is a Lead Product Manager at BMC Software and is the BMC Software Liaison to the IDUG Board of Directors. Steve is leading an international software product team with mainframe solutions focused on improving Db2 System Performance, Agile Development, Change Automation, Reducing Cost, and Risk Management. Steve has been a mainframe software product leader for over 20 years and enjoys discussions on Database DevOps for IMS and Db2, DevOps, REST API Development, Enterprise Change Management, Agile Software Development, and Application Release Automation.
L02
Automatic Statistics Collection Deep Dive
John Hornibrook, IBM
ABSTRACT
Speaker Bio
BIOG
A02
Esoteric Functions in Db2
Ulf Heinrich, SEGUS
Db2 has grown tremendously over the years and there have been bits and pieces added on that are either odd, strange or exotic which not many people use or have even heard about. This presentation will describe a few of my personal favourites in the area of esoteric functions. I wish to cover FTB/FIT (not so much esoteric as very interesting!), Spatial Index’s, XML (with regular expressions) , Clone Tables and Scrollable Cursors.
Speaker Bio
BIOG
I02
Simplifying the Administration of IMS
Tracy Dean & Ron Bisceglia, IBM
ABSTRACT
Understanding and administering IMS is complex to say the least. Many IMS customers are already faced with, or will soon be faced with, the loss of experienced and trusted IMS skills that have kept applications running on IMS smoothly for years. Come see the new web browser interface that is shared with Db2 which will make the experience of understanding and administering your IMS environment much easier and allow you to become proficient more quickly. We will also cover automation for monitoring of IMS databases to understand reorg and recovery issues, allowing you to easily visualize the issue and proactively manage your IMS databases.
Speaker Bio
BIOG
Lunch – Sponsored by SEGUS
1:30 – 2:30
Z03
Db2 for z/OS User Transformation Strategy Update
Sowmya Kameswaran, IBM
A challenge facing mainframe Db2 shops is how to become more agile with modern tooling, yet leverage the existing resources and skills that power their z/OS systems. Zowe provides a way to do this through its Visual Studio Code plugins, its browser based web desktop, and its command line interface. This allows Db2 shops to leverage their existing JCL and REXX libraries, their existing stored procedures, their existing SQL scripts, and surface existing resources in new form factors for DevOps tool chains, for automation, for operations, and more. These can be used by experienced mainframers as well as folks new to the platform, providing a bridge between familiar open source tools and Db2 on z/OS. This talk will demonstrate using Zowe Explorer inside Visual Studio Code as well as free to use community extensions to create a powerful next generation Db2 z/OS platform covering development and debugging of stored procedures, working with static and dynamic SQL, coding and executing JES, JCL and REXX scripts, all with real world examples and customer success stories.
Speaker Bio
Sowmya Kameswaran works at the IBM Silicon Valley Labs in San Jose California and leads the Application developer and Administrator experience transformation for Db2z platform and ecosystem. Understanding the way users interact with the system and building interfaces to provide the best user experience is what she enjoys to do. Being hands-on into software development helps her go end to end from understanding the kind of experience customers need to getting it built.
L03
Db2 Native Encryption: An Overview
Nataliya Prokoshyna,
IBM
ABSTRACT
Speaker Bio
BIOG
A03
Opening IMS with REST API
Vaclav Koudelka, Broadcom
With the rise of popularity of REST APIs in the z/OS world, IMS shouldn’t be left behind. In this presentation, we will go through different approaches on how to develop REST applications accessing IMS resources with a deep dive into transforming IVTNO transactions into REST API. We will also cover the possibility of onboarding such API into the Zowe ecosystem.
Speaker Bio
BIOG
I03
An Introduction to IMS Database
Dennis Eichelberger, IBM
ABSTRACT
Speaker Bio
BIOG
Coffee Break
2:45 – 3:45
Z04
Db2 12 Continuous Delivery – A Journey Through the Function Levels
Chris Crone, Broadcom
This presentation will cover the basics on adopting each FL (what happens when you issue -ACTIVATE) through FL 510. Given that a lot of people have just recently migrated to Db2, this topic will be helpful to customers who are starting to think about activating FLs.
Speaker Bio
Chris Crone has extensive experience working with Db2 and IBM z Systems. Prior to joining Broadcom, Chris worked with the Db2 for z/OS development team for more than 30 years. He has worked extensively with customers on new development projects, prioritizing requirements, and advising on how to best use Db2 to achieve their goals.
L04
Desperate Measures – How to Relieve the Db2 Optimizer of its Duties
John Hornibrook, IBM
ABSTRACT
Speaker Bio
BIOG
A04
TITLE
SPEAKERNAME, COMPANY
ABSTRACT
Speaker Bio
BIOG
I04
An introduction to IMS Transaction Manager
Suzie Wendler, IBM
ABSTRACT
Speaker Bio
BIOG
3:45 – 7:00
Vendor Expo
Vendor Expo – Sponsored by
Tuesday September 20
Z/OS
LUW
AppDev
IMS
8:00 – 9:00
Breakfast
Breakfast
9:00 – 10:00
Z01
What happened in the Db2 Catalog for Db2 13
Steen Rasmussen, Broadcom
Every new release of Db2 has provided numerous new features and many of these features have to be reflected in the catalog. This presentation will do a detailed comparison between Db2 12 FL500 and Db2 12 FL510 and Db2 13 FL100 in order to understand all the differences.
Speaker Bio
Steen Rasmussen is a Customer Services Consultant currently instrumental in the ongoing development and support of the Broadcom Db2 solutions. In 1985 Steen started as an IMS/DB2 DBA at a major insurance company in Denmark working with all aspects of DB2 – like tuning, application design and implementation, education of developers, backup and recovery planning and automation of housekeeping processes. During this job, Steen also served as a member of the planning committee for DB2 GUIDE SHARE Nordic Region. In 1995 Steen became a technical manager at PLATINUM Technology managing technical support and presales for the DB2 products. Steen has been working with DB2 for z/OS Release 1.0 since 1985 and is always looking for new opportunities in the Broadcom DB2 solutions which can help customers manage DB2 more efficiently. Besides from providing support to the teams in the field as well as internal groups at Broadcom working with DB2, Steen is also a frequent speaker at IDUG in North America, EMEA and Australia as well as local DB2 User Groups around the world. Since 2014 Steen has been an IBM Champion. Steen has also been the Broadcom liaison for IDUG NA since 2013.
L05
Adaptive Workload Management: What’s New and Best Practices
David Kalmuk, IBM
ABSTRACT
Speaker Bio
BIOG
A05
Do your Db2z application developers like Python? Sure lets build z applications using it!
Sowmya Kameswaran, IBM
Python is one of the top programming languages in the world. It’s easy to learn; for DBAs similar to REXX; and has a robust set of libraries that enable delivering business value specifically surrounding data rapidly and easily. This presentation will use a Python on z/OS with the python-ibm_db library along with a few visualization libraries to provide some fun demonstrations that also show the power and ease of use Python.
Speaker Bio
Sowmya Kameswaran works at the IBM Silicon Valley Labs in San Jose California and leads the Application developer and Administrator experience transformation for Db2z platform and ecosystem. Understanding the way users interact with the system and building interfaces to provide the best user experience is what she enjoys to do. Being hands-on into software development helps her go end to end from understanding the kind of experience customers need to getting it built.
I05
Architecting Integration – What you need to know about IMS Connect, OTMA, and ODBM
Suzie Wendler, IBM
ABSTRACT
Speaker Bio
BIOG
Coffee Break – Sponsored by SEGUS
10:15 – 11:15
Z06
IBM Db2 Admin Foundation for z/OS – no charge replacement for Db2 for z/OS admin features in Data Studio and DSM
Jim Wankowski, Rocket Software
ABSTRACT
Speaker Bio
BIOG
L06
Db2 V11.5 – Beginning to End
Les King, I
BM
ABSTRACT
Speaker Bio
BIOG
A06
Can Data Streaming Help Secure your IMS Data Nick Griffin, BMC Software
Speaker Bio
BIOG
I06
What if you had to quickly recover an IMS database – could you?
Ron Bisceglia, IBM
ABSTRACT
Speaker Bio
BIOG
Coffee Break
11:30 – 12:30
Z07
DDF
Bob Vargo & Dustin Ratliff, Progressive
ABSTRACT
Speaker Bio
BIOG
L07
A DB2 Security Primer
Greg Stager, IBM
ABSTRACT
Speaker Bio
BIOG
A07
Transform your IMS applications with COBOL & Java Interoperability
Haley Fung, IBM
ABSTRACT
Speaker Bio
BIOG
I07
Maintain IMS recovery assets long after they have been deleted from DBRC
Gary Turner, BMC Software
ABSTRACT
Speaker Bio
BIOG
Lunch
1:30 – 2:30
Z08
The mysteries of the Db2 for z/OS Catalog and migration: The Past, Present, and Future
John Lyle, IBM
The purpose of this presentation is to unveil some of the mysteries of the Db2 catalog and the migration process. The presentation will cover some basic catalog information before moving into the mysteries of a catalog migration. Will cover data sharing/non-data sharing migration considerations, catalog and migration enhancements for Db2 releases through Db2 13, performance considerations, and finish with information about the future direction of the Db2 catalog and migration process. Will also cover information about the various function levels of Db2 12 and 13. This presentation will also spend time discussing the future of the migration process and also touch on Continuous Delivery concepts and new Online Migration capabilities.
Speaker Bio
John Lyle has worked for IBM at the Silicon Valley Laboratory in the Db2 organization since 1985. Joining Db2 development in 1995, he has worked in the RDS area focusing mostly on the Db2 system catalog, migration and fallback and the data definitional language (DDL) areas as well as the index manager area. He has been the lead designer and implementer of the catalog and fallback changes since V5 and has worked on numerous other development items over the years. John was the lead designer for Db2 9’s Clone table function. In V8 – V11 John was the Utility lead for all of the ENFM changes that were made to the Db2 catalog and directory. In V12 John was a development leader and designer in the move to Db2’s new continuous development process and also the new Online Migration capabilities. In Db2 13, John was the lead designer in the changes to the migration process. John is currently working in Db2’s Provisioning-Deployment-Migration team as the team leader.
L08
My Favourite Db2 Query Optimization Registry Variables
John Hornibrook, IBM
ABSTRACT
Speaker Bio
BIOG
A08
Do I really need to worry about my Commit Frequency? An introduction to Db2 Logging.
Andrew Badgley, Broadcom
Does it really matter how often my application commits its activity? Yes, yes it does. Db2 writes log records for all of the Inserts, Updates, and Deletes that happen to any table. This session will explore what the Db2 log is, how Db2 writes to it, what a Unit of Work is, and the impact of canceling a Unit of Work with regards to Db2 logging. Answers will be provided for the following questions: What is the BSDS? What is the difference between Active and Archive Logs? What is a Unit of Work? What is the difference between Insert, Update, and Delete log records? Why do I care about Data Capture Changes YES/NO? What is the importance of the Db2 Log with regards to Point In Time Recovery? What log activity happens when I cancel a Unit of Work?
Speaker Bio
BIOG
I08
Understanding your IMS Catalog
Deepak Kohli, IBM
Mobile, Open Data, Blockchain, Administration, Performance, Parameter Management, IMS Native z/OS DDL utility
Coffee Break
2:45 – 3:45
UTS, Past, Present & Future
Ulf Heinrich, SEGUS
ABSTRACT
The UTS has been with us since DB2 V9 and now in Db2 12 it got an upgrade with the UTS PBR RPN type. In this presentation I wish to show you how to use which variant, and when, for the best performance and utility balance. I will also briefly review the history of UTS and its probable future development.
Speaker Bio
BIOG
L09
Db2 Warehouse Latest & Greatest
Mike Springgay, IBM
ABSTRACT
Speaker Bio
BIOG
A09
Tips for DBAs and Application Programmers to help reduce costs.
Steve Solomon, BMC Software
In this session the speaker will cover how IBM and Independent Software Vendors (ISVs) charge for mainframe software and tips for maintaining Db2 and managing SQL queries to take advantage of pricing models to reduce costs. We will cover strategies to get the most out of the Monthly License Charge (MLC) pricing model and what you should do if you are transitioning to a Tailor Fit Pricing (TFP). When and how you run Db2 Utilities for backup and Reorgs matters just as much as application SQL performance tuning when looking for cost savings opportunities.
Attendees will leave this session understanding:
A. A short history of the IBM Z Mainframe
B. That the IBM Z Mainframe is not Old, Legacy, or Going Away
C. Pricing Models that IBM and ISVs use and how costs are determined
D. Cost optimization strategies that fit your current software pricing models
Speaker Bio
Steve is a Lead Product Manager at BMC Software and is the BMC Software Liaison to the IDUG Board of Directors. Steve is leading an international software product team with mainframe solutions focused on improving Db2 System Performance, Agile Development, Change Automation, Reducing Cost, and Risk Management. Steve has been a mainframe software product leader for over 20 years and enjoys discussions on Database DevOps for IMS and Db2, DevOps, REST API Development, Enterprise Change Management, Agile Software Development, and Application Release Automation.
I09
Hands-on Lab:
IMS Buffet of Labs
Mobile, Open Data, Blockchain, Administration, Performance, Parameter Management, IMS Native z/OS DDL utility