Monday, May 10, 2010

Presentations from Heart of America DB2 Users Group

Hi DB2 user,

Here are several presentations from Heart of America DB2 Users Group, available on HOADB2UG website:

- Real-world strategies for managing undesirable access paths
by Suresh Sane

- Stabilizing Access Paths Across Rebind
by Terry Purcell

- DB2 for z/OS Data and Index Compression
by Willie Favero

- A Peek into the 24x7 VLDB DBA's Toolsbox
by David Simpson

- Workloads, Monitors, Advisors: V9 OSC Experiences
by Terry Berman

- SQL Queries on Speed
by Dan Anderson

- Application Buffering of DB2 Data
by Michael Todd

- V9 SQL for the Application Developer and DBA – Richer and Faster
by Suresh Sane


Regards,

DB2usa.

Labels: , ,


Monday, October 5, 2009

IDUG Solutions Journal (Summer 2009)

Hi DB2 user,

Summer 2009 issue of IDUG Solutions Journal is available on line:


Current issue contains following articles:

- Escaping the REBIND blues in DB2 9 for z/OS
by Adarsh Pannu and Terry Purcell

- Best practices- DB2 9 for z/OS migration
by Roger Miller

- An Overview of Mainframe Specialty Processors
by Craig Mullins


Regards,

DB2usa.

Labels: , , , ,


Monday, February 9, 2009

IDUG Solutions Journal (Winter 2008)

Hi DB2 user,

Winter 2008 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Winter 2008 (PDF format)

Current issue contains following articles:

- Star Gazing from atop your DB2 z/OS Database Server
by Terry Purcell and Gene Fuh

- Selected Performance Features of DB2 9 for z/OS, tested in a PeopleSoft Enterprise Applications Environment - Part 2
by Brian Holroyd

- Recent DB2 for z/OS Performance Measurements
by Roger Miller

- Database Fundamentals
by Craig Mullins


Regards,

DB2usa.

Labels: , , ,


Monday, January 7, 2008

Presentations from Heart of Texas DB2 Users Group

Hi DB2 user,

Here are several presentations, available on Heart of Texas DB2 Users Group website:

- What’s New with the Optimizer in DB2 for z/OS V8?
by Terry Purcell and Brian Baggett

- More Ways to Challenge the DB2 z/OS Optimizer
by Terry Purcell

- Parlez-Vous Klingon? Recursion SQL for Generating Test Data
by Alexander Kopac

- Demystifying the DB2 Dynamic Statement Cache
by Bill Arledge


Regards,

DB2usa.

Labels: ,


Monday, June 18, 2007

Access Path Selection presentations

Hi DB2 user,

Here are several presentations about Access Path Selection with DB2 for z/OS, available on Tridex User Group Website:

- Why did The Optimizer choose that Path - Part 1
- Why did The Optimizer choose that Path - Part 2
by Terry Purcell

- EXPLAIN tables come out of the closet
- How an Access Path gets selected
by Gerald Hodge


Regards,

DB2usa.

Labels: ,


Thursday, May 3, 2007

IDUG Solutions Journal (Spring 2007)

Hi DB2 user,

Spring 2007 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Spring 2007 (format PDF)

All issues from IDUG Solutions Journal

Current issue contains following articles:

- DB2 Locking - Success or Failure in Managing DB2
by Bill Arledge and Judy Quenet

- Fastest Reorganization Is No Reorganization
by Peter Plevka

- What Can DB2 9 Data Compression Do For You?
by Martin Hubel

- Tuning Methodology for Demystifying the DB2 z/OS Optimizer (updated)
by Gene Fuh and Terry Purcell

- DB2 9 for z/OS Performance Summary
by Akira Shibamiya and Roger Miller

- Database Performance Fundamentals
by Craig Mullins


Regards,

DB2usa.

Labels: , , , ,


Sunday, February 4, 2007

IDUG Solution Journal (Winter 2006)

Hi DB2 user,

Winter 2006 issue of IDUG Solutions Journal is available on line:

IDUG Solutions Journal Winter 2006 (format PDF)

All issues from IDUG Solutions Journal

Current issue contains following articles:

- Anixter’s Migration to DB2 for z/OS Version 8
by Damon Anderson and Bernie O’Connor

- DB2 Top Tips: A "Hat Trick" - Three Tips for Busy DBAs
by Damon Anderson

- DB2 UDB for z/OS 8 and V9 Features and Functionality for PeopleSoft part 2
by Brian Holroyd

- Tuning Methodology for Demystifying the DB2 z/OS Optimizer
by Gene Fuh and Terry Purcell

- Programming for the New DB2
by Maria Sarikos

- Using the Real Time Statistics
by Craig Mullins


Regards,

DB2usa.

Labels: , , ,


Tuesday, January 30, 2007

Optimization with DB2 for z/OS Version 8

Hi DB2 user,

Here are three presentations about DB2 for z/OS Optimizer, available on IBM wesbite:

- Control your own destiny, implementing DB2 for z/OS optimization hints
by Patrick Bossman (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27005489


- Autonomic Optimization in DB2 Version 8 and Beyond
by Terry Purcell (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27004785


- Major Optimization Enhancements in DB2 Version 8
par Terry Purcell (IBM SVL)
http://www.ibm.com/support/docview.wss?uid=swg27004786



Regards,

DB2usa.

Labels: ,