Session Details

Download the Conference Grid (pdf). Be sure to check out the Conference Downloads section for access to presentation material.

Monday September 19

Z/OS

The Forum

LUW

Room 101

AppDev

Room 102

IMS

Room 103

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

Explain is the most fundamental tool used for query tuning. Everyone who interacts with SQL in a Db2 environment should have a basic understanding of explains and access path analysis. Topics include:
-Db2 optimizer overview
-Types of access paths in Db2
-Basic explain with and without tools
-Access path analysis

Where is IMS going over the next 10 years? Learn how IBM is investing in IMS and what that means for you.

Speaker Bio

Deepak Kohli is an IMS Offering Manager and has been working with IMS for several decades. He has worked as a DBA & Sysprog. He has also worked In IMS level 2 support. He is a sought-after speaker in the conference circuit.

Haley Fung is the IBM Product Manager for IMS and Ansible for Z. She drives the product direction in building solutions for enterprise modernization and integration for IMS and automation solutions for Z. Haley is a frequent presenter at global technical conferences. Her deep technical expertise and her passion and dedication for customers have helped many IMS and Z customers to modernize and enhance their application infrastructures as well as automating their Z resources with Ansible.

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

Tad Whitten started with BMC Software in 1997. In his current role he works to promote a common code and feature set between Catalog Manager and Command Center and is working to promote other BMC Db2 products integration in Command Center. He is a developer on Catalog Manager, AMI DevOps for Db2 and provides server side support for Command Center.
Tad started his career at BMC on the JCLGEN/Execution team. Later he became a developer on PDB Change Manager and SmartDBA where he took on the lead role of integrating SmartDBA with backend components found in Change Manager. He started working on Catalog Manager in 2001 where he became the lead developer and eventually the Product Architect for Catalog Manager. He has been the Architect and lead on Command Center since its inception in 2010.
Prior to BMC, Tad worked as a Technical Lead Developer at CSC where is supported the applications developers in the life insurance division.
Tad holds a Bachelor’s Degree in Computer Science and Finance from Texas Tech University.

Deploying an existing Db2 LUW Linux Database to OpenShift, Kubernetes, or Cloud Pak for Data usually involves some form of export and import and a lot of work! The new Click to Containerize (Db2 Shift) tool moves your on-premises database directly to the Cloud – with no exporting of data! The tool can also migrate your 10.5, 11.1 and 11.5 database directly into a Db2 container with no additional effort. This session will take you through the IBM Db2 C2C program and how it can help modernize your Db2 databases quickly and efficiently!

Speaker Bio

George Baklarz, B. Math, M. Sc, Ph.D. Eng., has spent many years in IBM working on various aspects of database technology. In 1991, George was part of the team that introduced the Db2 distributed product to the market. Since this time he has worked on vendor enablement, competitive analysis, product marketing, product planning, and technical sales support for the Db2 product.

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

Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc. He specializes in Db2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under realworld recovery pressure. His activities cover EMEA, as well as North America. As a member of SOFTWARE ENGINEERINGs Request Board he’s working closely with customers and the development labs.

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

Tracy Dean is an IBM Product Manager, responsible for IMS Tools and z/VM Tools. With over 37 years of Z experience, she works with customers worldwide to understand their pain points and drive development teams to address their needs.
Ron Bisceglia is a Distinguished Engineer and Principal Architect responsible for the design, development, and support for primarily the suite of IMS Tools. He has worked with IMS for over 30 years and has been involved in the development of database reorganization utilities, database propagation tools, database monitoring and analysis solutions, data replication, backup and recovery, and administration products.

Lunch – Sponsored by SEGUS

1:30 – 2:30

In the first part of this presentation, we will cover various topics and user experiences with Db2 sort. These include finding and diagnosing Db2 sort problems, as well as long term thoughts and solutions on dealing with sorts which consume all of the sort space. We will discuss automated solutions to this sort problem and the problems that presents between 4k and 32k. In the second part of this presentation we will be discussing various topics centered around DDF. We will cover dealing with applications which create connections that aren’t complete DRDA connections and the DOS like outcome that can produce. We will also cover user experiences (both good and bad) from an upgrade to the latest version of the Db2 drivers, v11.55, where many issues were encountered and had to be dealt with.

We will review the highlights of the DB2 native encryption capability for data-at-rest, including encrypted backup and restore, performance, and best practices.

Speaker Bio

