Workshops

Workshops

These nine Workshops (WS1 - WS9) are complimentary, but additional sign-up is required. Include a Workshop with your new registration, or open your existing registration and add-on.
[Not available to virtual participants]

This one day seminar will cover the distributed access to Db2 for z/OS accessing and leveraging enterprise data via dynamic SQL, stored procedures (external and native) and native REST API access. The DDF section of the workshop will cover the basic concepts, terminologies and concentrate on high 24/7 availability and redundancy using Sysplex Distributer and Sysplex workload balancing and how to best control and monitor profiles. Dynamic SQL will be a major focus including the use of:

• KEEPDYNAMIC(YES)
• Dynamic Plan Stability
• HP-DBATs
• Concentrated SQL and literals
• REOPT parameters
• System and application best practices for monitoring
• Trend analysis
• Rules of thumbs will be discussed in detail

The workshop will also share the experiences of the Db2 for z/OS Development SWAT team, what has worked well and what are some of the challenges our customers are facing and have experienced and what can be done to better improve performance and availability.

Audience Experience Level: Intermediate, Advanced

The Query Optimization and Tuning Workshop will be a presentation / discussion covering a variety of optimization and performance tuning topics.
It will cover topics like 

(a) Basic optimizer concepts 
(b) Table Partitioning 
(c) Row versus Column Oriented Tables 
(d) Statistics collection 
(e) Cardinality Estimation 
(f) Scan Optimization 
(g) Join optimization 
(h) Aggregation and Sort optimization 
(i) Index considerations 
(j) Materialized Query Tables 
(k) Replicated Tables 
(l) Insert, Update, Delete, Merge Performance 
(m) Resource Configuration considerations 
(n) Interesting Performance Registry Variables 
(o) Optimizer Profiles and Guidelines 
(p) Workload Management 
(q) Query EXPLAIN 
(r) Query Writing for Performance 
(s) Performance Tuning strategies 
(t) Compression 
(u) clustering data for performance 
(v) Monitoring and tracing to identify slow queries 
(w) The future Optimizer with Machine Learning models

Audience Experience Level: Beginner, Intermediate, Advanced

Db2 is known as a robust and reliable database management system and a perfect match for private and public cloud environments. However, sometimes you might face database related issues. The session will cover the first steps in the process of problem determination and problem source identification (PD/PSI). The session will describe the strategy and process to encircle and find the problem by asking the right questions and will share best practices for the first occurrence data capture (FODC) tools available for the DBA. This self-paced workshop allows new DBA’s to start with the essential procedures and might surprise Db2 experts with not so well known features of Db2 for problem analysis.

Audience Experience Level: Beginner, Intermediate, Advanced

Broadcom recently delivered the innovative new Zowe DBM-Db2 CLI plugin to help support your Db2 DevOps needs. The plugin provides a set of CLI commands for Db2 schema provisioning and deployment, that allows developers to provision and adjust the Db2 objects they need to develop and test an application. These commands are also easily integrated into various continuous delivery tools, such as Jenkins. We are excited to provide a four-hour, instructor-led, hands-on workshop that lets you try the new plugin for yourself. In this session, you will learn how to configure the plug-in and use it for Db2 schema (DDL) changes in the web-based IDE (Visual Studio Code). Bring your laptop, an open mind, and get ready to learn.

Audience Experience Level: Beginner, Intermediate, Advanced

In the first part of this workshop, you will setup a Pacemaker Cluster with Db2 HADR. You will learn to work with the db2cm command to create all required resources for the cluster.

After your successful implementation of the cluster, the workshop will allow you to run and maintain a cluster. You will learn how to find essential diagnostic information and how to analyze them.

At the end of this self-paced workshop, the instructors will inject failures in your cluster and will then be happy to help you, bringing the cluster back to life.

Audience Experience Level: Beginner, Intermediate, Advanced

In this workshop you will have a chance to perform a hands-on lab to experience the latest deliverables towards Db2 user transformation. 

• Db2 application developer personas can develop / test and deploy application changes that also require database change in a speed that business demand. Using Db2 Developer Extension in IDE will simplify coding of SQL including native stored procedure code. Using Db2 DevOps Experience services (DBaaS), developers can, on demand, self-service database operations under the rules previously established by the Db2 administrators.
• Db2 administrator personas can benefit from Db2 DevOps experience (DBaaS) to shift-left database operations to application developers under their rules and administrative directives. Last but not least, administrators can also execute some of their daily tasks in a more intuitive way via Db2 Administration Foundation and its integration with Db2 Tuning Services. 

Audience Experience Level: Beginner, Intermediate

In this workshop you will get a technical deep dive on latest enhancements in Db2 Analytics Accelerator directly from the Accelerator development organization.
We will cover topics such as:

• What's new in latest releases including technical details and usage
• Deployment: Architecture options, migration and HA/DR best practices
• Data load and Integrated Synchronization
• Query performance best practices
• and more...

This workshop enables customers to gain an understanding of how to leverage Db2 Native REST services in a hybrid cloud environment using RESTful APIs. Attendees will be provided with a cloud-based virtual lab environment to learn how quickly and easily RESTful APIs can be created using z/OS Connect and mapped to Db2 Native REST services.

Audience Experience Level: Intermediate

SQL Data Insights provides an easy yet powerful way to utilize AI against your Db2 data.
This self-paced quick hands-on-lab invites you to create a model table through GUI and then write a new built-in AI functions to discover relationship within the relational rows and columns.

Audience Experience Level: Beginner, Intermediate, Advanced