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
new capababilities in a new tool which replaces Data Server Manager
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.
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.
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.
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.
Temporar tables System-period temporar table (STT) Application-period temporar tables (ATT) Bitemporar tables Time travel queries
Migration challenges DB2 Oracle Compatibility Features Migration tools IMTE support
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
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!
pureScale architecture and components pureScale installation and deployment pureScale scalability pureScale demo (on nanoCluster)
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
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.
8 reasons to come Speakers Events Contact
VODICE - 10th - 13th June 2024
HR
EN
SL