104

Keynote session: Db2 & the Lakehouse–Let’s Talk About the Future

Date: 
Tuesday, 14 June, 2022 - 09:00 - 10:15
Program: 
LUW Track
Speaker: 
Joshua Kim
Speaker: 
Miran Badžak

Db2 continues to run the world’s mission critical workloads. It is the indispensable database that powers a significant majority of the Fortune 500 companies where downtime is associated with significant monetary and reputational risk. This talk will cover recent advancements we’ve made to the Db2 family of products. And we’ll cover our long-term product strategy and roadmap for the business – covering both OLTP and OLAP. During this talk, we’re also going to cover the concept of an analytics lakehouse and how that applies to the Db2 portfolio. Lakehouses are a hot topic in the Data Management space today. But, what are they? How can they help you and your users’ productivity? How can they help you lower your costs? We’ll explore.

Db2 Problem Determination and Troubleshooting Workshop

Date: 
Thursday, 16 June, 2022 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Rajib Sarkar

The popular Db2 problem determination seminar, updated with the newest Db2 11.5 problem determination techniques and hands-on exercises! Learn how to identify and resolve database hangs, crashes, performance problems, and data corruption issues. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution. Topics covered: Crashes/Traps; Data Corruption; FODC; Hangs; Latching; Performance. Attendees will be able to characterize a problem in order to expedite resolution, learn how and what data to collect during intermittent hangs, slow-downs, and other frequent problems, and understand Db2 Support's methodology in troubleshooting Db2 and even non-Db2 hiccups. The seminar contains live demos during which the audience will be given an opportunity to perform an interactive investigation of selected problems.

Panel Discussion

Date: 
Wednesday, 15 June, 2022 - 13:15
Program: 
LUW Track

Monitoring and troubleshooting performance of stored procedures

Date: 
Wednesday, 15 June, 2022 - 12:30 - 13:15
Program: 
LUW Track
Speaker: 
Kamil Kuduk

Assess your security attack surface in your Db2 LUW

Date: 
Wednesday, 15 June, 2022 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
Roland Schock

Break

Date: 
Wednesday, 15 June, 2022 - 11:00 - 11:30
Program: 
LUW Track

SQL Tuning Basics: Simple Steps to SQL Sufficiency

Date: 
Wednesday, 15 June, 2022 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
Damir Wilder

The purpose of this presentation is to give an overview of methods used in everyday SQL tuning of transactional databases, when an SQL query or a Batch job is underperforming and a quick solution is required. Describe generally available tools in DB2 that can assist in the daily SQL tuning and/or SQL performance problem detection. Describe how to find out what is happening right now in a database. Describe how to gather historical performance data for a database. Describe how to analyse locking issues. Describe how to identify the hottest tables and SQL queries in a database. Show several real-life scenarios of poorly performing SQL and what was done to improve it.

Wrapping up Db2 V11.5 - A holistic look at Db2 V11.5 - V11.5.7

Date: 
Wednesday, 15 June, 2022 - 09:00 - 10:00
Program: 
LUW Track
Speaker: 
Les King

Db2U – installation from scratch

Date: 
Tuesday, 14 June, 2022 - 14:00 - 15:00
Program: 
LUW Track
Speaker: 
Marcin Marczewski

Break

Date: 
Tuesday, 14 June, 2022 - 13:00 - 14:00
Program: 
LUW Track
Syndicate content  

sqladria

SQL Adria is the independent, non-profit organization that gathers relational database users for Croatia and Slovenia. It was founded 1994. and in the same year it has become the regional user group.

Follow us

facebook
linkid
twitter

 

Events in 2023

VODICE -  12th - 15th June 2023