Tech Info

Home ] [ What's New ] [ Meetings ] [ Tech Info ] [ SDUG ] [ Shareware ] [ Committee ] [ GSE Info ] [ Feedback ]



On this page, you will find all the presentations, papers and other technical material related to presentations given at our meetings. All the material is zipped to reduce download times. You can also find links to the presentations made at a specific meeting by going to the Meetings Page. Where a session has been presented more than once or at both the User Group and at SDUG, only the latest version is provided.

Subject Headings

Application Development

Scrolling Scrolling Scrolling

Phil Grainger, CA

SDUG Oct 08

Multi Row Fetch, Insert & Get Diagnostics
How to put it into COBOL code

Paul Fletcher, IBM

Jun 08 & SDUG May 08

Scrollable cursors

Aurora Dell'Anno

Oct 07

Application Development Current Tools Landscape

Grant Hutchison, IBM

Oct 07

Exploiting DB2's Power Through Serious SQL

George Baklarz, IBM

Oct 07

Design for High Availability

John Campbell, IBM

Oct 07

The Stored Procedure Story

Stewart Smith, Standard Life

SDUG Sep 07

DB2 and Rails

Phil Nelson, Scottish Widows

SDUG Apr 07

Rexx and DB2

Jim Addison, Standard Life

SDUG Aug 06

SQL for the Relationally Challenged

George Baklarz, IBM

Oct 05

Exits, CLIs and VTAM(tape)

Stewart Smith, Standard Life

SDUG Sep 05

Developing Cross Platform SQL Routines

Sathyaram Sannasi

Mar 05

Error Handling in UDFs, SPs, and Triggers, Part 1

Peter Backlund, DB2-Konsult AB

Mar 04

Error Handling in UDFs, SPs, and Triggers, Part 2

Peter Backlund, DB2-Konsult AB

Mar 04

Taking the Plunge with Stored Procedures!

Stewart Smith, Standard Life

Mar 04

Using an Identity Column Table to simulate a Sequence

Kenneth McKinnon, Scottish Widows

Dec 03

The Curse of the Dead Sea Scrollables -
A DB2 for z/OS Story

Aurora Dell'Anno, Bank of America

Oct 03

Designing Tables and Structures for 24x7

James Surber, DST Systems

Oct 03

WLM Stored Procedures - A Survivors tale

Mike Holmans, BT

Jun 03

Batch: Love it or hate it - it just won't go away

Andy Lankester, BMC

Jun 01

Triggers: What, How and When?

Phil Grainger, CA

Sep 00

Are you having an Identity Crisis?
DB2 ID Columns can help!

Julian Stuhler, Triton Consulting

May 00

Problematic Packages

Phil Nelson, Scottish Widows

Dec 97

Backup, Recovery and Disaster Recovery

DB2 9.5 High Availability Options (LUW)

George Baklarz, IBM

Jun 08

Recovery Workshop

Ulf Heinrich, Software Engineering

Mar 08

Are you sure you’re sure? DB2 Maintenance 2007 Guidelines

Ulf Heinrich, Software Engineering

Jul 07

Up and Running with DB2 UDB 8.2 High Availability Disaster Recovery

Paul Read, IBM

Mar 05

Less than 10s Failover with DB2 UDB on Linux

Simon Harris, IBM

Mar 04

Restart Recovery in DB2 V8.1 for LUW

Julian Stuhler, Triton Consulting

Oct 03

Using Advanced Technology for OS/390 Backup and Recovery

Steve Thomas, BMC

Jun 03

Exploiting storage devices for DB2 backup & recovery

Steve Thomas, BMC

Sep 00

Optimizing recovery for very large databases

David Owen, BT

Mar 99

1998 Disaster Recovery Survey

Derek Storkey, BMC

1998

DB2/MVS disaster recovery options

John Hancock, CITL

Mar 98

Disaster recovery at TNT

Mandy Zitola, TNT

Mar 98

Disaster Recovery at Bradford & Bingley

Steve Snook, Bradford & Bingley

Mar 98

Disaster recovery: Preparing for Application Recovery within BT

David Owen, BT

Mar 98

Connecting to DB2

DB2 and DRDA - Getting the family talking

Phil Nelson, ScotDB Ltd.

May 04

DB2 Connect De-Mystified

Neale Armstrong, IBM

Oct 03

Inside Websphere

Dan Murphy, IBM

Jun 02

DB2 & Websphere integration

Dan Murphy, IBM

Jun 02

IBM Net.Data - Enabling The DataWeb

Julian Stuhler, Triton Consulting

Sep 96

Data Sharing

DB2 9 for z/OS Performance

John Campbell, IBM

Oct 07

Design for High Availability

John Campbell, IBM

Oct 07

Data Sharing Performance & Tuning Considerations

Maria Sarikos, CA

Jun 05

High availability with DB2 Data Sharing

David Owen, BT

Sep 00

DB2 Data Sharing in production

Steve Crocker, Barclays

Dec 97

Data Warehousing & Business Intelligence

Data Warehouse and Business Intelligence on System z – where we are and where we go from here

Dirk Johann, IBM

Oct 08

Data Warehouse & BI Solutions for System z - Current and Futures

Roger Miller, IBM

SDUG Oct 08

DB2 Warehousing and Business Intelligence Features

Kevin Jones, IBM

SDUG Sep 07

DB2 Business Intelligence Best Practice (MQts and MDCs)

Angus Beaton, IBM

SDUG Aug 06

Delivering a Balanced Data Warehouse Environment using Design Best Practices

Simon Field, IBM

May 06

DB2's new OLAP subsystem - Cube Views

Samantha Hurst, IBM

Dec 03

VLDB HSM Data Warehouse Solution

Shahin Taromsari, IBM

Jun 03

Building a Data Warehouse with DB2 EEE and HSM

James à Court, IBM

Jun 02

Barclaycard Customer services transaction database -
a large scale warehouse style DB2 system

Andrew Wharton, Barclaycard

Mar 02

Database Administration

Reordered Row Format in DB2 9 for z/OS

Paul Fletcher, IBM

Oct 08

Experiences with Large Tablespaces

Neil Paton, Standard Life

SDUG Apr 07

Online Schema Evolution

Steve Thomas, BMC

May 06 & SDUG Mar 06

Maintaining Near 24x7 During Table Changes

James Surber, DST Systems

Oct 03

DB2 Administration Best Practice Pts 1 & 2

Edward Vassie, BMC Software

Dec 99 & Mar 01

DB2 for Linux, Unix & Windows

DB2 9.5 Customer Experiences

Simon Woodcock, IBM

March 09

DB2 9.5 LUW Technology Overview

Pav Kumar-Chatterjee, IBM

SDUG May 08

DB2 for LUW 9.5 Technology Overview

George Baklarz, IBM

Oct 07

UDB 8.2.2 and Automated Storage

Stewart Smith, Standard Life

SDUG Apr 07

Things I wish they had when I was a DBA

Paul Zikopoulos, IBM

SDUG Nov 06

Data Partitioning in Viper

Paul Read, IBM

May 06

DB2 Data Partitioning Feature

Simon Woodcock, IBM

Oct 05

DB2 LUW - An Overview

Kevin Jones, IBM

SDUG Sep 05

DB2 for LUW Monitoring & Tuning Primer

Phil Nelson, ScotDB Ltd.

Jun 05

DB2 LUW for Smarties Part 1

Maria Sarikos, CA

Jun 05

Exploiting DB2 for LUW V8 for Real!
(Please see Slides 101 onwards for the material that Phil presented at our meeting)

Phil Nelson, ScotDB Ltd.

Dec 04

DB2 for LUW: Understanding and Managing Sort Performance

Sathyaram Sannasi

Oct 04

DB2 Event Monitoring

Sathyaram Sannasi, Thesaurus

May 04

DB2 for LUW V8 - Capturing and analyzing monitoring data becomes easier

Dr. Iqbal Goralwalla, Triton Consulting

May 04

Hidden Gems: DB2 Registry and Config Parameters

Phil Nelson, ScotDB Ltd.

Mar 04

DB2 for LUW: What's new since V8 GA (up to V8.1.4)

Phil Nelson, ScotDB Ltd.

Dec 03

Partitioning data with DB2 on LUW

Simon Woodcock, IBM

Dec 03

DB2 UDB Backup & Recovery Strategies

Phil Nelson, Scottish Widows

Mar 02

DB2 UDB V6.1

Paul Read, IBM

Jun 99

A day in the life of a UDB SQL statement

Anthony Cunningham, IBM

Mar 99

DB2 UDB Workstation performance

Paul Read, IBM

Dec 98

Federation, Information Integration & Content Management

IBM Websphere Information Integration -
Event Publishing Briefing

Neale Armstrong, IBM

SDUG Sep 05

Experiences using Federation to Access the DB2 Family

Sathyaram Sannasi, KAM Technology

Jun 05

DB2 II 8.2 Q Replication & Event Publishing -
The Elevator Tale

Pav Kumar-Chatterjee, IBM

Dec 04

DB2 Information Integrator Technical Introduction

Neale Armstrong, IBM

Oct 03

IBM Announcements

The following items are from the "IBM Announcements" section of each meeting for the last 5 years

June 2009 Meeting

Mike Skidmore, IBM

Jun 09

May 2006 Meeting

Mike Skidmore, IBM

May 06

March 2006 Meeting

Mike Skidmore, IBM

Mar 06

June 2005 Meeting

Mike Skidmore, IBM

Jun 05

March 2005 Meeting

Paul Read, IBM

Mar 05

December 2004 Meeting

Pav Kumar-Chatterjee, IBM

Dec 04

May 2004 Meeting

Mike Skidmore, IBM

May 04

March 2004 Meeting

Mike Skidmore, IBM

Mar 04

Java

New Technology Directions for Java Database Access

Gareth Jones, IBM

Mar 08

JDBC vs SQLJ - Things you need to know

Maria Sarikos, CA

SDUG May 05

SQLJ Implementation Experiences in DB2 for z/OS

Julian Stuhler, Triton

Mar 05

How do these EJB's affect my Database Performance?

Jonathan Rosenblitt

Dec 03

Java: Design for High Performance

John Campbell, IBM

Jun 02

Java and Design for High Performance

John Campbell, IBM

Dec 01

Java Technology update

John Campbell, IBM

Jun 01

Java Stored Procedures for DB2

Julian Stuhler, Triton Consulting

May 00

Universal Beans, Java & DB2

Matthew Perrins, IBM

Sep 99

Miscellaneous

Do Extent Numbers really matter any more?

Steve Thomas, BMC

Jun 09 & SDUG May 09

SolidDB and Universal Cache in front of DB2

John Pickford, IBM

March 09

A Row's Life

Raymond Bell, BMC

Oct 08

Are you sure this is DB2?

Aurora Dell'Anno, CFS

Oct 08

Introduction to DB2 on the Mainframe

Gareth Jones, IBM

Oct 08

DSN1LOGP - It could save your job one day

Raymond Bell, BMC

Jun 08

The DB2 on Campus Program

Raul Chong, IBM

Jun 08

Why does my wife (still) not understand what I am doing?

Ulf Heinrich, Software Engineering

Oct 07

Migrating non-relational DB's to DB2

Tim Fearns, Blue Phoenix

Oct 07

Introduction to DB2 for z/OS

Gareth Jones, IBM

Oct 07

Exploiting IMS Databases in Websphere

Alan Cooper, IBM

SDUG Sep 07

What does Web 2.0 mean to the Enterprise?

Matthew Perrin, IBM

Apr 07

Check it out! Your DB2 environment reviewed

Aurora Dell'Anno, Compuware

Apr 07

Top 10 Tips to Crash your DB2

Dirk Johann, Software Engineering

Oct 06

Send in the Clones - A Personal Account of Subsystem Cloning

Marcus Davage, Llloyds TSB

Mar 06

A Brief Overview of DSNZPARMs

Alan Black, IBM

SDUG Sep 05

Using the Spatial Extender

A. Hawkins & A. Rumble, ESRI

Dec 03

DB2 and Websphere MQ

James à Court, IBM

Oct 03

Hitchhikers Guide to Unicode

Maria Sarikos, CA

Oct 03

Are you sure this is DB2? Contrasting DB2 for Mainframe and Distributed Systems

Aurora Dell'Anno, Quest

Jun 03

Grid and Database Technology

Shahin Taromsari, IBM

Jun 03

Unicode - What does it mean to DB2?

Steve Thomas, BMC

Oct 02

Feedback from Vienna IBM Software Symposium

Geoff Locke, CAP Gemini Ernst &. Young

Jun 02

From 1.2Tb to 18Tb and more - A VLDB story

David Owen, BT

Mar 01

Small Town DB2

Phil Nelson, Scottish Widows

Dec 98

DB2 V2.3 to V5 upgrade experiences

Julian Stuhler, Triton Consulting

Dec 98

New Version Information

DB2 9 for z/OS: Planning and Experiences

Gareth Jones, IBM

Jun 09

DB2 9 for z/OS Performance Update

Gareth Jones, IBM

Jun 09

DB2 for z/OS: What's all the fuss about Version 8 and Version 9?

Gareth Jones, IBM

Oct 08

DB2 9 for z/OS Table Changes

Phil Grainger, CA

Oct 08 & SDUG May 08

Planning your Migration to DB2 9

Roger Miller, IBM

SDUG Oct 08

DB2 for z/OS Futures and Data Studio

Roger Miller, IBM

SDUG Oct 08

Position Power! DB2 for z/OS Spatial Features

Julian Stuhler, Triton Consulting

Mar 08

DB2 9 for z/OS Functional Overview

Phil Grainger, CA

Oct 07

DB2 for LUW 9.5 Technology Overview

George Baklarz, IBM

Oct 07

DB2 9 for z/OS XML Support

Phil Grainger, CA

SDUG Sep 07

Beyond DB2 Viper - Technology Trends and Directions

George Baklarz, IBM

Apr 07

Version 8 Experiences

Colin Roberts, British Energy

Oct 06

DB2 9 for z/OS - Beta Programme Announced

Rober Miller, IBM

Oct 06

What's new in DB2 9 for z/OS also zIIP

Roger Miller, IBM

Oct 06 & SDUG Nov 06

Planning Migration to DB2 V8 & 9

Roger Miller, IBM

Oct 06

DB2 9 for LUW

Paul Zikopoulos, IBM

Oct 06 & SDUG Nov 06

DB2 for z/OS V8 Migration Experiences

Jay Yothers, IBM

May 06

DB2 for z/OS Technology Futures

John Campbell, IBM

Mar 06

DB2 Row Compression in Viper

Simon Woodcock, IBM

Mar 06

V8 Migration Steps and Considerations

Dave Owen, DOCE

SDUG Mar 06

DB2 UDB High Availability Options

Kevin Jones, IBM

SDUG Mar 06

DB2 UDB Technology Directions

George Baklarz, IBM

SDUG Oct 05

Having NEWFUN with DB2 V8 - The Hard Facts of (RE)BINDS

Dirk Johann, Software Engineering

Oct 05

Version 8 for Developers

Krysia Winska

Oct 05

Raising the Bar. DB2 for OS/390 and z/OS V8 64 bit Exploitation

Julian Stuhler, Triton

SDUG May 05

DB2 Version 8 Customer Experiences

John Campbell, IBM

SDUG May 05

What's New in Version 8 for Application Developers

Phil Grainger & Maria Sarikos, CA

Dec 04 & Mar 05

DB2 V8 Very Early Experiences

John Campbell, IBM

Oct 04

DB2 V8 SQL Enhancements

David Owen, DOCE

Oct 04

What's new in DB2 Stinger

Louise Pressler, IBM

Oct 04

Incidents and Accidents DB2 UDB Stinger Beta Overview

Paul Read, IBM

May 04

Data Partitioning Secondary Indexes for DB2 for z/OS V8

David Owen, DOCE

Oct 03

DB2 for z/OS V8 Online schema and indexing enhancements

Sarah Ellis, IBM

Jun 03

DB2 V7 early experiences

John Campbell, IBM

Jun 01

DB2 V7

Sarah Ellis, IBM

May 00

DB2 V6 recent enhancements

Sarah Ellis, IBM

May 00

DB2 - The future's closer than you think

Julian Stuhler, Triton

Sep 99

DB2 V5 recent enhancements

Mike Bracey, IBM

Jun 99

Performance

DB2 9 for z/OS Performance Update

Gareth Jones, IBM

Jun 09

What will Rebind do for me

Paul Fletcher, IBM

Jun 09 & SDUG May 09

Memory Matters in 2009

Martin Packer, IBM

Oct 08

DB2 Bufferpool administration, performance analysis, tuning and optimisation

Mike Fitzgerald, Fitz Software

Oct 08

Lies, Damned Lies & Statistics

Andy Ward, CA

Oct 08

DB2 for z/OS Selected Performance Topics

Roger Miller, IBM

SDUG Oct 08

DB2 9 for z/OS Performance

John Campbell, IBM

Oct 07

Demystifying the DB2 Dynamic Statement Cache

Bill Arledge, BMC

Jul 07

Getting the most out of your DB2 Storage Pools

Steve Thomas, BMC

Apr 07

DB2 for z/OS V8 & 9 Performance

Roger Miller, IBM

Oct 06

Reorganisation Strategies in Depth

Peter Plevka, BMC

Oct 06

Getting to Grips with Dynamic SQL

Paul Fletcher, IBM

Oct 06

DB2 for z/OS Bufferpool Management

Mike Bracey, IBM

SDUG Aug 06

DB2 UDB for z/OS Performance and CPU Tuning Recommendations

John Campbell, IBM

Mar 06

Explain Tables Come out of the Closet

Gerry Hodge, HLS Technologies

Mar 06

Unlocking The Secrets of the DB2 Instrumentation Facility With REXX

Paul Fletcher, IBM

Oct 05

Dynamic SQL and Performance - A Contradiction in Terms?

Hans Peeters, Data Base Solutions AG

Jun 05

Fast Track to Optimal DB2 for z/OS Performance

John Campbell, IBM

SDUG May 05

Get Ready for V8 - Why to Care for BINDs and REBINDs

Ralf Neumann, Software Engineering

Dec 04

A Light in the Dark for the Optimizer - Using DSTATS and V8 RUNSTATS enhancements the Intelligent Way

Dirk Johann, Software Engineering

Dec 04

Hardware Conscious Index Design

Tapio Lahdenmaki

Oct 04

Understanding the Mechanics of Good Index Design

Maria Sarikos, CA

Oct 04

System Monitoring Topics for DB2 V8

Paul Prior, BMC Software

Oct 04

DB2 for z/OS EDM Pool Management, Monitoring & Tuning

George Wise, Wise Ltd.

May 04

Memory Performance Management in a 64-bit World

Martin Packer, IBM

Mar 04

Improved Performance through Online Maintenance

Ulf Heinrich, Software Engineering

Dec 03

It's time to rethink your Buffer Pool strategy

Martin Hubel, MHC Inc.

Mar 03

A simple approach to Index redesign

Martin Hubel, MHC Inc.

Mar 02

Analyzing DB2 Performance data with OLAP

Martin Hubel, MHC Inc.

Mar 02

DB2 for z/OS & OS/390 Performance Update

John Campbell, IBM

Dec 01

Index Tuning

Rob Lenzie, Cogito

May 00

Tuning DB2 at CGU Life

Mike Barnard, CGU

Sep 99

Performance improvement in your spare time

Mike Holmans, BT

Jun 99

What do ZPARMS and Bpool parameters mean?

Edward Vassie, Sema

Mar 99

Finding the best clustering index

Rob Lenzie, BT

Mar 99

DBMS Conversion: DB2 Performance Modelling using DB2 Estimator

John Campbell, CITL

Dec 97

Using DB2 Estimator

John Campbell, CITL

Nov 97

DB2 Bufferpool sizing

Mike Barnard, GA Life

Jun 97

Application Performance Improvement through Intelligent Reorganisation

Bernard Lafforet, Infotel SA

Jun 97

DB2 Locking & Latching - Part 1

Sean Dunn, MEB

Feb 97

Security and Compliance

DB2 9 for z/OS Security Update

Gareth Jones, IBM

Jul 07

Protect, Retain and Comply with your DB2 data

Roger Miller, IBM

SDUG Nov 06

Securing rows with SECLABELS

Mike Holmans, BT

Oct 05

DB2 & - Breaking down the barriers

Julian Stuhler, Triton Consulting

Dec 97

IBM Tools, Utilities and ISV presentations

Introduction to PureQuery

Neale Armstrong, IBM

SDUG May 09

Customer experiences with Data Studio

Tiffany Money, IBM

March 09

To REORG or not to REORG, That is the Question

Kevin Baker, BMC

Oct 08

How to choose a DB2 Tool Solution for YOU!

Phil Grainger, CA

Jun 08 & SDUG May 08

An Introduction to WebSphere Replication Server and Data Event Publisher

Beth Hamel, IBM

Jul 07 & SDUG Jul 07

Are you a RUNSTATS Master?

Roy Boxwell, Software Engineering

Oct 06

Relational Data Architect - Overview

Hong-Lee Yu, IBM

May 06

DB2 Performance - Making the End Run Successful

Mike Bracey, IBM

SDUG Mar 06

How to clone a DB2 Subsystem in Record Time

Geoff Littlewood, Mainstar

Oct 05

IBM Office Connect

Simon Hildersley, IBM

Jun 03

DB2 Replication V8 Technical Update

Neale Armstrong, IBM

Jun 03

Quest software solutions for DB2

Sandra Kay, Quest

Mar 03

Multiplatform Tools for DB2 UDB

Karen Dewar, IBM

Mar 03

From DB2 Performance barriers to Breakthrough results (DGI)

Martin Hubel, MHC Inc.

Mar 03

IBM Online Reorg - When to, when not to, and why nots

Phil Grainger, CA

Sep 99

XML

Introduction to SQL/XML

Pav Kumar-Chatterjee, IBM

SDUG May 09

Flowers and Financial Services: B2B with DB2 PureXML

Phil Nelson, Scottish Widows/ScotDB Ld.

Mar 09 & SDUG May 09

XML Experiences

Ulf Heinrich, SOFTWARE ENGINEERING

Oct 07

DB2 9 for z/OS XML Support

Phil Grainger, CA

SDUG Sep 07

DB2 and XML Overview

Kevin Jones, IBM

SDUG Apr 07

DB2 9 for LUW XQuery and SQL/XML

George Baklarz, IBM

Apr 07

XML Evolution - Native XML Support

Dave Owen, DOCE

Oct 06

Enhanced XML Support in DB2 LUW

Dave Owen, DOCE

SDUG Mar 06

MQ Listening and XML Shredding

Phil Nelson, Scottish Widows

Mar 06 & SDUG Mar 06

DB2 UDB and XML - "The Odd Couple"

Paul Read, IBM

Oct 05

XML Enhanced Support in DB2 for LUW

Dave Owen, DOCE

Mar 05

DB2 and XML

Steve Thomas, BMC Software

Oct 04



Please email our webmaster, steve_thomas@bmc.com with questions or comments about this web site.
Copyright © 2009 UK DB2 User Group
Last modified: June 22nd, 2009