Marcin Marczewski

Speaker Details

Bio

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
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
Installation
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
Workloads
Work action and work action sets
Thresholds
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)
 


 

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 - 8th & 9th April 2020
Belgrade - 10th April 2020
Šibenik - 14th - 18th June 2020
Zagreb - 25th September 2020
Opatija - 26th & 27th November 2020