Marcin Marczewski

Speaker Details


Marcin Marczewski, DB2 Solutions Migration Consultant, is an IBM employee since 2005. He is a Team Leader of Information Management Technology Ecosystem team in CEE, which is a part of IBM Krakow Software Laboratory in Poland. He focuses on various conversion projects to DB2 database by supporting IBM customers and Business Partner in such projects (porting assessments, porting assistance). As part of his job he also delivers various DB2 trainings. He is an IBM certified DB2 9.7 LUW Advanced Database Administrator.

Past presentation
During this session new features in workload management in Db2 will be discussed. 
Session participants will also learn how to configure/adjust WLM structures to handle unsual workloads with proper priorities
- for custom application workloads all the configuration steps will be presented as part of demo.

During this sessions new, enhanced tool for Db2 management will be introduced - Data Management Console
which replaces old DSM. New features and enhancements will be demonstrated during a practical tour (extended demo)
Participants will learn how to detect and monitor problematic queries, write statements and see access plans.
This session will also show how Open RESTful API for webconsole can be used for team collaboration.

06 October 2020
15:30 - 16:30
Managing JSON data inside Db2 database
This session will start with a short introduction to JSON in data. The main part of this presentation will be devoted
to a practical demo showing step by step how Db2 functions can be levereged to store, manage and transform JSON data for modern applications.

29 November 2019
12:30 - 13:30
SQLAdria Seminar – Opatija 2019 Db2 and JSON - How to store and manage JSON using build-in functions

29 November 2019
11:30 - 12:30
SQLAdria Seminar – Opatija 2019 Db2 in an AI world - leveraging Db2 for faster data science

This session will explore how to use Db2 to enhance data exploration using built-in capabilities.
Also Db2 with Python, and common tools such as Jupyter Notebooks and Pandas will be covered.

29 November 2019
10:00 - 11:00
SQLAdria Seminar – Opatija 2019 Db2 product roadmap - trends & directions

This session focuses on Db2 11.x, the newest version of Db2 for Linux, Unix and Windows.
This presentation gives a technical overview of Db2 11.x, with an update on the strategic roadmap
and a deeper diver into the first enhancements delivered in the new version.

29 November 2019
09:00 - 10:00
SQLAdria Seminar – Opatija 2019 What is new in Db2 11.5 (technical update)

28 May 2019
11:45 - 13:00
European SQLAdria Seminar – Šibenik 2019 db2mon – fast database health-check with new light-monitoring tool

Performance is a crucial thing for each database. Frequent health-checks are required in critical environments. During this presentation we will discuss db2mon – a tool (script) used for light-monitoring of your Db2 database. Step by step the tool would be run and results analyzed.

28 May 2019
10:15 - 11:30
European SQLAdria Seminar – Šibenik 2019 Db2 optimization profiles – tell the optimizer what to do

Db2 comes with a smart query optimizer which tries to execute every query with best access plan. How to tell the optimizer what to do? Which join method to use or at which optimization class run your queries for a specific session? During this presentation we will discuss how optimization profiles can be created and maintained. Optimization guidelines with examples will also be covered.

13 June 2012
11:15 - 12:30
SQLAdria Seminar – Dubrovnik 2012 Time travelling with DB2 10 LUW – new in DB2 10

Temporar tables
System-period temporar table (STT)
Application-period temporar tables (ATT)
Bitemporar tables
Time travel queries

13 June 2012
10:00 - 11:00
SQLAdria Seminar – Dubrovnik 2012 DB2 Oracle compatibility

Migration challenges
DB2 Oracle Compatibility Features
Migration tools
IMTE support

13 June 2012
09:00 - 10:00
SQLAdria Seminar – Dubrovnik 2012 Bye Bye Control Center – Data Studio is here!

Replacements for discontinued tools
IBM Data Studio
Past and Future
UI layout and basic navigation
Administration using Data Studio
Data Studio Web Console
Optim Performance Manager

12 June 2012
16:00 - 17:00
SQLAdria Seminar – Dubrovnik 2012 Workload management

Workload Management (WLM) components(storage design)
Work and work class sets
Service classes
Work action and work action sets
WLM Dispatcher – new in DB2 10!(storage design)
WLM monitoring scenarios and monitoring capabilities(storage design)
Data centric way of workload management – new in DB2 10!


12 June 2012
15:00 - 16:00
SQLAdria Seminar – Dubrovnik 2012 PureScale – Part 2

pureScale architecture and components
pureScale installation and deployment
pureScale scalability
pureScale demo (on nanoCluster)

12 June 2012
11:45 - 13:00
SQLAdria Seminar – Dubrovnik 2012 PureScale – Part 1

pureScale architecture and components
pureScale installation and deployment
pureScale scalability
pureScale demo (on nanoCluster)

12 June 2012
10:30 - 11:30
SQLAdria Seminar – Dubrovnik 2012 Storage optimization

Tablespaces in DB2 (storage design)
Multi-temperature data management – new in DB2 10!(storage design)
Data Compression (storage design)

classic compression
adaptive compression – new in DB2 10!
index compression
temporary tables compression
XML/LOB compression

12 June 2012
09:00 - 10:30
SQLAdria Seminar – Dubrovnik 2012 Introduction to IBM DB2 10 LUW- NEW FEATURES, NEW POSSIBILITIES

Features spotlight/features overview:
Faster Query Response, Improved Index Mgmt
Adaptive Compression
Multi-Temperature Data Management
SQL Compatibility enhancements
Row and Column Access Control
Temporal Capabilities
DB2 pureScale enhancements
Workload Management Enhancements
HADR Supports Multiple Standby Servers
DB2 Fundamentals (optionally)



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



Events in 2020

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