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
Introducing IBM Smart Analytics Optimizer - DB2 Performance Revolution (A14)

DATE: 2010-5-14 (09:45 AM - 10:45 AM) SPEAKERS: Namik Hrle (IBM) IBM Smart Analytics Optimizer (ISAO) is an appliance that seamlessly connects to DB2 for z/OS and dramatically accelerates selected data warehouse queries. Your Business Intelligence and Data Warehouse application do not need to...


Namik Hrle's profile image

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...


Suresh Sane's profile image