Nataliya Prokoshyna is a software developer for Db2 LUW at the IBM Canada Lab. As a senior member of the Db2 security development team, Nataliya has worked on authentication, authorization, auditing and encryption, PSIRT, and other aspects of security within Db2.

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

Vaclav is IMS tools developer and occasional sustaining engineer at Broadcom. He likes to inject simplicity and straightforwardness into mainframe applications.

IMS DB – 101: This session is an overview of the Database features of IMS that many companies use for their highest volume and business critical processing. A description of IMS Databases Structures, Access methods and activating Resources is presented. How are databases built? How are application programs defined? How are Programs and Databases separated from IMS so rewriting of application resources is unneeded. All answered here. We will also examine IMS features and capabilities for modernization, such as the IMS Catalog and management of IMS metadata, database versioning support including both the HALDB Alter and DEDB Alter Functions with IMS 15, IMS Managed ACB support, and the implementation of Data Definition Language (DDL) Statements to update IMS resources and schemas. Help yourself and learn how business keeps up with today’s availability requirements.

Speaker Bio

Dennis has over 45 years of experience with ‘mainframe’ operating systems and database systems experience. He has worked as a developer, a consultant, business partner, competitor and vendor to IBM. Dennis is currently a member of the IMS Support team of the Washington Systems Center. His spare time is spent practicing the Gentle Way.

Coffee Break

2:45 – 3:45

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.

Objective 1: New and modified objects between the three Function levels.

Objective 2: Existing columns with new content.

Objective 3: Misc. items like usage of Temporal Tables and other valuable topics

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.

Optimal query access plans are essential for good data server performance and it is the query optimizer’s job to choose the best one. However; occasionally no amount of statistics or tuning is enough to get the access plan you want. Or your application is effectively down; due to a poorly-performing query; and there isn’t time to implement best practices. When these situations arise; Db2 optimization profiles and guidelines can be used to correct the access plan and get your application performing well again; quickly. Optimization profiles can specify various aspects of an access plan; can control automatic query rewriting or can control the optimizer’s plan search space. Guidelines can be specified with or without modifying your application. This presentation will show you what options are available and how to use them effectively.

Speaker Bio

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2; Db2 Warehouse; Db2 on Cloud and Db2 Big SQL. John also works closely with customers to help them maximize their benefits from IBM’s relational DB technology products.

In this session the speaker will cover basic Db2 topics that developers are being asked to perform that have traditionally been the role of DBAs. We will cover the Db2 Catalog and how to find information related to the Db2 objects that are part of the development environment and what it takes to perform those tasks. Topics will include:

  • Where to find Db2 CREATE, ALTER, and DROP syntax and how to understand the railroad diagrams necessary for to build that syntax.
  • How to quickly get data into your Db2 tables for testing
  • How to setup performance statistics so you can EXPLAIN your SQL statements. Then a quick overview and how understand the data in the PLAN_TABLE in order to build in performance to your SQL statements.
  • How does DevOps and Shift-Left impact todays Db2 developers?

Attendees will leave the session understanding:

  • Options available to perform simple Db2 related tasks like CREATE, ALTER, and DROP
  • Where to find manuals and help for Db2 related topics
  • How to diagnose and resolve some of the more common Db2 errors
  • How to be a better Db2 application by understanding some basic Db2

Speaker Bio

Tad Whitten started with BMC Software in 1997. In his current role he works to promote a common code and feature set between Catalog Manager and Command Center and is working to promote other BMC Db2 products integration in Command Center. He is a developer on Catalog Manager, AMI DevOps for Db2 and provides server side support for Command Center.
Tad started his career at BMC on the JCLGEN/Execution team. Later he became a developer on PDB Change Manager and SmartDBA where he took on the lead role of integrating SmartDBA with backend components found in Change Manager. He started working on Catalog Manager in 2001 where he became the lead developer and eventually the Product Architect for Catalog Manager. He has been the Architect and lead on Command Center since its inception in 2010.
Prior to BMC, Tad worked as a Technical Lead Developer at CSC where is supported the applications developers in the life insurance division.
Tad holds a Bachelor’s Degree in Computer Science and Finance from Texas Tech University.

IMS TM 101 – This session is the first of two primer sessions for new IMS professionals and managers. The session is an overview of the structure of the transaction management, application environment, and communication capabilities that allow the development and processing of wide range of high-volume and rapid-response interactions along with the ability to geographically disperse your data processing applications while keeping centralized control of your database.

