Track B

Room B

To view additional details about each session,
click the + icon or session title.




Db2 for z/OS

 Db2 for z/OS

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.      


Db2 for z/OS

 Db2 for z/OS

Adrian Collett, Expertise4IT s.r.l.
IBM Gold Consultant & Champion 

Have you ever had a performance problem with unexplained long elapsed times? If so, the chances are that your monitor or performance data will show that it was due to elongated ACCUMULATED WAIT TIME BECAUSE OF PAGE LATCH CONTENTION(QWACAWTP). When this occurs during the peak period it can have a devastating effect on your system with threads queuing and CPU consumption going through the roof, leading to a general slow-down of the whole system. Unfortunately, this is one of the least documented, and least understood, reasons for wait-time in Db2 processing. This presentation will reveal the mysteries behind this “black hole” of Db2 processing and examine the main causes of Page Latch Contention and explain why and how it can have such a disastrous impact on your environment. Through the use of real-life examples, the presentation will provide guidelines on how to eliminate, or at least reduce, these causes of Page Latch Contention thus making your systems more reliable and efficient.

Db2 for z/OS

 Db2 for z/OS

Steen Rasmussen, Broadcom

The most commonly used methodology implementing Db2 schema changes is to compare new/old structures and create the worklist to execute the changes – being online or deferred or the DBA nightmare of UDCL. This approach can result in some surprises, like the requirement to fall back or access path changes due to altered indexes/tables/columns/programs. This presentation will illustrate how a completely different approach can be implemented to mitigate the most of the risks/challenges – as done by real customers.

Db2 for z/OS

 Db2 for z/OS

Emil Kotrc, Broadcom
IBM Champion 

Are you ready for Db2 VNext? You should definitely start asking! This presentation will help you get answers to your initial questions and will bring you closer to the migration path.

Db2 for z/OS

 Db2 for z/OS

Todd Mollenhauer, BMC Software

Multi-Table Tablespace deprecation is still on many Db2 shop’s TO-DO list. The conversion process requires lots of DBA time and effort, even with improvements to the process with FL508 (MOVE TABLE). In this session, we'll look at four techniques for converting Multi-Table tablespaces to Single Table tablespaces.
Db2 for z/OS

 Db2 for z/OS

SMike Toppins
IBM Champion 

Evolution of Hybrid Cloud, Containers, Kubernetes, AI/ML and explosion of new data formats like JSON or Graph has left CIOs in search of Polyglot or Multi-modal Databases that satisfy their evolving enterprise needs.  Driven by this demand IBM Db2 LUW has evolved into a Hybrid Database providing wide range of deployment patters and advanced capabilities that satisfy modern age requirements. Join this exciting session to learn of latest advancements in IBM Db2.  From core engine enhancements for OLTP and Warehouse, to Graph to Object Store support to Db2 solidifying its leadership in Containers.  This session will paint a picture of the next generation of RDBMs.

Db2 for z/OS

 Db2 for z/OS

Tom Glaser, MasterCard
IBM Champion 

Are you monitoring what’s important for Db2 running on z/OS. Do you really need to monitor, memory, disk storage, network, indoubt threads, etc? In this session, I will go over what's important to monitor from our perspective and what tools we use.

Db2 for z/OS

 Db2 for z/OS
 Back To Basics

Toine Michielse, Broadcom
IBM Champion 

Understanding what Db2 explain tells us can be intimidating to less experienced application developers and Dba's. Breaking down complex access paths to the basic components helps finding the pain points in an SQL statement.

SQL is a very powerful language. To support it the Db2 optimizer has many ways to get to the data and combine partial results into the final result set. even though many tools are available to visualize the access path Db2 plans to execute, the output can be complex to understand. Breaking it down to the the basic elements and understanding the way data is accessed by those elements will enable less experienced developers and DBA's to find performance problems quickly.

Cross Platform

Cross Platform

Ken Shaffer, Aerodata Inc.
IBM Gold Consultant & Champion 

As our development teams move to Agile methodologies and automate their delivery processes, we DBAs need to be involved and included in this process. How do we automate our database schema and data changes and how do we insert them into the automated CI/CD pipelines? Database changes have unique challenges and requirements. For instance, they must be immutable, handled serially, cumulative, and usually must only be applied once. As an example, we will discuss using Liquibase to deploy and track Db2 LUW changes as part of a pipeline. We will discuss several issues that we have encountered in the past when doing manual and semi-automated deployments. These issues may include Error identification, handling, and determination (choosing to ignore Db2 errors and warnings that truly ok); rollbacks; schema version identification; and, running deployments multiple times. Then we will discuss how a tool like Liquibase can help solve these problems and allow us to better integrate our database changes into the process.

Db2 for z/OS

 Db2 for z/OS

Michal Bialecki, IBM Silicon Valley Lab

Every Db2 z/OS shops has it's own rules regarding how and when to run housekeeping tasks. This presentation will cover best practices for DB2 z/OS housekeeping, which includes REORG, RUNSTATS, COPY, and REBIND performed by Db2 administrators. These best practices are based on customer's scenarios and on results from 360 Db2 for z/OS Continues Availability Assessment Studies performed by Db2 z/OS SWAT team, which Michal is part of under John Campbell's guidance."
Db2 for z/OS

 Db2 for z/OS

Vasudevan Natarajan, Walmart

Db2 to RACF Security Conversion – A Walmart Perspective on Conversion Approach 

Db2 for z/OS

Db2 for z/OS
Back To Basics

Steve Solomon, BMC

Back to Basics: Getting Started with Db2 for the New DBA & Developer. Why do people think mainframes are expensive? Tips for DBAs and Application Programmers to help reduce costs.

Db2 for z/OS

 Db2 for z/OS

Gayathiri Chandran, IBM

Multi-factor authentication (MFA) is essential for establishing secure, industry-compliant connections to Db2 for z/OS. MFA requires more than a single credential for authentication. IBM Multi-factor authentication for z/OS solution provides the MFA capability on z/OS. This session will review MFA and Db2 for z/OS enhancements to establish MFA connection from tools such as Data Studio and from distributed sysplex workload balancing clients. 

Db2 for z/OS

 Db2 for z/OS

Robert Tilkes, IBM

In the world today where Ransomware attacks are crippling businesses, it is important to take security and vulnerability management seriously. We must take action to protect our most valuable asset in Db2 the Data.

Db2 for z/OS

 Db2 for z/OS

Tammie Dang, IBM

When system resources are shared among transactions, user queries, web requests, distributed application requests from different clients, and batch programs, customers will often need to control how those resources are used. To prevent certain unexpected run-away SQL statements, the Db2's Resource Limit Facility can be used to set upper limits, before they run and during their execution. This presentation discusses how to limit CP and other system resource usage in the processing of dynamic and static SQL statements using the Db2 Resource Limit Facility.

Db2 for z/OS

 Db2 for z/OS
 NEW
 Back To Basics

Robert Andresen, Broadcom

It’s been said that a picture is worth a thousand words. When monitoring performance a graph is far easier to understand than looking at thousands of lines of performance reports. Most everyone has access to Excel or one of the shareware spreadsheets. Spreadsheets let us make sense of all these metrics; helping identify what changes occurred and when. We can also see correlations between different metrics to understand how our applications may be competing for resources with each other.