Re: Visual Explain - Gasp!

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

Thanks Birgitta...

On 12/8/06, Hauser, Birgitta <Birgitta.Hauser@xxxxxxxxxxx> wrote:
> Hi,
>
> here are the links fort he redbooks Elvis suggested:
> SQL Performance Diagnosis on IBM DB2 Universal Database for iSeries
> http://www.redbooks.ibm.com/abstracts/sg246654.html?Open
>
> Modernizing IBM eServer iSeries Application Data Access - A Roadmap
> Cornerstone
> http://www.redbooks.ibm.com/abstracts/sg246393.html?Open
>
> Preparing for and Tuning the SQL Query Engine on DB2 for i5/OS
> http://www.redbooks.ibm.com/abstracts/sg246598.html?Open
>
> Database performance and query optimization
>
> http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzajq/rzajq.pdf
>
> and there is also an other redbook that may help:
> DB2 Universal Database for iSeries Administration: The Graphical Way on
> V5R3
> http://www.redbooks.ibm.com/abstracts/sg246092.html?Open
>
> there are also some labs:
> Mastering SQL Performance with Visual Explain - V5R3 Update
>
> http://www-03.ibm.com/servers/enable/site/education/abstracts/2dc6_abs.html
>
> Analyzing DB2 for i5/OS Performance with the V5R4 SQL Plan Cache & Visual
> Explain
>
> http://www-03.ibm.com/servers/enable/site/education/abstracts/e526_abs.html
>
>
> Birgitta
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Elvis Budimlic
> Sent: Thursday, December 07, 2006 20:55
> To: 'Midrange Systems Technical Discussion'
> Subject: RE: Visual Explain - Gasp!
>
> <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.
> --
> 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.