The Value of the IDUG Tech Library

Anecdote from the real life "Finding value in a presentation given seven years ago"

Although generally the migrating to DB2 9 done recently at UBS was a very smooth experience, we did encounter a couple of performance degradations due to changes in access path. One of these where particular troublesome, because in general there was a need to have REOPT(ALWAYS) enabled for statements in the affected package, but for the trouble statement we needed to have an OPTHINT to fix the access path to always be the same.

After a bit of investigation and searching the Internet, we stumbled over following presentation from the IDUG Tech Archives: "Hint, Don't 'Trick', Your Troublesome Access Paths" and bingo on slide 44. There we had the recipe for addressing the challenge at hand. There is a saying within the IDUG Community that an IDUG Tech Conference can pay for itself, if you would pick up somewhere between 5-10 solutions to issues you have in your own shop, and here we got it all free thanks to these archives being made available to us.

Make sure that you are signed in as member at www.idug.org, in order to enable being able to search the DB2 Archives.
1 Comment

Hybris

July 4, 2015 04:08 AM by naveen krishna

Thanks grate information.<a href='http://www.activmaxis.com/hybris-online-training'>Hybris Training</a> I’ve been surfing online more than 3 hours today, yet I never found any interesting article like yours. It is pretty worth enough for me.

Recent Stories
The Value of the IDUG Tech Library

What Do I Do Next Now That Migration to z/OS v9 Has Been In For A Few Months.

DB2 Security - A Common Language for a Common Goal