106

Multi-row Operations in a Nutshell

Date: 
Monday, 10 lipanj, 2024 - 15:30 - 16:30
Program: 
z/OS Track
Speaker: 
Emil Kotrč
A typical Relational Database Management System like Db2 works with a set of rows. Yet, applications often work with one row at the time even in scenarios where a multi-row operation could improve the performance significantly.
This presentation will show how multi-row operations in Db2 for z/OS, such as multi-row inserts and multi-row fetches, can help you to improve your application that is processing a large number of rows.

Db2 in a watsonx.data environment

Date: 
Thursday, 13 lipanj, 2024 - 12:45
Program: 
LUW Track
Speaker: 
Kelly Schlamb
Speaker: 
Marcin Marczewski

Building a secure Db2 environment

Date: 
Thursday, 13 lipanj, 2024 - 09:00 - 12:15
Program: 
LUW Track
Speaker: 
Greg Stager

A secure environment while operating Db2 has become of utmost importance as the cost of cyberattack and data breach increase year by year. The purpose of this hands on lab is to provide guidance on building a secure Db2 environment with some of Db2’s latest security features. In this hands-on workshop, participants will learn about Db2 security services including configuring TLS, Native Encryption, Row and Column Access Control, and the Db2 Audit Facility.

Automate Db2 Schema Deployment using Ansible Playbooks

Date: 
Thursday, 13 lipanj, 2024 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Denis Tronin
Speaker: 
Emil Kotrč
Speaker: 
Toine Michielse
'Are you exploring how to exploit Ansible on your DevOps journey? Or, you may be well on your way towards standardizing on Ansible.  Either way, our workshop will introduce you to a Broadcom developed Ansible collection that will empower you to automate your Db2 for z/OS Schema Management the Ansible way.
This Ansible collection will be a powerful tool to enable a developer to provision the Db2 environment needed to test an application. It also has the necessary capabilities to automate deployment of any schema changes. In this workshop you will have the opportunity for an instructor-led hands on experience with the Broadcom DBM-Db2 Ansible collection. You will learn ways to use the collection in ad hoc mode as well as understand how to develop Ansible playbooks to achieve your goal.
The objectives of the workshop are:
- Understand how Db2 Schema and data provisioning can be modernized and how it support DevOps
- Get familiar with Ansible ad hoc commands
- Understand Ansible playbooks and the environment in which they execute
- Develop a simple playbook to deploy a Db2 for z/OS Schema change
As this is a hands-on workshop, please bring your laptops with you.

Integrated Synchronization – How to operate replication

Date: 
Thursday, 13 lipanj, 2024 - 09:00 - 16:00
Program: 
z/OS Track
Speaker: 
Mehmet Cunyet Goksu
  • Configuration
  • HA/DR-Setup
  • Migrating from CDC to Integrated Synchronization
  • Monitoring and Day to Day Activities
  • Handling schema modifications
  • Summary

Panel Discussion

Date: 
Wednesday, 12 lipanj, 2024 - 13:30
Program: 
LUW Track

Your Answer when the Data Warehouse Database and Application is not ready to go on Public Cloud

Date: 
Wednesday, 12 lipanj, 2024 - 12:30 - 13:30
Program: 
LUW Track
Speaker: 
John Bell

Data Warehouse applications have matured to mission critical aspects.  Data Latency requirements have dropped to Minutes or a few hours.  Source applications are still on-perm.  If not all at least a portion of the Data Warehouse must remain on-perm.  This session gives you an answer.

Managing Data in Db2: Optimizing Storage

Date: 
Wednesday, 12 lipanj, 2024 - 11:30 - 12:30
Program: 
LUW Track
Speaker: 
Steven Tsounis

Db2 continues to evolve to be a multi-modal database that can serve a variety of data needs. As such there have been many features that have been introduced over the years to support performance and storage optimization in a cost-effective manner. This session will highlight a number of these features related to performance to show how Db2 has evolved to support various workloads.

Break

Date: 
Wednesday, 12 lipanj, 2024 - 11:00 - 11:30
Program: 
LUW Track

Trust and Exceptions. Two new features enhance existing security functionality

Date: 
Wednesday, 12 lipanj, 2024 - 10:00 - 11:00
Program: 
LUW Track
Speaker: 
Greg Stager

This session will cover new features that will enhance the trusted context and audit facility within a future version of Db2.  The concept of a trust procedure is being introduced which allows arbitrary rules to define which connections qualify for a trusted context.  There is also a secure method of validating the application initiating the trusted connection that can further enhance the trust of the application.  While these are independent features with great use cases on their own, they can be combined with a new audit exception feature for trusted contexts.  It is now possible to turn off auditing for any actions taken within a specific trusted context.  Do you have a trusted application that has its own auditing built in?  This session will cover how to securely identify that application with a trusted context, and configure an exception for it within the audit facility.

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 2024

VODICE -  10th - 13th June 2024