Workshops and Hands-on Labs

Session recordings will be posted as they are processed. Thank you for your patience.

Workshops and Hands-on Labs 


 Next Generation of Db2 Development 
View Session Recording
Vin Agrawal, Shaikh Quader, Adrian Mahjour, Tom Kolanko,bGeorge Baklarz, IBM
 Db2 Problem Determination 
View Session Recording
 Pavel Sustr, IBM
 Db2 V11.5.6 Deep Dive
View Session Recording
 Les King, IBM
 Getting Used to DMC and dmctop
View Session Recording
 Maryia Rakina, IBM
 Db2 V11.5 Architecture Deep Dive
View Session Recording - coming soon
 Keri Romanufa, IBM
 Click to Containerization - Moving to the Cloud in Minutes
View Session Recording
 George Baklarz, IBM
 Building a Secure Db2 Environment 
View Session Recording
 Alvin Fung and Mitchell Waite, IBM
 Infusing Db2 for z/OS with AI
View Session Recording - coming soon
 John Goodyear & Martin Dinh, IBM
 Db2 12 for z/OS: Business and Technical Value of Db2 12 New Function Beyond M500
View Session Recording
 Robert Catterall and Mark Radar, IBM
 An Introduction to IBM Cloud Pak for Data on IBM Z
View Session Recording - coming soon
 John Goodyear and Guillaume Arnould, IBM 

Tuesday, June 15, 10:30 a.m. - 5:30 p.m. 

Instructor: Vin Agrawal, Shaikh Quader, Adrian Mahjour, Tom Kolanko, George Baklarz, IBM

Advanced registration required. Limited Availability. Learn more.

1. Build and Deploy Machine Learning Models with Db2 In-Database ML feature
This Machine Learning (ML) workshop will teach you two approaches of doing machine learning with Db2. In the first approach, using a banking dataset, you'll develop a customer segmentation ML model using Db2’s native machine learning stored procedures and then automatically deploy that model inside Db2In the second approach, using US flight dataset, you'll develop an open-source Python ML model using scikit-learn to predict the flight status after take-off and deploy the model on Db2 with Db2’s Python UDF functionality.
Instructors: Shaikh Quader, Adrian Mahjour
Time: 10:45-2PM EST
2. Graph Analytics with Db2
To meet the challenge of analyzing rapidly growing graph and network data, many different graph database implementations are emerging. Although they handle graph-only queries well, they fall short for real-life applications. Graph queries are not all that one does in an analytics workload, they are often only part of an integrated pipeline which can include SQL, machine learning, graph and other analytics. IBM Db2 Graph solves the challenges by letting you run graph queries on your existing relational data structures in real-time without requiring any changes to the underlying database structure. This session will introduce and demonstrate IBM's new graph offering.
Instructor: Tom Kolanko
Time: 2:15-3:15PM
3. RESTful API and JSON application development with Db2
This hands-on lab will explore two technologies that expand the use of Db2 in modern application development.
The first section will cover the Db2 ISO JSON functions that allow you to store, retrieve, query, and publish JSON documents. This session will explore all of the aspects of the new functions, including how to create path expressions, extract values and objects, publish JSON documents from relational data, and build recursive SQL to traverse complex document structures. It's more than just storing a JSON document.
The second section will cover the use of RESTful calls with Db2. Modern application development paradigms need to be able to connect from a variety of devices to back-end databases. The use of native database drivers or frameworks are not always practical on mobile devices especially when there is a requirement to install drivers locally on the device. RESTful APIs provide an elegant way for applications to connect to databases without the need of drivers. This session will cover the current RESTful support in Db2 on a distributed platform and demonstrate how applications can be built using these APIs.
Instructor: George Baklarz
Time: 3:30-5:45PM

Tuesday, June 15, 10:30 a.m. - 2:00 p.m. (part 1)
Wednesday, June 16, 10:30 a.m. - 2:00 p.m. (part 2)

Instructor: Pavel Sustr, IBM

Advanced registration required. 

Tuesday, June 15, 10:30 a.m. - 5:30 p.m. 

Instructor: Les King, IBM

Course Agenda: 

Kick-off - 10:30 AM
  1. Performance
  3. DMC/dmctop
BREAK - 1:00 PM
  2. BLU - System Maintained Temporal Tables
  3. Deployment - Build Process and Updates
  4. Deployment - Containerization and Db2U
  5. Availability & ALSM - Michael Roecken