Speaker Bio

Suzie Wendler is a member of the IMS team – Washington Systems Center. Over the past several years, her major responsibilities have included areas such as customer support, design implementations for IMS connectivity and, most recently, integration projects in support of the API economy. She has been with IBM supporting IMS for 35 years and prior to that was a customer for 10 years in the systems and application areas.

3:45 – 6:30

Vendor Expo

Vendor Expo – Sponsored by

Tuesday September 20

Z/OS

The Forum

LUW

Room 101

AppDev

Room 102

IMS

Room 103

8:00 – 9:00

Breakfast

Breakfast

9:00 – 10:00

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 – tend to misunderstand. From APPLCOMPAT to contiguous buffer pools, from MAXDBAT to the IBM Data Server Driver package collection, in this third iteration of my “Let me make this clear” presentation I’ll try to take folks from “Uh” to “Oh!”

Speaker Bio

Robert Catterall is a Senior Consulting Db2 for z/OS Specialist with IBM. 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, a member of IDUG’s Speakers Hall of Fame, and was one of IBM’s inaugural Information Champions. He presents frequently at conferences, and blogs about Db2 for z/OS at http://robertsdb2blog.blogspot.com/

Db2’s new Adaptive Workload Management technology vastly simplifies the task of dividing your database resources across workloads to ensure they meet their performance objectives. Unlike traditional workload managers it manages the admission of jobs based on their actual resource needs and intelligently schedules them based on the resource targets you assign; ensuring stable and reliable performance even in the face of the most highly concurrent workloads. Join David Kalmuk; the architect of the Adaptive Workload Manager; for an update on new enhancements in the latest release and best practices that will allow you to get the most out of this technology.

Speaker Bio

David Kalmuk is a Senior Technical Staff Member & Master Inventor and Data Warehousing Architect for the Db2 family products. David has contributed to the development of numerous technologies in Db2 over the years including BLU Acceleration, Workload Management, Monitoring, as well as much of Db2’s Processing and Communications architecture. He is currently leading efforts focused on evolving Db2’s Hybrid Cloud Warehousing Architecture.

Mainframe and distributed systems no longer live in isolation. We are both parts of an integrated IT environment. We learn from each other and in doing so we can take the best of both worlds in improving IT processes. DevOps is one such area where strong integration can bring huge benefits. In this presentation, we will discuss the benefits and provide suggestions for the way forward.

Speaker Bio

Vaughn Marshall 

With over 20 years experience in Information Technology, I’ve worked in a variety of areas including Development, Quality Assurance and Software Change & Configuration Management. I’ve consulted on designing, implementing and automating software development lifecycle processes for numerous Fortune 500 companies. I’m currently Broadcom Software’s product manager for Endevor. I love to work with customers to ensure my products meet the needs of today’s modern software factory.

Jim Endler 

Provides customer support for Broadcom Db2 solutions. Over 30 years of technical expertise in Db2, CICS and z/OS. Experienced in administration, performance and tuning, recovery and implementation. 

IMS clients worldwide have a wealth of business assets in the form of IMS applications and data. The ability to facilitate open access to these assets is not only a strategic part of digital transformation, oftentimes it is a critical part of maintaining a competitive advantage. IMS has provided a set of solutions that facilitate the integration of distributed environments with your existing applications. This session explains the concepts behind IMS Connect, OTMA and TPIPEs, and ODBM. It also describes how they are set up, how they support open access to IMS, and how all these functions provide an extensive base for evolving technologies.

Speaker Bio

Suzie Wendler is a member of the IMS team – Washington Systems Center. Over the past several years, her major responsibilities have included areas such as customer support, design implementations for IMS connectivity and, most recently, integration projects in support of the API economy. She has been with IBM supporting IMS for 35 years and prior to that was a customer for 10 years in the systems and application areas.

Coffee Break – Sponsored by SEGUS

10:15 – 11:15

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 migrated in the last year or so, this topic might be helpful to customers who are starting to thinking about activating FLs.

Speaker Bio

Chris 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.

As we prepare to deliver our final FeaturePaks (ModPaks) on Db2 V11.5 code base – lets take a look at the full picture of the wealth of new capabilities delivered on the Db2 V11.5 code base. There was a lot ! Many of the individual ModPaks brought incremental value on larger themes and items across Db2 and this is an opportunity to see the completed story. We will cover foundational items such as security, recoverability and availability as well as new areas of investment such as the ML optimizer and our multi-model enhancements.

