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.
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.
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.
European SQLAdria Seminar – Vodice 2024
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.
8 reasons to come Speakers Events Contact
VODICE - 12th - 15th June 2023