102

Break

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 14:45 - 15:00
Program: 
z/OS Track

WLM for Db2 workload: things you must know

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 13:45 - 14:45
Program: 
z/OS Track
Speaker: 
Cristian Molaro

Break

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 12:45 - 13:45
Program: 
z/OS Track

Fantastic online nightmares and where to find them

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 11:45 - 12:45
Program: 
z/OS Track
Speaker: 
Javier Estrada Benavides
Distributed applications migrating to the Mainframe is a common trend in many places, and their administration requires a different mindset compared to traditional environments as we’re also facing unique scenarios and problems. 
In this presentation, we’ll have a look at some common pitfalls in managing your distributed applications: From planning to important administration actions to take. Luckily, Db2 12 for z/OS also brings additional advantages to our arsenal and we need to revisit how we evolve our DBA practices.
 
Objectives:
The audience will learn about common best practices on how to plan for distributed applications coming to Mainframe (or existing ones).
The audience will learn about new and important features in Db2 12 for z/OS that will help us in managing distributed applications.
The audience will learn about some of the common nightmares (from meetings to technical measures), and how to prevent or deal with them.

Break

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 11:30 - 11:45
Program: 
z/OS Track

Experiences with Db2 12 Continuous Delivery - an Update

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 10:30 - 11:30
Program: 
z/OS Track
Speaker: 
Emil Kotrč
Db2 12 introduced the mechanism of continuous delivery. In this presentation we will explain the concepts of continuous delivery and will show what does it bring to the application developers and database administrators. We will also discuss experience with the continuous delivery model, point out a few items that need extra attention, and will show what is included in the existing function levels.
This updated presentations will show what is new in this area and will briefly speak about the challenges for a typical vendor.
Objectives
1. Principles of continuous delivery
2. Explanation of code, catalog, and function levels
3. Benefits of continuous delivery for application developers and database administrators
4. Experience with continuous delivery

Break

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 10:15 - 10:30
Program: 
z/OS Track

Db2 Analytics Accelerator – Driving for Optimum Performance

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 09:15 - 10:15
Program: 
z/OS Track
Speaker: 
Eberhard Hechler

In this presentation, we present techniques to improve the Accelerator performance, incl. defining and maintaining distribution and organizing keys (synopsis tables), and to define a set of rules for the Db2 for z/OS optimizer via heuristic routing criteria by setting the maximum total table cardinality, the maximum estimated total cost, and the maximum number of rows for the result set of a query. We furthermore explore profile table setting in Db2 for z/OS to control access to the Accelerator by specifying the CURRENT QUERY ACCELERATION register value for remote applications that meet the criteria that are defined in the corresponding Db2 for z/OS profile tables. In addition, we review efficient zParm settings in coexistence environments with the Accelerator v5 and v7, and review enhancements with Accelerator-only Tables (AOTs) in HA/DR environments.

Introduction

Seminar: 
European SQLAdria Seminar – Virtual Event 2021
Date: 
Thursday, 27 svibanj, 2021 - 09:00 - 09:15
Program: 
z/OS 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 2024

VODICE -  10th - 13th June 2024