Search

1 to 10 of 205
Sort by

Blog Entry
The (unknown) benefits of FETCH FIRST in DB2 for z/OS SQL

Let’s start this discussion candidly – I am a big fan of the FETCH FIRST n ROWS ONLY clause coded in a SQL statement. That assertion will require some clarification, since there are some valid use cases, and others that make little sense. Regardless, I will try not to over-complicate the...

Terry Purcell's profile image




Blog Entry
How to Avoid Dramatic Access Path Changes in DB2 for z/OS Dynamic SQL (or at Least Fix Them Quickly)

By Kurt Struyf, Lone Star Consulting This article is based on a recent tuning engagement at a customer site and describes the countermeasures that were enacted to restore system performance. Those countermeasures include a daily process to establish an access path baseline and sample jobs...

Kurt Struyf's profile image


Blog Entry
IDUG – 25 Years and Roger Miller

I was the conference chair for IDUG North America in Anaheim, CA in 2011. During the opening session I had the privilege of honoring Roger Miller and his contributions to DB2 and IDUG as it would be Roger’s last IDUG conference before his retirement. We presented Roger with a crystal globe...


Blog Entry
IDUG 25th Anniversary 7 Tips for DB2 Performance by Dave Beulke

As DB2 reaches its 30 th anniversary and IDUG reaches its 25 th anniversary, I’ve thought about many DB2 tips and best practices that have been incorporated by companies, projects and applications that have led to great successes. The ones that have been most common and have had the greatest...


Library Entry
Real-world strategies for managing undesirable access paths (A15)

DATE: 2010-5-14 (11:00 AM - 12:00 PM) SPEAKERS: Suresh Sane (DST Systems Inc) In a DB2 production environment, almost all software changes are Typically tightly controlled, but the impact of production binds and rebinds is not. This can result in unpredictable performance since it must be dealt...

NA10A15.pdf

Suresh Sane's profile image

Library Entry
DB2 LUW Design Advisor - db2advis ? Miracle-Worker or Monster-In-Law (D13)

DATE: 2010-5-14 (08:30 AM - 09:30 AM) SPEAKERS: Alexander Kopac (Home Depot) The DB2 LUW Design Advisor is cool tool designed to help define suitable indexes and for testing SQL workloads. Here's a presentation that covers both the command line syntax basics and the GUI approach for making both...

NA10D13.pdf