Cristian Molaro

Speaker Details

Bio
Cristian Molaro is an independent DB2 specialist and an IBM Gold Consultant. He is recognized by IBM as an Information Champion since 2009. His main activity is linked to DB2 for z/OS and LUW administration and performance. He is a certified DB2 for z/OS and LUW professional and was recognized by IBM as "TOP" EMEA Consultant in 2011, 2013, and 2016.
Cristian was awarded ”Platinum RedBook author" for his contribution to 10 IBM Redbooks related to DB2. His latest RedBook is  "DB2 12 Performance Topics”. He also contributed as a Technical Editor for IBM's publication "DB2 Essentials" by Raul Chong and Clara Liu.
He has presented papers at several international conferences and local user groups in Europe and North America. Cristian is past-Chairman of the IDUG EMEA Conference Planning Committee, and he is Chairman of the DB2 LUW User Group BeLux. He can be reached at cristian@molaro.be
 
Past presentation
14 June 2018
09:00 - 16:00
European SQLAdria Seminar – Šibenik 2018 DB2 Performance workshop (LUW)

13 June 2018
12:30 - 13:15
European SQLAdria Seminar – Šibenik 2018 Practical DB2 Performance

12 June 2018
15:00 - 16:00
European SQLAdria Seminar – Šibenik 2018 DB2 LUW SQL tunning for high performance and concurrency

12 June 2018
14:00 - 15:00
European SQLAdria Seminar – Šibenik 2018 DB2 LUW Best practices in 2018

16 June 2016
09:00 - 16:00
European SQLAdria Seminar – Šibenik 2016 Introduction DB2 LUW for experienced DBA’s

This session is designed to leverage your database and IT skills into the world of DB2 for Linux, Unix, and Windows. Cristian will discuss the basis of how DB2 works, what you need to know to get started as best as possible, and what are the common mistakes to avoid. He will highlight the differences and similarities with other databases, and will show the best ways of getting more information. A pragmatic approach that focuses on helping you to become a proficient DB2 professional in a more efficient way. This presentation covers current DB2 releases


15 June 2016
09:00 - 10:00
European SQLAdria Seminar – Šibenik 2016 Open source monitoring tools for DB2 LUW

This session discusses about how to integrate DB2 monitoring into industry standard open source IT infrastructure monitoring tools like Nagios. The techniques described can be applied to other tools, or to DB2 automation in general. Examples include exploitation of administrative routines and ADMIN_CMD procedure. This session focuses on DB2 LUW in Linux environments. 


14 June 2016
15:00 - 16:00
European SQLAdria Seminar – Šibenik 2016 Practical DBA: tips and tricks for DB2 LUW

This session exposes day to day tasks and recurrent activities seasoned with a "checklist" approach: a cooking guide for DB2 LUW database administrators. Whether you are a seasoned DB2 for LUW database administrator or someone discovering the DB2 for LUW administration challenges, you will find something useful in this seminar.


14 June 2016
14:00 - 15:00
European SQLAdria Seminar – Šibenik 2016 DB2 11 for z/OS: Performance in a Nutshell

DB2 11 for z/OS comes with many performance enhancements. You may be surprised about its potential to improve throughput and to reduce total cost of ownership. But what is practically achievable for real life users? What can you expect to gain in terms of performance by moving to DB2 11? Cristian worked on the recent DB2 11 for z/OS performance redbook.


18 June 2015
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2015 Introduction DB2 LUW for experienced DBA’s
This seminar is designed to leverage your database and IT skills into the world of DB2 for Linux, Unix, and Windows. Cristian will discuss the basis of how DB2 works, what you need to know to get started as best as possible, and what are the common mistakes to avoid. He will highlight the differences and similarities with other databases, and will show the best ways of getting more information. A pragmatic approach that focuses on helping you to become a proficient DB2 professional in a more efficient way. This presentation covers current DB2 releases
 
Are you a DB2 for z/OS, SQL Server, Oracle experienced user looking for a fast path into DB2? This day has been created for you! Cristian will teach you the major commands and differences with other databases
 
Topics:
 
Introduction to DB2
  • What is DB2 for Linux, Unix, and Windows?
  • DB2 editions & DB2 licensing
  • DB2 LUW vs. DB2 for z/OS
The DB2 architecture
  • Instances and databases
  • Table Spaces
  • Tables, Indexes, and Large Objects
  • DB2 logging
  • Buffer Pools
  • Storage Groups / Automatic Storage
  • Partitioning
  • Compression
  • Table compression
