Track D * - Republic

TRACK D sessions
are in Republic

sessions *livestreamed to VIRTUAL participants* noted below

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




Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Ferdinand Prahst, ITGAIN Consulting Gesellschaft für IT-Beratung mbH

IBM Champion 

Maintenance is one of the oldest but still one of the most important parts of a DBAs work. Tools like Ansible and AWX can help the Admin (or, in case of DevOps, the Devs) to leverage their daily work and manage even a high amount of systems with ease. This session will include info about basic architecture and workflow of Ansible and AWX; integration options with Db2 (unix only); a complete backup, reorg and runstats playbook and job template; and give examples for other usecases with Db2.
Db2 for LUW

 Db2 for LUW
 Back To Basics

*livestreamed to VIRTUAL participants*
Paul Turpin, Truist
IBM Champion 

What goes on in the package cache is often a mystery. Performance of SQL can be dramatically impacted by the package cache, so understanding how it works is very important. Newly added in 11.5 are details about SQL failures.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Mark Gillis, Triton Consulting Ltd
IBM Gold Consultant & Champion 

Even with the most sophisticated self-tuning and self-administering database, it is still useful to have it checked over. Technology is becoming increasingly more adept at examining itself, recommending improvements, and highlighting potential problems long before they become an issue. But would you still fly on an airliner that was never serviced and had not flagged problems to the ground crew when they thought they should? Whether your database is on-premise, in the cloud, or a hybrid, an examination of its configuration, design and performance is highly advisable. With the combined expertise of over a century of Db2 knowledge, we’ve encapsulated the most critical and some of the more esoteric issues into a single Jupyter Notebook, allowing your database to be given a health-check wherever it resides and whatever it does.
Db2 for LUW

 Db2 for LUW

Christian Zentgraf, IBM

The Db2 Text Search features provides extensive capabilities for searching data stored in binary and string type columns. This presentation highlights the capabilities of Db2 TextSearch.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Norbert Munkel, ITGAIN GmbH

Even in an ever expanding Ansible universe with lots of available models, you get into situations when the call of an external script (shell, Perl, Python) is the way to achieve your goal. Maybe you already have a scripted solution ready, but you want to integrate it with Ansible. This presentation shows some obstacles and how to avoid them by keeping your Ansible role self-aware and by optimizing your output for human reception. We will have a look into what the complex data structure and the shell module provide as a result set and how it can affect memory consumption and performance when running multiple tasks against multiple Db2 servers.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Keri Romanufa, IBM

Learn about Control File Recovery, aka Control File Mirroring, one of the newest features added in Db2 for Linux, UNIX, and Windows version 11.5.7.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Sigen Chen, Leidos

We migrated Db2 Databases on a Solaris 10 HA cluster to Db2 HADR on xLinux. In addition to the cost savings, system availability and reliability are improved. We will discuss some technical challenges for cross platform database migrations and their solutions.
Db2 for LUW

 Db2 for LUW

Christian Zentgraf, IBM

This session discusses various methods of spatial filtering to enhance query performance when using spatial relation functions.
Db2 for LUW

 Db2 for LUW

Hao Qi, IBM Canada Ltd.

The prologue of this feature debuted as Technical Preview in Db2 V11.5.4.0 where introduction of Pacemaker as the new "cluster manager of choice" was announced. Act One followed five months later in Db2 V11.5.5.0 with production level support of 2-node HADR configuration on Linux. Integrated bundling and installation of Pacemaker anchored Act Two in the ensuing V11.5.6.0 release around mid 2021 to enhance up & running experience, along with other valued features added. The Third Act serves as the climax of the entire journey where it intends to cover other popular type of HA configurations while adding other improvements. We will cover details on 2-node Active/Passive with file system failover, mount point monitoring, quorum enhancements, as well as alternate configurations on cloud deployment. Finally, we'll provide a sneak peek at our road to the final chapter.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
George Baklarz, IBM

Do you need access to Db2 data from within a Jupyter notebook? This session will explore how Db2 Magic commands integrate into Jupyter notebooks to make it easy to move data between Db2, your notebook, and back again!
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Michael Tiefenbacher, mip GmbH
IBM Gold Consultant & Champion 

Data Warehouses store historical data and Db2 Temporal Tables offer time travel queries to dig the gems. Sounds like a perfect match? This session will show challenges and solutions to make it a match!
Db2 for LUW

 Db2 for LUW
  NEW

*livestreamed to VIRTUAL participants*
Calisto Zuzarte, IBM

Harnessing the Power of OLAP Functions
Db2 for z/OS

 Db2 for z/OS

*livestreamed to VIRTUAL participants*

Robert Catterall, IBM 

Some aspects of Db2 for z/OS technology are plain as day, while others are less so. In this third iteration of my "Let Me Make This Clear" presentation, I'll aim to take you from "Uh" to "Oh!" 

Db2 for LUW

 Db2 for LUW
 Back To Basics

*livestreamed to VIRTUAL participants*
John Hornibrook, IBM Canada

One of the most important factors in query performance is the access plan chosen by the Db2 query optimizer. Understanding the query access plan is essential to understanding query performance and the explain facility is the way to get the access plan. But SQL statements can be issued in different ways (dynamic, static, procedures, application programs) and access plans can exist in a variety of contexts (system catalogs, dynamic statement cache, monitoring tables). So getting the correct access plan for the correct statement can sometimes be a challenge. This presentation will cover the most important techniques for collecting and using explain information so that you can quickly and effectively understand your access plans in order to achieve and maintain the best possible query performance.
Db2 for LUW

 Db2 for LUW

*livestreamed to VIRTUAL participants*
Nataliya Prokoshyna, IBM Canada

Learn the process for how Db2 addresses security vulnerabilities, to read and understand a security bulletin, and to be in a better position to respond when fixpacks and special builds are released. Security vulnerabilities are a current fact of life with software. Db2 participates in an IBM process known as the Product Security Incident Response Team (PSIRT), which is responsible for fixing and disclosing security vulnerabilities. Communication of these issues to customers is done through security bulletins, which are often obscure and confusing. This presentation will lift some of the fog surrounding the process and make the security bulletins easier to understand. The topic of timelines for fixes will also be discussed.
Db2 for LUW

 Db2 for LUW

Jason Sizto, IBM Corp

In this session, you will learn how to use the monitoring and query tuning functions in Db2 Data Management Console to identify Db2 performance bottlenecks and resolve query performance problems with tuning recommendations.