In the session I will talk about the way DBA Team has been following to adopt modern automation tools and agile practicies. The presentation will cover our transformation from manual scripts and internal GC tool mostly used in classic infrastructure to Db2 automation in both classic and cloud PaaS services. At this moment we are in the middle of that transformation and hopefully some challenges we have met and clues I can provide can be helpful to you. The toolset, which will be presented include Github, Ansible and AWX but I will also touch other tools we use like Slack, BOX or Terraform. During presentation I will also describe one of the agile project related to gather privileged accesses in Db2 the DBA team built as an example of agile methodology and automation used in practice.
VSCode has an ever growing array extensions and provides access to a wealth of plugins. As a result, it has become a fantastically complete environment for Db2 application developers (and other roles that work with Db2 for z/OS data). In this presentation I plan to provide an overview of the coolest plugins / extensions and show how they can be used. Covering various DB2 development activities, including reporting, visualising and analyzing data
An access path selected by Db2 drastically affects how well or how badly your SQL statement and overall application perform. Developers should be familiar with what the access path is and how to read it, while database administrators need to be able to maintain workload stability avoiding performance degradations and resource consumption spikes. This session will talk about how to interpret an access path with EXPLAINs, discuss how to influence the optimizer, and cover the ways to maintain and manage access paths for both static and dynamic SQL statements
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 - 10th - 13th June 2024