The DB2 working environment
  • DB2 Command Line Processor (plus)
  • IBM Data Studio and other GUI tools
  • Application enablement
  • Default locking settings
  • Working with packages
  • SQLJ and pureSQL
  • Java development considerations
  • Explain
  • The DB2 Advisors
  • SQL for cross-platform development
The DB2 deployment options
  • High Availability (HADR) and PureScale
  • BLU for analytics
  • Interaction with DB2 z/OS and other databases
System topics
  • Installing, updating and upgrading DB2
  • IBM Data Server Clients and Driver Packages
  • Automatic Database Maintenance
  • Using database tools and utilities
  • Backup and recovery at a glance
  • Performance tools at a glance
Security

17 June 2015
09:00 - 10:00
European SQLAdria Seminar – Dubrovnik 2015 DB2 pureScale explained
This session discusses the key value features of DB2 pureScale. It will help to understand how this technology works and what are its strengths.
The focus is on describing the functionality, the applicability, and the synergy opportunities of DB2 pureScale.
It also provides with an update on recent improvements and features.

16 June 2015
11:45 - 13:00
European SQLAdria Seminar – Dubrovnik 2015 Open source monitoring tools for DB2 LUW
This session discusses about how to integrate DB2 monitoring into industry standard open source IT infrastructure monitoring tools like Nagios. The techniques described can be applied to other tools, or to DB2 automation in general.
Examples include exploitation of administrative routines and ADMIN_CMD procedure. This session focuses on DB2 LUW in Linux environments.

16 June 2015
10:15 - 11:30
European SQLAdria Seminar – Dubrovnik 2015 Practical exploitation of DB2 LUW auditing
Often, there is a need to track the activity of an application or the actions of a user on a DB2 database. Whenever you need to profile a new application, to troubleshoot a weird behaving program, or to simply keep track of what changes administrators are doing, the DB2 audit facility can be of help.
“What is this user doing?” - “What are the most executed SQL statements?” - “Who is connecting to this DB2, and from where?” - “How many rows were modified?” - “How many rows were returned?”… You will find that the DB2 audit facility can answer these questions and many more. Easy to implement and quite powerful, the DB2 auditing facility deserves to be kept at hand. So the purpose of this session is to provide you with a quick introduction to its practical use.

16 June 2015
09:00 - 10:15
European SQLAdria Seminar – Dubrovnik 2015 The one man dba team: how automation can save the day
Often, the number of databases, subsystems, applications, and tasks are in disproportion to the number of database administrators. Often, a small number of DB2 professionals have to manage a vast number of processes and operations. Automation can help to leverage the power and efficiency of well designed and repeatable processes. Automation can help to alleviate the database administrator workload making his/her life easier.
This session discusses common industry examples of practical application of ready available automation tools to administer DB2 for LUW environments.

29 May 2014
09:00 - 16:00
European SQLAdria Seminar – Dubrovnik 2014 DB2 for z/OS: Practical performance
DB2 performance is key in application success, user satisfaction and cost savings. This session is a pragmatic guide to DB2 for z/OS performance. It covers exploiting DB2 accounting and statistics traces for health checking and problem resolution on DB2 10 and DB2 11 for z/OS. It focuses on providing the understanding required to allow you to get performance results. It is the result of hands-on experiences, teaching and writing about DB2 for z/OS performance for many years. 
 
Topics include: 
•Where should I start? 
•Effective use of the statistics and accounting traces 
•Health checking DB2 
•Exploiting the performance tools at hand 
•Dynamic SQL 
•Monitoring real storage 
•I/O performance 
•Typical performance quick wins 
•Surviving big amounts of Data 
•Long Term Monitoring 
•Building an effective alerting system 
•What is new in DB2 11?

28 May 2014
10:15 - 11:00
European SQLAdria Seminar – Dubrovnik 2014 STMM good or bad?

Is it wise to turn on STMM?  Why not? How does it work and what are its limitations? Instead of looking at it as on/off we look at a hybrid solution


28 May 2014
09:15 - 10:00
European SQLAdria Seminar – Dubrovnik 2014 What Developers must know about DB2 for z/OS indexes
DB2 indexes are key in SQL Performance, but they can be a source of problems as well.
It is critical to understand the advantages of proper index design, and the dangers related to index over-utilization as well.
This session discusses the indexes options available for developers, how to use them, and how to get the most of index design.
We will see what is new in DB2, including indexes on expressions, include column indexes, and rebuild index avoidance.
Discussed topics also include virtual indexes, table control partitioning, and index compression. 
Locking considerations when indexes are involved. Monitoring and utilization tracking in Real Time Statistics that will allow you to remove unnecessary indexes.
We will cover tips and real life example of best practices.

