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.
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 |
| 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 |
The following items are from the "IBM Announcements" section of each meeting.
| 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 |
| DB2 9 for z/OS Table Changes |
Phil Grainger, CA |
SDUG May 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 |
| 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 |
