Workshops

The DDF part will cover basic concepts/terms; high availability, with use of Sysplex Distributor and Sysplex Workload Balancing; how to control thread/connection usage; how to monitor distributed access. The Dynamic SQL part will cover what are dynamic statement cache flavors; how to monitor dynamic queries; considerations for use of KEEPDYNAMIC(YES), Concentrate SQLs With Literals and REOPT parms; what are best practices for setting for optimal subsystem performance and application development usability; Dynamic SQL challenges; and new V12 features, like Dynamic Plan Stability and REST API.

This is one of four optional workshops available with no additional fee but that do require additional registration. They are all offered on Thursday, July 14 as an alternative to Technical Breakout Sessions 14, 15 & 16. Seating is limited to the first 30 registrants. 

The popular Db2 problem determination seminar has been updated with the newest Db2 11.5 problem determination techniques and hands-on exercises! Learn how to identify and resolve database hangs, crashes, performance problems, and data corruption issues. Get familiar with diagnostic tools. Learn how and when to use these troubleshooting tools for a quick problem resolution. Topics covered: Crashes/Traps, Data Corruption, FODC, Hangs, Latching, and Performance. Participants will be able to characterize a problem in order to expedite resolution; learn how and what data to collect during intermittent hangs, slow-downs, and other frequent problems; and, understand Db2 Support's methodology in troubleshooting Db2 and even non-Db2 hiccups. This workshop contains live demos during which the audience will be given an opportunity to perform an interactive investigation of selected problems.

This is one of four optional workshops available with no additional fee but that do require additional registration. They are all offered on Thursday, July 14 as an alternative to Technical Breakout Sessions 14, 15 & 16. Seating is limited to the first 30 registrants. 

This workshop is a multi-part session that will cover a Db2 query performance topic followed by a 15-minute quiz. Best practice documentation will be provided that will serve as reference material. A segment of this workshop will focus on the latest tech preview using Machine Learning.

This is one of four optional workshops available with no additional fee but that do require additional registration. They are all offered on Thursday, July 14 as an alternative to Technical Breakout Sessions 14, 15 & 16. Seating is limited to the first 30 registrants. 

Broadcom delivers an exciting new Zowe plugin in the realm of Db2 DevOps. The plugin provides a set of CLI commands for Db2 schema management as well as Db2 (test) data provisioning. The CLI will be a powerful tool to enable a developer to provision the Db2 environment needed to test an application. Of course, the commands can also be easily integrated into others, such as the Jenkins pipeline. In this workshop, you will have the opportunity for an instructor-led hands-on experience with the Zowe DBM-DB2 plugin. You will learn how to set up the needed profile and how to use the available parameters.

This is one of four optional workshops available with no additional fee but that do require additional registration. They are all offered on Thursday, July 14 as an alternative to Technical Breakout Sessions 14, 15 & 16. Seating is limited to the first 30 registrants.