Conference Details

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

Steve Astorino, VP of Development, Data & AI and Canada Lab Director
Coffee Break – Sponsored by SEGUS

10:15 – 11:15

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.

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

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

ABSTRACT

Speaker Bio

BIOG

Coffee Break – Sponsored by Broadcom

11:30 – 12:30

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.

ABSTRACT

Speaker Bio

BIOG

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

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

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.

ABSTRACT

Speaker Bio

BIOG

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

ABSTRACT

Speaker Bio

BIOG

Coffee Break

2:45 – 3:45

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.

ABSTRACT

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

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

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.

ABSTRACT

Speaker Bio

BIOG

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.

ABSTRACT

Speaker Bio

BIOG

Coffee Break – Sponsored by SEGUS

10:15 – 11:15

ABSTRACT

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

Coffee Break

11:30 – 12:30

ABSTRACT

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

ABSTRACT

Speaker Bio

BIOG

Lunch

1:30 – 2:30

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.

ABSTRACT

Speaker Bio

BIOG

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

Mobile, Open Data, Blockchain, Administration, Performance, Parameter Management, IMS Native z/OS DDL utility

Coffee Break

2:45 – 3:45

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

ABSTRACT

Speaker Bio

BIOG

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.

Mobile, Open Data, Blockchain, Administration, Performance, Parameter Management, IMS Native z/OS DDL utility