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
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 2019

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