Hands-On Labs




Hands-On Labs
[No additional registration needed, but Labs limited to 20 people--first-come/first served. Not available to Virtual participants.]

Mon, Jul 11
2:00-4:30pm EDT

Setting up a Secure Db2 for LUW Environment
Greg Stager, IBM & Nataliya Prokoshyna, IBM 
HOL1 | Clarendon (3rd floor)

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.

This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.
{please see this prerequisite set-up that will be needed prior to this lab}

Mon, Jul 11
2:00-4:30pm EDT

The Next Generation of Services for Db2 for z/OS Administration & Development
Sueli Almeida, IBM
HOL2 | Berkeley (3rd floor)

Ever imagine being able to administer your Db2 for z/OS subsystems from a single modern web interface? How about being able to use your choice of development environment and language to develop applications for Db2 for z/OS? In this Hands On Lab, we will demonstrate how we have re-factored capabilities you need into a suite of services surfaced through a modern interface designed to enable ease of administration for your Db2 subsystems. See how you can quickly locate objects and schema, execute DDL changes, administer your Db2 Analytics Accelerator, and much more. In the same track, we will show you all the new services we have made available to simplify development on Db2 for z/OS. The engine that never sleeps can now be managed by state-of-the-art administration services.


This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.

Tue, Jul 12
2:00-4:30pm EDT

Db2 for LUW Tools

Pooja Vettical, IBM, Hafsa Ali, IBM, Vijaya Katikireddy, IBM, Jason Sizto, IBM

HOL3 | Clarendon (3rd floor)

It is every DBA’s dream to have one universal console to monitor hundreds of databases, manage objects, generate alerts, run SQL and so on. Let’s explore some of the cool features of Database Management Console.

This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.

Tue, Jul 12
2:00-4:30pm EDT

Infusing Db2 for z/OS with AI
Martin Dinh, IBM & John Goodyear, IBM
HOL4 | Berkeley (3rd floor)

Join us to get first-hand 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, and 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.

 

This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.

Wed, Jul 13
2:00-4:30pm EDT

Modernization and Tooling

Jason Sizto, IBM, & Vijaya Katikireddy, IBM

HOL5 | Clarendon (3rd floor)

Deploying an existing Db2 to OpenShift, Kubernetes, or Cloud Pak for Data usually involves some form of export and import and a lot of work! You will see how easy it is, to migrate your on-premises database directly to the Cloud.

This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.

Wed, Jul 13
2:00-4:30pm EDT

Deep Dive Into SQL Data Insights in Db2 13
Akiko Hoshikawa, IBM 
HOL6 | Berkeley (3rd floor)

[abstract coming soon]

This is 1 of 6 optional Hands-On Labs available with no additional fee and no additional registration.
They are all offered on a first-come/first-served basis as an alternative to Technical Breakout Sessions
[2, 3 & 4 on Mon Jul 11; 7, 8 & 9 on Tue Jul 12; and 12, SIGs & 13 on Wed Jul 13]
for up to 20 people each.