RE: Visual Explain - Gasp!

["Hauser, Birgitta" <Birgitta.Hauser@xxxxxxxxxxx>]

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?