90

Db2 by the back door

Date: 
Thursday, 26 November, 2020 - 16:15 - 17:15
Program: 
z/OS Track
Speaker: 
Marcus Davage

How I accessed Db2 via RESTful services, the Java CLP, the Zowe CLI and Python and got away with it. This presentation will introduce the latest trendy methods of getting at Db2 and its data. It will contain a few pre-recorded video demos of each method.

Break

Date: 
Thursday, 26 November, 2020 - 16:00 - 16:15
Program: 
z/OS Track

Wrapping up Db2 V11.1

Date: 
Friday, 27 November, 2020 - 15:00 - 16:00
Program: 
LUW Track
Speaker: 
Les King

With the introduction of Db2 V11.5, we have now finished with delivering new functionality on Db2 V11.1. Over the past few years we have some very significant feature paks, adding a wealth of new high value capabilities to Db2. In this session we will go through the key new capabilities associated with each feature pak. This will include key BLU enhancements, pureScale enhancements, NoSQL enhancements, security enhancements and more. Many of these new capabilities form the base for new capabilities in Db2 V11.5. This session will help raise awareness of the many enhancements so clients can get as much value out of Db2 V11.1.

Break

Date: 
Friday, 27 November, 2020 - 14:45 - 15:00
Program: 
LUW Track

Db2 V11.5 and Db2 V11.5.4 and Db2 V11.5.5

Date: 
Friday, 27 November, 2020 - 14:00 - 14:45
Program: 
LUW Track
Speaker: 
Les King

In 2019 we released a significant new release of Db2 and delivered a great deal of new capabilities including new logging options, enhancements to our columnar support, enhancements to pureScale, leveraging machine learning within our optimizer and much more. In addition to a significant number of engine enhancements, we have also introduced many other capabilities including enhancements to Q-Replication based solutions, Natural Language Query and more. In this session we'll take a look at the key enhancements which were delivered with V11.5 and also a peak ahead to our first feature pak on top of V11.5. We will also include a couple of demos of some of the great new capabilities.

Break

Date: 
Friday, 27 November, 2020 - 13:00 - 14:00
Program: 
LUW Track

Managing JSON data inside Db2 database

Date: 
Friday, 27 November, 2020 - 11:45 - 12:45
Program: 
LUW Track
Speaker: 
Marcin Marczewski
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.

Break

Date: 
Friday, 27 November, 2020 - 11:30 - 11:45
Program: 
LUW Track

Steroids for the Optimizer – An Introduction to (Advanced) Statistics

Date: 
Friday, 27 November, 2020 - 10:30 - 11:30
Program: 
LUW Track
Speaker: 
Matthias Nicola

Db2 uses a cost-based query optimizer that is vitally dependent on appropriate statistics to generate efficient execution plans. However, it is often not obvious when to use which of the many options for the RUNSTATS command to collect the "right" kind of statistics. This session presents a set of practical examples to explain how different types of statistics affect query optimization. We also discuss RUNSTATS measurements to illustrate the overhead of collecting more advanced statistics. As a result you will be able to determine when it is worthwhile to use more advanced concepts such as distribution statistics, column group statistics, or statistical views. Provide the right steroids to the optimizer to boost performance!

Break

Date: 
Friday, 27 November, 2020 - 10:15 - 10:30
Program: 
LUW Track
Syndicate content  

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

VIRTUAL EVENT - 25th - 27th November 2020