28 May 2014
08:30 - 09:15
European SQLAdria Seminar – Dubrovnik 2014 Rebind best practices

27 May 2014
16:00 - 17:00
European SQLAdria Seminar – Dubrovnik 2014 DB2 Workload manager

DB2 Workload Manager (WLM) is not very popular. Maybe because most people don’t know what it can do or how to use it. We will discuss it features and how it can be implemented


27 May 2014
11:45 - 13:00
European SQLAdria Seminar – Dubrovnik 2014 What’s new for SQL optimization in DB2 for z/OS
DB2 for z/OS is a solid, a mature, and a state of the art database management system.
But despite more than 30 years of development, DB2 continues to add SQL Optimization features that help to get the most of DB2 for applications with every release. These are great news, but you have to make sure that you can get the best advantage of this for your environment.
This session describes changes in the DB2 Optimizer that provide new query access path and query optimization enhancements with query rewrite and predicate evaluation.
We will see how recent changes can help to reduce CPU and Elapsed time of complex queries in a dramatic way. We will review how the DB2 Optimizer interfaces with a DB2 Analytics Accelerator and the controls that you can use at your advantage.
We will discuss about the improved zIIP query offload and how it can help to reduce total cost of ownership and, in some cases, to improve performance.       
 
This session is an update on what is new, what is great, and what is not so great in DB2 10 and DB2 11 in DB2 for z/OS SQL Optimization. We will discuss things that you have to know, and we will demystify the DB2 Optimizer to help you to get the most of DB2.

12 June 2013
10:00 - 11:00
European SQLAdria Seminar – Dubrovnik 2013 How to secure remote access to DB2 for z/OS

11 June 2013
13:00 - 14:00
European SQLAdria Seminar – Dubrovnik 2013 DB2 10 for z/OS: selected performance topics

11 June 2013
11:45 - 13:00
European SQLAdria Seminar – Dubrovnik 2013 DB2 10 for z/OS: What is new in distributed access to DB2?

12 June 2012
10:30 - 11:30
SQLAdria Seminar – Dubrovnik 2012 Monitoring and troubleshooting distributed access to DB2 for z/OS

With today’s complex n-tier architectures and heterogeneous applications and platforms, optimization and availability can be a challenge, in addition, the ways on which DB2 communicates with its distributed clients is evolving and presents new challenges for monitoring and troubleshooting.
This presentation will explore and provide hints and tips on how to monitor and troubleshoot distributed access to DB2 for z/OS.


11 June 2012
12:15 - 13:15
SQLAdria Seminar – Dubrovnik 2012 DB2 10 Performance Experiences Part 2: Application enablement

During this session we will concentrate on the DB2 10 changes that help applications to perform better, faster and in a more efficient way.
Bi temporal support, hash, index include columns, inline LOBs and many SQL improvements have the potential to accelerate our current and future applications. We will discuss and explore the most important of them.
We will also talk about the DB2 10 CPU reduction potential and the DB2 10 performance expectations.
This presentation recollects the experiences of co-authoring the redbook “DB2 10 Performance Topics” and the observations of users of DB2 10 for z/OS.


11 June 2012
11:15 - 12:15
SQLAdria Seminar – Dubrovnik 2012 DB2 10 Performance Experiences Part 1: System considerations

This session will discuss and explain the DB2 10 for z/OS subsystem changes that improve performance. We will talk about the changes that could hurt your system as well.
The focus will be on these topics that are of the most interest froma practical point of view in today’s context.
For instance, the DB2 10 storage relief could help to dramatically improve the DB2 for z/OS scalability and help to consolidate DB2 subsystems; but what it really means in practical terms? We will address this and other subjects from a pragmatic point of view.
This presentation recollects the results of co-authoring the redbook“DB2 10 Performance Topics” and the experiences of users of DB2 10 for z/OS.


15 June 2011
10:00 - 11:00
SQLAdria Seminar – Dubrovnik 2011 Dealing with Data Skew

14 June 2011
12:15 - 13:30
SQLAdria Seminar – Dubrovnik 2011 DB2 XML, it is all about SQL/XML and XPath!

Since DB2 9 XML is deeply embedded in DB2 as a data type. XML can be stored inside the database. In this session we explain how with SQL/XML and XPath you can store, query and manipulate the XML documents. To be successful with XML you will have to learn some new techniques. This session gives you an overview of what is needed and where you need some extra planning in your next project when XML is going to be stored in DB2.


 

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 2019

Ljubljana - 9th & 10th April 2019
Belgrade - 12th April 2019
Šibenik - 26th - 30th May 2019
Zagreb - 26th September 2019
Opatija - 28th & 29th November 2019