Yes, security is still a hot topic in the world today but has anyone done anything new in IMS. In this session you will learn why security is important and how you can analyze the data you need without costing a fortune. We will discuss new options you will have in IMS database security. Plus what’s new in real-time data streaming for IMS data.

Speaker Bio

Nick Griffin has over 45 years of mainframe experience in Development, Systems and Database Administration for IMS, MVS, CICS/VSAM and VTAM applications. Nick has been a developer for IMS Monitoring code and managed a development group for a competitive software vendor. Nick managed large, complex, mission critical IMS database applications for a variety of Fortune 500 companies. Most recently spent 14 years as IMS Product Manager for a large tools vendor. Nick is currently assisting sales as IMS Product Account Manager.

Most IMS customers have not had to perform a recovery of an IMS database in a long time. But what if the unthinkable happened and you had to recover an IMS database or databases? Would you be able to do this quickly and correctly? What would be the impact to the business while the application was unavailable? This session will cover key concepts in developing a good recovery plan, processes to proactively monitor for situations which could affect your recovery plan, how to test and practice recovery on a regular basis, and how to simplify recovery.

Speaker Bio

Ron Bisceglia is a Distinguished Engineer and Principal Architect responsible for the design, development, and support for primarily the suite of IMS Tools. He has worked with IMS for over 30 years and has been involved in the development of database reorganization utilities, database propagation tools, database monitoring and analysis solutions, data replication, backup and recovery, and administration products.

Coffee Break

11:30 – 12:30

IBM Db2 AI for z/OS represents steps towards autonomous database management – simplifying database management efforts and enhancing system performance by embedding AI into Db2 for z/OS operations.
Db2 AI for z/OS can help reduce resource consumption and maintain Db2 for z/OS health. It currently offers smarter Db2 query optimization, a system performance assessment that combines machine learning and domain knowledge to enhance Db2 for z/OS operations and distributed connection control that helps prevent Db2 for z/OS connection flooding.
In this session, we will go through the exciting new features in Db2 AI for z/OS version 1.5. We will also highlight some of the miscellaneous enhancements in version 1.5 to gain a better understanding of how Db2 AI for z/OS can help drive even greater value out of Db2 for z/OS.

Speaker Bio

I’m the Product Manager for Db2 AI for z/OS. Prior to this, I’ve worked as Technical Specialist for Hybrid Cloud Integration and as an Architect for IoT Solutions. I have a Master’s in Electrical and Computer Engineering from University of Waterloo.

Security demands continue to grow and you need to be aware of all the tools and capabilities that Db2 provides you in this area. This session provides a review of the Db2 security landscape for those new to Db2 and to grizzled veterans. We will look at the various features and functions available across the four primary security domains: authentication ; authorization ; auditing ; and encryption. Along the way ; we will discover a couple of potential “gotchas” and some lesser known aspects of Db2 security.

Speaker Bio

Greg Stager is the security architect for Db2 LUW at the IBM Toronto Lab. Greg has been a member of the Db2 security development team since 2000, where he has worked on all aspects of security within Db2, including authentication, authorization, auditing and encryption.

IMS clients can now modernize legacy applications using Java and Cobol. Join this session to hear about the newest 31-64 bit COBOL-Java interoperability support and how IMS customers have applied these application patterns to allow them to leverage their existing modern language programming skill set, extend application development agility, and reduce time to market. We will also show a demo of a typical app modernization scenario where an existing COBOL app calls 64-bit Java code.

Speaker Bio

Haley Fung is the IBM Product Manager for IMS and Ansible for Z. She drives the product direction in building solutions for enterprise modernization and integration for IMS and automation solutions for Z. Haley is a frequent presenter at global technical conferences. Her deep technical expertise and her passion and dedication for customers have helped many IMS and Z customers to modernize and enhance their application infrastructures as well as automating their Z resources with Ansible.

Do you need to keep IMS database information for historical reference, auditing, compliance, or other reasons? Learn how BMC is enabling customers to retain their IMS database image copies years after the backup was performed, even after the current database definition may have changed.

Speaker Bio

Gary Turner has over 23 years of mainframe experience in Systems and Database Administration for IMS, CICS/VSAM, and MVS. Fifteen of those years was spent managing a large, complex, mission critical IMS database application for a Fortune 500 manufacturing company. Gary previously worked in product support for the BMC IMS Database Utilities, and this past year has transitioned to an IMS Solution Engineer for the entire BMC IMS product portfolio.

