104

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

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