89

Db2 Problem Determination and Troubleshooting Workshop

Date: 
Thursday, 8 October, 2020 - 09:00 - 16:00
Program: 
LUW Track
Speaker: 
Pavel Sustr

The popular Db2 problem determination seminar, updated with the newest Db2 11.1 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: Performance; FODC; Hangs; Latching; Crashes/Traps; Data Corruption. 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, 7 October, 2020 - 13:15
Program: 
LUW Track

(Adaptive) Workload Manager in Db2 11.5 deep dive

Date: 
Wednesday, 7 October, 2020 - 12:30 - 13:15
Program: 
LUW Track
Speaker: 
Marcin Marczewski
During this session new features in workload management in Db2 will be discussed. 
Session participants will also learn how to configure/adjust WLM structures to handle unsual workloads with proper priorities
- for custom application workloads all the configuration steps will be presented as part of demo.

Db2 and Cloud Pak for Data

Date: 
Wednesday, 7 October, 2020 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
Andreas Christian
IBM® Cloud Pak for Data is a cloud-native solution that enables you to put your data to work quickly and efficiently. 
Your enterprise has data. Lots of data. You need to use your data to generate meaningful insights that can help you avoid problems and reach your goals.
 
But your data is useless if you can't trust it or access it. Cloud Pak for Data lets you do both by enabling you to connect to your data, govern it, find it, and use it for analysis. Cloud Pak for Data also enables all of your data users to collaborate from a single, unified interface that supports a large number of services that are designed to work together.
Cloud Pak for Data fosters productivity by enabling users to find existing data or to request access to data. With modern tools that facilitate analytics and remove barriers to collaboration, users can spend less time finding data and more time using it effectively.
 
The session includes a demo that shows you how you can provision a new Db2 database in Cloud Pak for Data and how you can work with that database.

Break

Date: 
Wednesday, 7 October, 2020 - 11:00 - 11:30
Program: 
LUW Track

Managing multiple tenants under one roof

Date: 
Wednesday, 7 October, 2020 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
Matthias Nicola

Providing database capabilities for multiple applications or multiple different groups of users always raises the question of the "right" level of isolation. Separate Db2 databases or instances provide maximum isolation but incur additional resource consumption and administration overhead. Using separate schemas in a single database allows for consolidation but might not provide sufficient isolation. This session describes new capabilities in Db2 for managing multiple tenants in a single database. 

End of DSM. What is IBM Database Management Console?

Date: 
Wednesday, 7 October, 2020 - 09:00 - 10:00
Program: 
LUW Track
Speaker: 
Marcin Marczewski
During this sessions new, enhanced tool for Db2 management will be introduced - Data Management Console
which replaces old DSM. New features and enhancements will be demonstrated during a practical tour (extended demo)
Participants will learn how to detect and monitor problematic queries, write statements and see access plans.
This session will also show how Open RESTful API for webconsole can be used for team collaboration.

Managing JSON data inside Db2 database

Date: 
Tuesday, 6 October, 2020 - 15:30 - 16:30
Program: 
LUW Track
Speaker: 
Marcin Marczewski
This session will start with a short introduction to JSON in data. The main part of this presentation will be devoted
to a practical demo showing step by step how Db2 functions can be levereged to store, manage and transform JSON data for modern applications.

Db2 Go-programming lab

Date: 
Tuesday, 6 October, 2020 - 14:00 - 15:30
Program: 
LUW Track
Speaker: 
Andreas Christian

Docker, Kubernetes and many other products are implemented in the Go language. Since Go is in the top ranks of most wanted programming languages, this tutorial provides an introduction to Go and explains how to write Db2-based Go applications. You work with the Db2-Go API and learn how to implement programs that retrieve data from Db2 and also modify data. In addition, you get experience with Visual Studio Code and it's Db2 specific extensions. You access a virtual machine in the Cloud that has all required software pre-installed and can be used free of charge for up to one week.

Break

Date: 
Tuesday, 6 October, 2020 - 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 2021

VIRTUAL EVENT - 27th - 28th May 2021