Track E * - Constitution A

TRACK E sessions
held in Constitution A

sessions *livestreamed to VIRTUAL participants* noted below

 

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




Db2 for z/OS

 Db2 for z/OS
 Back To Basics

*livestreamed to VIRTUAL participants*

Tony Andrews, Themis, Inc.
IBM Champion 

Access paths formulated by the Db2 optimizer are a critical piece of the overall performance of a query. What are all the different access paths that may be chosen to fulfill an SQL request? How do they work? What affects its choices for a query?
Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

Chris Crone, Broadcom
IBM Champion 

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 now starting to.

Cross Platform

 Cross Platform
 Back To Basics

*livestreamed to VIRTUAL participants*

David Morris, Leidos

Developers can learn Db2 SQL performance tricks and best practices. When working with DBAs, developers will write better performing SQL, know what an Explain plan is, and optimize SQL queries.
Db2 for z/OS

 Db2 for z/OS

Roy Boxwell, Software Engineering GmbH
IBM Champion 

Db2 has grown tremendously over the years and there have been bits and pieces added on--that are either odd, strange, or exotic--which many people do not use or have even heard about.
Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

Sowmya Kameswaran, IBM 

Are you using Data Studio, Data Server Manager, or Data Management Console and wondering what the strategic direction is for developers and administrators for Db2 for z/OS? This session will present the next generation solutions: how they enable z domain experts and next generation developers to more efficiently develop, code, and debug applications that use Db2 for z/OS. Learn what the next generation no-charge administration solution for Db2 for z/OS is and what features are available and planned to provide an intuitive and modern administration capability to Db2 for z/OS creators and administrators. This will include: next generation no-charge code edit, debug, and tuning for developers; next generation no-charge manage, tune, administration solutions; and Robust API catalog to enable integration with other automated processes.
Cross Platform

 Cross Platform
 Back To Basics

*livestreamed to VIRTUAL participants*

Joe Geller, JPMorgan Chase
IBM Champion 

DBAs know that performance tuning requires understanding many aspects of Db2. Luckily, there is one key to unlock the knowledge needed. If you really understand how Db2 finds the data from a single table, the rest follows along.
Db2 for z/OS

 Db2 for z/OS
 Back To Basics

*livestreamed to VIRTUAL participants*

Emil Kotrc, Broadcom
IBM Champion 

In this presentation, we will focus on the main benefits of Db2 12 from the application developer perspective. In the first part, we will review some of the new SQL features in Db2 12 and we will also discuss their main advantages and possible use cases. The second part will be dedicated to other topics related to the application development, especially the continuous delivery model and the performance improvements. We will also show recent application development enhancements delivered in Db2 12 function levels.
Cross Platform

 Cross Platform
 Back To Basics

Daniel Luksetich, DanL Database Consulting 
IBM Gold Consultant & Champion 

This presentation will explore various Db2 testing techniques using widely available free tools. When in doubt, test! Fast and easy techniques will be demonstrated.

Db2 for z/OS

 Db2 for LUW

Mike Springgay, IBM

Data of interest no longer resides only in the data warehouse. Often access to data is desired from other databases, filesystems, and now commonly object storage. This presentation will look at the various technologies available in Db2 to access data residing outside the database. We will do a compare and contrast of each technology and provide recommendations on when to use which.
Db2 for z/OS

 Db2 for z/OS
 NEW

*livestreamed to VIRTUAL participants*

Roy Boxwell, Software Engineering GmbH
IBM Champion 

Are You Happy or Are You Still Deprecated?
Cross Platform

 Cross Platform
 Back To Basics

*livestreamed to VIRTUAL participants*

Craig Mullins, Mullins Consulting, Inc. 
IBM Gold Consultant & Champion 

Picture this scene: It is a little after 5 p.m. on a Friday and a chat message pops up with a note from a programmer that says "something isn’t working properly." Yes, that is the entire message. “Something” isn’t working properly. That’s all...

Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

Leila Hosseini, Ontario Government 

A DBA's Epic Journey


Db2 for z/OS

 Db2 for z/OS
 Back To Basics

*livestreamed to VIRTUAL participants*

Chad Reiber, BMC

Let's consider Db2 z/OS recovery over the years. First we were worried about hardware failures. Then we progressed to application software bugs driving recoveries. We also thought of Disaster Recovery as storms, but there are new storms on the horizon.

Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

Tom Ulvemann Jensen, Rocket Software

Make your existing application available to others as a Db2 stored procedure and Db2 REST service. In this presentation, we explore the options for making an existing PL/I, COBOL, or REXX application available as a Db2 stored procedure and/or a Db2 REST service. Topics discussed are: Creating a stored procedure wrapper, Capturing printouts and returning them as result sets, Creating a Db2 REST service, and Managing Db2 REST services.

Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

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 most of the risks/challenges – as done by real customers.

Db2 for z/OS

 Db2 for z/OS

Sowmya Kameswaran, IBM

Lets learn how Integrated Synchronization(In-Sync), a transformative capability that provides an integrated, low-latency data coherency between Db2 for z/OS and the Db2 Analytics Accelerator (IDAA) powers the IDAA to deliver near real-time HTAP