Webinars

Past webinars

logo Db2 12 Continuous Delivery – New challenges for deployment

April 25th, 2017

Webinar presented by SEGUS & SOFTWARE ENGINEERING

Webinar recording in 4 parts – End of Db2 Releases?

How to align Continuous Delivery to your Continuous Availability?

  1. Agile, Continuous Delivery, DevOps
  2. Db2 Code, Catalog, Function and Application Levels – differences and dependencies
  3. Activation/Deactivation of new code and how to fallback and when you can’t
  4. Different flavors of (pro-active) CD-Screening and how it can be automated

Abstract & videos

Webinar presentation


logo Db2 for z/OS Security Audit: Protecting your Assets

September 28th 2016

By Dave Beulke and Roy Boxwell

40 minutes in 2 Parts

2 White papers on Db2 z/OS Security Audit by Dave Beulke

Abstract & Videos

Webinar presentation


logo Access Path Db2GO

August 01st, 2016

Resetting from bad Access Paths, be they static or dynamic, and clarifying the rather opaque IBM Plan Stability management.

Webinar recording presented by SEGUS & SOFTWARE ENGINEERING

Abstract & video

Webinar recording
Webinar presentation


logo Don’t let ICIs put your Db2 application in the ICU!

April 28, 2016

Webinar presented by SEGUS & SOFTWARE ENGINEERING

40 Minutes in 4 parts on BIF/ICI Detection

How to discover incompatible changes in your Db2 application programs

Craig Mullins   

1 –  The what and why of ICIs (15 min.)
2 – Ways to deal with incompatibilities (15 min.)

Roy Boxwell    

3 –  Customer experiences with SQL WorkloadExpert (9 min.)
4  – Questions & answers to Craig Mullins & Roy Boxwell  (4 min.)

Abstracts & videos

Webinar Presentation


 logo Tuning Your Db2 z/OS SQL Performance

February 18th, 2016

Webinar presented by SEGUS & SOFTWARE ENGINEERING

a 4-in-1 webinar: 20 minutes in 4 parts

The classic answer to any Db2 question is, “it depends!” This is especially the case with SQL.

In this webinar we will show you several different ways to look at the data already available on your machine and outline some proactive methods to improve Db2 z/OS SQL Performance.

  1. Bufferpool Usage (3 min.) 
  2. PKLIST Chain (2 min.)
  3. Application Workload (8 min.)
  4. SQL Time Travel (3 min.)

Abstract & videos

Webinar presentation


logo z/OS Utility Support

September 23rd, 2015

Webinar presented by SEGUS & SOFTWARE ENGINEERING

Have you ever wondered if those really expensive REORG utilities are actually useful or not? Ever been able to verify it?

a 4-in-1 webinar: 30 Minutes in 4 parts

  1. Quiet Times – Is a table in use? (3min.)
  2. Reorg Detection & Reorg Suppression (5 min.)
  3. Cluster Index (5 min.) 
  4. REORG Utility Review (2 min.)

Abstracts & videos


logo SOFTWARE ENGINEERING Where is the BiF?

September 18, 2015

Webinar presented by DBI Software – Db2Night Show – z/OS Edition
Speaker: Roy Boxwell – Senior Software Architect from SOFTWARE ENGINEERING

We have used Built-in Functions since the beginning of Db2, however nowadays when Db2 releases come out some of our old friends do not quite work the way they used to. This presentation will explain what a BiF is, how you can find out details, and then will show real customer results from a BiF hunt.

Webinar video

Webinar presentation


logo Never say never?

June 3rd 2015

Webinar recordings presented by SEGUS & SOFTWARE ENGINEERING

Find out when it’s OK to say “never” to your Db2 Database maintenance.

a 4-in-1 webinar: 20 Minutes in 4 parts

  1. Never Used Objects (5 min.)
  2. Never Executed Packages (2 min.)
  3. Never Executed SQL (2 min.)
  4. Never  Change a Running System (3 min.)

Abstracts & videos

Webinar presentation


logo Db2 Data Warehouse and Real World Use Cases

February 25th, 2015

Webinar recordings presented by SEGUS & SOFTWARE ENGINEERING

Learn how a Db2 Performance Warehouse can quickly and inexpensively gather the information needed to make informed decisions

a 4-in-1 webinar: 30 Minutes in 4 parts

  1. BIF Usage (11 min.)
  2. Index Maintenance Costs (4 min.)
  3. Quiet Times (3 min.)
  4. Audit (5 min.)

Abstract s& videos
Presentation


 logo  25 Years of Missed Opportunities? SQL Tuning Revisited

October 23rd, 2014

Webinar recordins presented by SEGUS & SOFTWARE ENGINEERING

“But that’s the way we’ve always done SQL Tuning” – sound familiar?

The definition of madness is to keep doing the same thing and expecting a different outcome.

Find out how to stop the madness.

Abstrac & video

Webinar recording
Webinar presentation


logo Exploiting Db2 10 new IFCID Technology

February 26th, 2014

Webinar recording presented by SEGUS & SOFTWARE ENGINEERING

Abstract & video

Webinar recording
Webinar presentation


 logo “Do more with less” – webinar series

June 06th, 2013

Basic Db2 10 technology, SQL Workload Analysis and relevant use cases

Part 3: Deep dive into the Winners of the voting from part 2

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract & video

Webinar recording
Webinar presentation


logo “Do more with less” – webinar series

April 25th 2013

Basic Db2 10 technology, SQL Workload Analysis and relevant use cases

Part 2: Introducing use cases

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract & video

Webinar recording
Webinar presentation


logo “Do more with less” – webinar series

March 21st, 2013

Basic Db2 10 technology, SQL Workload Analysis and relevant use cases Basic

Part 1: Basic Db2 10 technology & SQL Workload Analysis

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract & video

Webinar recording
Webinar presentation


logo Cloning, Cloning, Cloning,… isn’t it always the same?

August 29th, 2012

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract & video

Webinar recording
Webinar presentation


logo Db2 for z/OS SQL Performance Plug-in for Rational Developers

March 20th, 2012

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract & video

Webinar recording
Webinar presentation


logo Workload Insights Without a Trace – Introducing Db2 SQL Tracking

March 29th, 2011

Webinar presented by SOFTWARE ENGINEERING & SEGUS
Abstact & video

Webinar recording
Webinar presentation


logo Mastering Dynamic SQL for Db2 z/OS –  Can I control a dynamic world ?

Juli 23rd, 2010

Webinar presented by SOFTWARE ENGINEERING & SEGUS
Abstract & video

Webinar recording
Webinar presentation