Denis Tronin

Speaker Details

Bio

Denis Tronin is the Product Manager at Mainframe Division at Broadcom. He is an experienced IT professional having 13 years of expertise in product management and software development. He led development of products for mainframes in workload automation, Db2, API management domains. He is an IBM Champion for Analytics since 2016, a regular speaker at user groups and conferences, and a core member of Zowe open source mainframe project.

Past presentation
06 October 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 May 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 May 2019
16:45 - 17:15
European SQLAdria Seminar – Šibenik 2019 Zowe and Brightside

13 June 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 June 2018
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2018 What’s new in CA – MfaaS

13 June 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 June 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 June 2017
18:00 - 18:30
European SQLAdria Seminar – Šibenik 2017 What’s new in CA DB2 Performance Tools?

13 June 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 June 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 June 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 June 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 June 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 May 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 2020

Ljubljana - 
Belgrade - 
Šibenik - 4th - 8th October 2020
Zagreb - 25th September 2020
Opatija - 26th & 27th November 2020