Lunch

1:30 – 2:30

IBM Administration foundation is a no charge replacement for administrative features in Data Studio and DSM. It provides an easy intuitive interface for accessing your Db2 z/OS catalog, managing Db2 plans/packages, IDAA tables, and the ability to optimize and tune SQL via visual EXPLAIN. Admin Foundation’s published API’s can be built into your own custom processes. Built upon the ZOWE open-source platform, you also get other applications that address other software on z/OS removing even more reliance on ISPF interfaces, therefore increasing productivity, and attracting new resources to the platform. This presentation will demonstrate these key features as well as how to order, download, and configure Admin Foundation and related components such as the IBM SQL Tuning Service.

Speaker Bio

Jim Wankowski is a Principal Solutions Advisor for Rocket Software. Jim specializes in data virtualization supporting IBM Data Virtualization Manager for z/OS and IDAA Loader for z/OS. Jim is a certified database administrator for Db2 z/OS V11 and as a technical specialist on IBM’s Cloud Pac for Data. Jim started his career as a programmer/analyst participating in the original Db2 MVS beta program in 1984. He has 35+ years of development, database administration, and tools experience with Db2 for both z/OS and LUW.

Optimal query access plans are essential for good data server performance and it is the query optimizer’s job to choose the best one. For most systems, only minimal tuning is necessary if automatic statistics collection is enabled. However, there are more complex scenarios and configurations where the query optimizer needs some help to get the best access plan and there are Db2 registry variables available to handle these. Query optimization registry variables are dynamic so they can be applied without restarting the database and they can also be specified using optimization guidelines. Attend this session to learn what is available and how they can help improve query performance for your database.

Speaker Bio

John is a Senior Technical Staff Member responsible for relational database query optimization on IBM’s distributed platforms. This technology is part of Db2 for Linux, UNIX and Windows, Db2 Warehouse, Db2 on Cloud, IBM Integrated Analytics System (IIAS), IBM Db2 Analytics Accelerator (IDAA) and Db2 Big SQL. John also works closely with customers to help them fully realize the benefits of IBM’s relational DB technology products.

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

Andrew Badgley is the Lead Product Owner for the Database Management for Db2 for z/OS Administration, Backup & Recovery, Performance, and Utility products at Broadcom. He has 23 years of experience with these products as Developer, Support Engineer, Support Engineering Manager, Scrum Master, and Product Owner. His areas of expertise include Db2 Log Reporting, Data Recovery, and Database Design. He is also the owner of the CA Db2 Tools 20.0 Validation Project.

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

Ulf Heinrich is the Director of Solutions Delivery at SEGUS Inc. He specializes in Db2 operations and performance tuning, focusing on the growing requirement for cost reduction and 24×7 operations. As a consultant at large customer sites, he has implemented database maintenance procedures and recovery strategies, and also experienced the pitfalls of recovery scenarios under realworld recovery pressure. His activities cover EMEA, as well as North America. As a member of SOFTWARE ENGINEERINGs Request Board he’s working closely with customers and the development labs.

Db2 warehouse capabilities provide a true Hybrid and multi-cloud approach to warehousing. In this presentation we examine the last warehouse offering and updates including enhancements to the core Db2 common SQL engine.

Speaker Bio

Mike Springgay is the Db2 Warehouse Architect focused on the common engine components. Prior to that he was responsible for extending Db2’s SQL compatibility features, routine infrastructure and client server connectivity.

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

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

Bring your laptop and explore, guided by our IBM experts:

This is an opportunity to get your hands dirty and play with various IMS and Tools functions:

  • Use the latest z/OS Connect EE V3 to discover, model, enable, and publish services and associated APIs based on trusted IMS transactions.
  • Understand how the API toolkit can be used to modify an IMS application to call out to a Rest API
  • Data resiliency – Explore what happens in a data sharing environment when an outage occurs
  • Convert a database to HALDB and learn how to size, allocate and populate HALDB partitions
  • Follow a step-by-step approach to build and populate an IMS Catalog environment and then use DFSDDLT0 to show the resources available
  • See how easily a distributed environment can access IMS mainframe data or even test out DDL with IMS
  • Understand, analyze & change IMS configuration parameters across multiple IMS systems
  • Use new tools for database administration
  • Understand performance analysis and IMS Connect workload management