Webinars

Past webinars

logo The Db2Night Show z/OS Edition #Z85

Db2 12 Continuous Delivery – New challenges for deployment

March 16th, 2018
Webinar presented by SEGUS & SOFTWARE ENGINEERING

with

  • Martin Hubel, IBM Gold Consultant & IBM Champion for IM

  • Roy Boxwell, Senior Software Architect

How does Db2 12 Continuous Delivery affect
Db2 12 Migration/maintenance strategies?

Code, Catalog, Function & Application Levels

Db2 12 Continuous Delivery - Deployement - Db2 12 Agile -

Abstract & Video

dbisoftware 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 & video

Webinar presentation


Past Webinars

logo Access Path Db2GO

1st August 2016

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

Webinar presented by SEGUS & SOFTWARE ENGINEERING

Abstract & video

Webinar recording
Webinar presentation


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

28th April 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

18th February 2016

Webinar presented by 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 Chains (2 min.)
  3. Application Workload (8 min.)
  4. SQL Time Travel (3 min.)

Abstract & Videos

Webinar Präsentation


 logo z/OS Utility Support

 23rd September 2015

Webinar presented by 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 (5min.) 
  4. REORG Utility Review (2 min.)

Abstracts & Videos


logo Where is the BiF?

Db2Night Show – z/OS Edition

18th September 2015

Webinar organized 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?

3rd June 2015

Webinar 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.)

Abstract & Videos

Webinar presentation


 logo Db2 Data Warehouse and Real World Use Cases

25th February 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 & videos 
Presentation


 logo 25 Years of Missed Opportunities? SQL Tuning Revisited

23rd October, 2014

Webinar 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.

Abstract

Webinar recording
Webinar presentation


 logo Exploiting Db2 10 new IFCID Technology

26th February 2014

Webinar presented by SEGUS & SOFTWARE ENGINEERING

Abstract

Webinar recording
Webinar presentation


logo “Do more with less” – webinar series

06th June 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

Webinar recording
Webinar presentation


logo “Do more with less” – webinar series

25th April 2013

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

Part 2: Introducing use cases

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract

Webinar recording
Webinar presentation


 logo “Do more with less” – webinar series

21st March 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

Webinar recording
Webinar presentation


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

29th August 2012

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract

Webinar recording
Webinar presentation


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

20th March 2012

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract

Webinar recording
Webinar presentation


logo Workload Insights Without a Trace – Introducing Db2 SQL Tracking

29th March 2011

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract

Webinar recording
Webinar presentation


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

23rd Juli 2010

Webinar presented by SOFTWARE ENGINEERING & SEGUS

Abstract

Webinar recording
Webinar presentation