BREAK - 3:30 PM
  1. Modernization - In Db2 Machine Learning
  2. Modernization - Graph Database Support
  3. Modernization - Spatial Analytics
  4. Modernization - Federation

Tuesday, June 15, 10:30 a.m. - 2:00 p.m. 

Instructors: John Goodyear & Martin Dinh, IBM

Advanced registration required. Limited availability.

Get hands on experience with IBM Db2 AI for z/OS, a powerful new offering built on top of IBM Watson Machine Learning for z/OS.
Learn how Db2 AI can:
  • Optimize SQL statements,
  • Provide Db2 system assessments with expert guidance for tuning your subsystem,
  • Use the Distributed Connection Controller to learn remote workload traffic and generate Db2 profiles to monitor and control remote connection access of Db2's distributed server

Give students hands-on experience with the 3 primary Db2 AI for z/OS features: SQL Optimization, Distributed Connection Management, and System Assessment; so they better understand how Db2 AI for z/OS can improve their Db2 performance and stability.

Benefits of Db2 AI for z/OS
  • Identify and resolve Db2 connection problems before they happen
  • Save time and reduce costs
  • Improve Db2 application performance
  • Learn patterns from the collected data

Target: Audience:
Db2 for z/OS DBAs , performance specialists and anyone else involved with Db2 related operations.

Tuesday, June 15,  2:15 - 5:30 p.m.  (part 1)
Wednesday, June 16,  2:15 - 5:30 p.m. (part 2)

Instructors: Calisto Zuzarte, IBM

The broad topics covered in this session are(a) Optimizer Fundamentals and (b) Database Design.
Optimizer Fundamentals cover (1) Optimizer Basics (2) EXPLAIN (3) Performance Tuning Strategy (4) Row v/s Column Oriented Tables and (5) The Machine Learning Optimizer Tech Preview
Database Design covers (1) Table Design (2) Statistics Collection (3) Performance Objects (4) Configuration (5) Workload Management

Tuesday, June 15,  2:15 - 5:30 p.m. 
Instructors: Robert Catterall and Mark Radar, IBM

In a Db2 12 for z/OS environment, activation of function level M500 (analogous to what was formerly known as new-function mode) makes available a broad array of new features and functions. What about after that? During this workshop we will cover key enhancements provided by Db2 12 function levels beyond M500: the LISTAGG function, data set encryption, rebind phase-in, CREATE OR REPLACE for stored procedures, and more.

Wednesday, June 16,  10:30 a.m. - 2:00 p.m. 
Instructor: Maryia Rakina, IBM

In this workshop, our team will share Db2 Data Management Console / dmctop best practices and demos. You will learn how to set up security, high availability, and integration with other tools. We will show you how to locate and address Db2 performance and availability issues using DMC and dmctop. You will learn how to automate Db2 using Jupyter and REST, and use Db2 workload to optimize monitoring with DMC. In addition, there will be a panel discussion and Q&A at the end.

Wednesday, June 16,  10:30 a.m. - 2:00 p.m. 
Instructor: TBA

 Advanced registration required. Limited availability.

- Db2 for z/OS Data Gate hands on lab - Deploy a database
- Watson Studio - Step by step build a model
- Watson Knowledge Catalog and Data virtualization Manager fo z/OS - Importing Cobol Copybooks

Wednesday, June 16, 2:15 - 5:30 p.m.
Instructor: George Baklarz, IBM

 Advanced registration required. 

Deploying an existing Db2 to OpenShift or Cloud Pak for Data usually involves some form of export and import and a lot of work! The new Click to Containerize tool moves your on premise database directly to the Cloud - with no exporting of data! The tool can also migrate your 10.5, 11.1 and 11.5 database directly into a Db2 container with no additional effort. This session will take you through the IBM Db2 C2C program and how it can help modernize your Db2 databases quickly and efficiently!

Wednesday, June 16, 2:15 - 5:30 p.m.
Instructors: Alvin Fung and Mitchell Waite, IBM

 Advanced registration required. 

How to build a secure Db2 environment, including hands-on examples configuring TLS, Native Encryption, Row and Column Access Control, and the Db2 Audit Facility.

Wednesday, June 16,  10:30 a.m. - 2:00 p.m. 
Instructor: Keri Romanufa, IBM