Denis Tronin

Speaker Details

Bio

Denis Tronin is an experienced IT professional and product manager skilled in mainframe (Db2 for z/OS, System Performance, Workload Automation), API management (Zowe API Mediation Layer) and DevOps domains. He is an IBM champion and an active speaker at major mainframe conferences.

Past presentation
13 lipanj 2024
09:00 - 16:00
European SQLAdria Seminar – Vodice 2024 Automate Db2 Schema Deployment using Ansible Playbooks
'Are you exploring how to exploit Ansible on your DevOps journey? Or, you may be well on your way towards standardizing on Ansible.  Either way, our workshop will introduce you to a Broadcom developed Ansible collection that will empower you to automate your Db2 for z/OS Schema Management the Ansible way.
This Ansible collection will be a powerful tool to enable a developer to provision the Db2 environment needed to test an application. It also has the necessary capabilities to automate deployment of any schema changes. In this workshop you will have the opportunity for an instructor-led hands on experience with the Broadcom DBM-Db2 Ansible collection. You will learn ways to use the collection in ad hoc mode as well as understand how to develop Ansible playbooks to achieve your goal.
The objectives of the workshop are:
- Understand how Db2 Schema and data provisioning can be modernized and how it support DevOps
- Get familiar with Ansible ad hoc commands
- Understand Ansible playbooks and the environment in which they execute
- Develop a simple playbook to deploy a Db2 for z/OS Schema change
As this is a hands-on workshop, please bring your laptops with you.

12 lipanj 2024
11:30 - 12:30
European SQLAdria Seminar – Vodice 2024 Get Cozy with Test Data Management for Db2 for z/OS

A well-established Test Data Management (TDM) ensures the availability of realistic and representative data for testing purposes. DBAs benefit from an efficient test data provisioning process, while developers leverage diverse test data sets to validate application functionality, performance, and scalability, ultimately leading to higher-quality software releases. In this session, we will explore best practices for establishing TDM processes for Db2 for z/OS data. We will review and discuss possible approaches and techniques, including the additional value those with Broadcom Utilities can derive.


11 lipanj 2024
14:15 - 15:15
European SQLAdria Seminar – Vodice 2024 Get Cozy with Db2 for z/OS REST Services

RESTful API (Application Programming Interface) support has been introduced to strengthen the position Db2 for z/OS plays in the new mobile application era. This presentation will equip the audience with a solid understanding of REST APIs in general and how to apply them to Db2. Administrators will learn how to create and maintain the services while developers will get familiar with the Db2 specifics.


15 lipanj 2023
09:00 - 16:00
European SQLAdria Seminar – Vodice 2023 DevOps meets Db2 for z/OS application, the bigger picture….

DevOps is a topic that can touches many different areas of the IT processes related to development, implementation and management of applications. The benefits of applying established DevOps techniques are well known by now. Yet, implementing them can be overwhelming. Where to start? What to do next? What will give me "the biggest bang for my kuna Euro…". In this seminar we will discuss several different areas of the lifecycle of  Db2 for z/OS application. We will have focus on Schema and Application build, various types of testing and deployment.


14 lipanj 2023
12:30 - 13:15
European SQLAdria Seminar – Vodice 2023 Explain explained. What is explain telling me and how to optimize

SQL is a very powerful language. To support it the Db2 optimizer has many ways to get to the data and combine partial results into the final result set. even though many tools are available to visualize the access path Db2 plans to execute, the output can be complex to understand. Breaking it down to the basic elements and understanding the way data is accessed by those elements will enable less experienced developers and DBA's to find performance problems quickly.


13 lipanj 2023
15:00 - 15:45
European SQLAdria Seminar – Vodice 2023 Get Cozy with Ansible on z/OS

Ansible is a powerful and widely used tool to automate management of various systems including z/OS. This presentation will introduce Ansible to the audience and walk through the z/OS related components. We will learn what it takes to set it up on both server and client sides. And finally will explore and demonstrate how Db2 for z/OS management can be simplified and automated with Ansible.


13 lipanj 2022
15:00 - 16:00
European SQLAdria Seminar – Vodice 2022 Get Cozy with Access Path Management in Db2 for z/OS

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


06 listopad 2021
12:30 - 13:15
European SQLAdria Seminar – Šibenik 2021 Get Cozy with Auditing Access to Db2 for z/OS

Do you want to know when unauthorized access to Db2 has been attempted? Maybe learn who messed up your data? In this presentation we will learn what Db2 for z/OS has to offer for security auditing. The audience will get a good understanding of audit practices, traces and policies.


06 listopad 2020
15:30 - 16:15
Get Cozy with Db2 for z/OS EXPLAIN

Db2 for z/OS EXPLAIN is one of the core database capabilities to ensure quality of developed SQL statements. In this session we will refresh the EXPLAIN basics, get familiar with best practices for analyzing SQL access path and dive into recent Db2 changes.


While IBM z/OS Management Facility (z/OSMF) is a core z/OS component since version 2.1, still not everybody is familiar what it is and how it would help with system and database management. In this session we will focus on how Db2 users could use z/OSMF workflows to simplify and automate some of common Db2 tasks. We will also cover what Zowe (mainframe open source project) has to offer for working with z/OSMF workflows.


28 svibanj 2019
11:00 - 11:45
European SQLAdria Seminar – Šibenik 2019 Fun with Db2 RESTful API

Let's talk about how Db2 for z/OS implements native RESTfule data APIs and discuss how to use and maintain them.


