Re: Visual Explain - Gasp!

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Thanks for the info Elvis...

On 12/7/06, Elvis Budimlic <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> <VENDOR ON>
> Centerfield offers pair of tools that sit on top of IBM's database
> monitor,
> insure/INDEX and insure/ANALYSIS.  Pretty user friendly and to the point.
> http://www.centerfieldtechnology.com
> <VENDOR OFF>
>
> As for IBM's toolset, there is a Query Optimization class IBM offers that
> would help you get going with Visual Explain and iNav's SQL Performance
> Monitors (aka database monitor).  I believe they have some labs online as
> well.
> You really have to have an idea how query optimizer works before you can
> effectively use these tools though, and that's where the class helps.  I
> took it and think it's good starting point.
> Following the class, there are redbooks and whitebooks that can help:
>
> - SQL Performance Diagnosis
> - DB2 Universal Database for iSeries Database Performance and Query
> Optimization
> - Preparing for and Tuning the SQL Query Engine on DB2 Universal Database
> for iSeries
> - Modernizing iSeries Application Data Access - a Roadmap Cornerstone
>
> HTH
> Elvis
>
> -----Original Message-----
> Subject: Visual Explain - Gasp!
>
> Geez...I thought I would check out Visual Explain since one of the
> developers wrote this code that is so much sweeter using SQL than with a
> jillion logicals, but it runs pretty darn slow. I don't know anything
> about
> the SQL performance monitors, but I figured what the heck...I'll figure it
> out.
>
> That's some complex stuff. Looks like there's more information than one
> could ever need. Is there a short cut to this stuff, or does one need to
> become a binary tree hugger to get use out of it?
>
>
> --
> 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.