Colorado DB2 Regional User Group
Consolidated List of Presentations

Below is a consolidated list of the presentations that have been delivered at the Colorado DB2 Users Group for z/OS.



Application Development



September 22, 2005	John Vonau	IBM	DB2 and Java Universal Driver, SQLJ and Stored Procedures
September 22, 2005	John Vonau	IBM	Java Tips, Performance and Driver Update
March 16, 2006	Rob Crane	FedEx Freight Systems	A Nuts and Bolts Approach to Plans and Packages
July 20, 2006	Sheryl Larsen	Sheryl M. Larsen, Inc.	Top Application Impacts on Performance
December 15, 2006	Sheryl Larsen	Sheryl M. Larsen, Inc.	Extreme SQL and Object Tuning for Performance
April 19, 2007	Steen Rasmussen	Computer Associates	How to be a Hero by taking small steps
April 19, 2007	Marc Costa Rob Crane	FedEx Freight Systems	Put a smile on your DBAs face Performance for the Developer (and you know-it-all DBAs)
August 23, 2007	John Vonau	IBM	Java Common Client Enhancements
August 23, 2007	Bill Arledge	BMC	Ins and Outs of Distributed Processing in DB2 for z/OS
August 23, 2007	Bruce Fischer	IBM	Controlling Data Growth Through Database Archiving in a DB2 Environment
May 01, 2008	Matt Ramsey & Bob Vargo	Progressive	Creating customized tools for DB2 for z/OS
May 01, 2008	Rob Crane	FedEx Freight	I love packages and SQLJ




DB2 Version 08



November 11, 2004	John Lyle	IBM	DB2 V8 Online Schema Evolution
November 11, 2004	John Lyle	IBM	DB2 V8 Migration Planning
November 11, 2004	John Lyle	IBM	DB2 V8 SQL Enhancements
March 17, 2005	Randy Ebersole	IBM	Let’s Look at Materialized Query Tables for DB2 V8 z/OS
March 17, 2005	Steen Rasmussen	Computer Associates	V8 Table Partitioning - the Good, the Bad and the Ugly
March 16, 2006	Willie Favero	IBM	UDB DB2 for z/OS V8 Planning
March 17, 2005	Kevin Harrison	IBM	Update from IBM on DB2 Version 08
July 20, 2006	John Iczkovits	IBM	New Cool SQL Enhancements in DB2 for z/OS Version 8
May 01, 2008	Marc Costa	FedEx Freight	Urban Legend: Upgrade from DB2 for z/OS V7 to DB2 for z/OS V8 (NFM) In Less Than 90 days




DB2 Version 09



July 20, 2006	Kevin Harrison	IBM	What does V9 have that your Business needs!
April 19, 2007	John Lyle	IBM	Attack of the DB2 for z/OS Clones - Clone Tables that is!
April 19, 2007	John Lyle	IBM	DB2 UDB for z/OS Indexes - An insiders look
August 23, 2007	Kevin Harrison	IBM	DB2 9 – Technical Overview with Redbook experiences
May 01, 2008	Wille Favero	IBM	Structure and Format Enhancements in DB2 9 : UTS & RRF
Dec 11, 2008	John Campbell	IBM	DB2 9 for z/OS:Planning and Experiences
Apr 24, 2009	Bryan Paulsen	John Deere	DB2 9 for z/OS – John Deere’s ESP Experience




DB2 Version Next



Dec 11, 2008

John Campbell

IBM

DB2 Trends and Directions




Disaster Recovery



March 17, 2005	Bob Leedom Rob Crane	FedEx Freight Systems	Mile High DR – Things I wish I had been told
April 24, 2009	Bryan Paulsen	John Deere	DB2 BACKUP SYSTEM and RESTORE SYSTEM Enhancements




For DBAs



March 16, 2006	Steen Rasmussen	Computer Associates	Exploiting the Log's Many Possibilities
March 16, 2006	Willie Favero	IBM	The Good, the Bad and the really Ugly: DSNZPARM
April 24, 2009	David Simpson	Themis Inc.	Physical Database Design for the 21st Century
April 24, 2009	Becky Keller	EDS	Tips and techniques for a DB2 Systems Programmer




Tuning



March 17, 2005	Brad Clevinger	EDS	DB2 Application Tuning 101: The Nuts and Bolts
Dec 11, 2008	John Campbell	IBM	Optimizing System Performance Using DB2 Statistics Trace [part I & II]
Apr 24, 2009	David Simpson	Themis Inc.	SQL Optimization & Access Paths: What’s Old & New




Technical Updates



September 22, 2005	Kevin Harrison	IBM	IBM Technical Exchange - V8 Updates
March 16, 2006	Kevin Harrison	IBM	IBM DB2 Update, z/OS architecture (zIIP, zAAP, IFL)
July 20, 2006	Kevin Harrison	IBM	IBM State of the Union DB2 z/OS update, PTF updates, etc.
December 15, 2006	Kevin Harrison	IBM	IBM DB2 for z/OS Update
August 23, 2007	Kevin Harrison	IBM	IBM DB2 for z/OS Update
May 01, 2008	Kevin Harrison	IBM	IBM DB2 for z/OS Update