26 svibanj 2019
16:45 - 17:15
European SQLAdria Seminar – Šibenik 2019 Zowe and Brightside

13 lipanj 2018
10:00 - 11:00
European SQLAdria Seminar – Šibenik 2018 Get Cozy with Db2 for z/OS REST Services

Db2 RESTful API support has been introduced in release 11 of Db2 for z/OS and has strengthen Db2 position in the new mobile application era. This presentation will equip the audience with a good understanding of REST APIs in general as well as how to deal with them in Db2: administrators will learn how to create and maintain the services while developers will get familiar the Db2 specifics.


10 lipanj 2018
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2018 What’s new in CA – MfaaS

13 lipanj 2017
15:00 - 16:00
European SQLAdria Seminar – Šibenik 2017 DB2 System Profile Monitoring

DB2 System Profile monitoring is available as of DB2 9, but it is still not widely used and known. However this is a quite strong DB2 capability that can help with variety of situations: manage and monitor threads and connections, model DB2 production environment, tune application behaviour. This presentation will equip you with a good understanding of DB2 profiles in general, as well as when and how to best use them.


12 lipanj 2017
16:00 - 17:00
European SQLAdria Seminar – Šibenik 2017 The Tracing Guide to the DB2 Galaxy

Have you ever wanted to understand the behaviour of your DB2 system, determine what is going right or wrong and why? DB2 tracing is one of the strongest, but least understood, mechanisms that is out there to answer exactly these questions. In this presentation you will get a solid understanding of DB2 instrumentation facility, you will be guided through the variety of DB2 traces and learn how they would help to address system monitoring and tuning challenges. You will also get familiar with the newest and most useful tracing capabilities introduced in the latest releases of DB2.


11 lipanj 2017
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2017 What’s new in CA DB2 Performance Tools?

13 lipanj 2016
14:00 - 14:45
European SQLAdria Seminar – Šibenik 2016 Get Cozy with DB2 for z/OS Stored Procedures and UDFs

At this presentation the audience will learn the stored procedure and user-defined function concepts in DB2 for z/OS. The application developers will get familiar with the recent enhancements in this area and get educated on how to monitor and tune these procedures and functions, while the database administrators will learn how some of their common tasks can be covered with a set of administrative procedures available with DB2 out of the box.


12 lipanj 2016
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2016 What’s new in CA DB2 Performance Tools?
Dive into r19 features in IDB2
Future plans for IDB2

16 lipanj 2015
14:00 - 15:00
European SQLAdria Seminar – Dubrovnik 2015 Lost without a trace
Tracing is one of the strongest, but least understood, mechanisms available to you with DB2. It gives you the ability to lift up the hood, helping you determine what is going wrong and why. So don't be lost for answers when DB2 hangs or consumes to many resources, start tracing. This presentation will equip you with a good understanding of DB2 traces in general, as well as when and how to best use them. It will also show you the most useful tracing abilities available to you with DB2 10 and 11. The presentation will be based on techniques and practices that can be applied with any DB2 performance monitoring tool.
In this session, you will learn about :
  • DB2 tracing mechanism
  • Most useful trace data and related use cases
  • New trace information in DB2 11

15 lipanj 2015
14:15 - 15:15
European SQLAdria Seminar – Dubrovnik 2015 What Application Developers need to know about SQL in DB2 for z/OS?
Applications often rely on a Database to manipulate data, typically using SQL statements. DB2 for z/OS is one of those databases; one of the most robust, reliable and secure for that matter. However, Application Developers need to keep in mind that DB2 for z/OS has its SQL specificities. For instance, the SQL available in DB2 for z/OS is compliant with SQL:2003 standard. What does it exactly mean? What IBM is doing to raise the level of the DB2 SQL to later standards? How does this affect Application Developers – ever heard of APPLCOMPAT? What are the new SQL capabilities introduced in DB2 over the years? Is there something new in this area when using DB2 10 or DB2 11?
In this session, you will learn about :
  • Incompatible SQL changes in DB2 for z/OS
  • How to address incompatible SQL changes  
  • New SQL capabilities in DB2 for z/OS

14 lipanj 2015
18:00 - 18:45
European SQLAdria Seminar – Dubrovnik 2015 What’s new in CA SYSVIEW for DB2?
CA SYSVIEW Option for DB2 for z/OS is a real-time monitor that provides database administrators with the tools they need to maximize DB2 system and application performance. As both DB2 applications and DB2 itself increase in complexity and grow in size, optimizing performance is becoming increasingly critical. In this presentation we will discuss what CA SYSVIEW for DB2 offers in order to address these challenges, review its recent improvements and speak about product strategy and explain specific areas the development is working on.
In this session, you will learn about :
  • How CA SYSVIEW for DB2 helps monitoring DB2 performance
  • What are the new features of CA SYSVIEW for DB2 18.0
  • High-level plans for the next release

25 svibanj 2014
18:45 - 19:15
European SQLAdria Seminar – Dubrovnik 2014 CA DB2 Performance Monitoring: Insights into CA Insight DPM

This first part of presentation will focus on major DB2 10 trace enhancements and demonstrate how the CA Insight Database Performance Monitor addresses those. The second part will cover the product strategy and explain specific areas the development is working on. Customers will be asked to participate to the session, by providing candid feedback on the presented features and suggesting ideas to the product management


 

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 2023

VODICE -  12th - 15th June 2023