× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



You may also check the newest version of the famous Indexing Strategie White
paper (just recently updated):
https://www-304.ibm.com/partnerworld/wps/servlet/ContentHandler/stg_ast_sys_
wp_db2_i_indexing_methods_strategies

And
Database Performance and Query Optimization
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/topic/rzajq/rzajq.pd
f


Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von DeLong, Eric
Gesendet: Wednesday, 27. July 2011 17:33
An: Midrange Systems Technical Discussion
Betreff: RE: sql not using existing indexes v6r1

Thanks for the documentation, Charles. I'll flip through the redbook soon.

I was always somewhat frustrated with VE, because there was very little
guidance as to WHY a particular access plan element was implemented in some
undesirable way. Perhaps this will help me understand the tool better.

-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, July 27, 2011 8:42 AM
To: Midrange Systems Technical Discussion
Subject: Re: sql not using existing indexes v6r1

VE is a much, much, better choice than the diag messages sent in debug mode.

http://www.redbooks.ibm.com/redbooks/pdfs/sg247326.pdf
- The debug messages are no longer being enhanced (that is, no new
messages are being
added for queries that go through SQE).
- No new messages are being added for queries that go through SQE,
for this reason the
SQE optimizer uses the closest CQE message and that message may or may not
accurately reflect the access plan built by the SQE optimizer.

- Important: Starting in V5R4, IBM is treating Debug Messages as a
non-strategic feedback
mechanism to analyze database Performance. There is no enhancement in V5R4.

http://www.mcpressonline.com/database/db2/get-your-system-humming-7-great-ti
ps-for-tuning-db2-for-i.html
"After comparing just some of the differences between these two tools,
it should be abundantly clear that continued usage of the debug
messages for SQL performance analysis is ineffective and inefficient."

HTH,
Charles

On Tue, Jul 26, 2011 at 2:15 PM, DeLong, Eric <EDeLong@xxxxxxxxxxxxxxx>
wrote:
Run it in debug to see better diagnostic messages...


Visual Explain should be able to generate a map of its access plan, which
can be interesting and informative, but may not help you as much as you
might think...

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.