Re: Explain or Show Optimized Indexes

Edmund

I looked at the link you provided - VE is not available in Data Studio for IBM i -- I remember looking at Data Studio a while back, saw a webcast on it - it just doesn't know what to do with DB2 for i. The stored procedure support does not handle external SPs, so far as I remember.

All in all, the Navigator tooling is the way to go for now, so far as I can see. I'd love to have Data Studio working. I did comment to the presenters that IBM i support was very weak. I think there is a bit of support missing for IBM z, too.

I'm open to being wrong on this - I certainly hope so!
Vern

On 3/17/2011 5:36 PM, Edmund Reinhardt wrote:

Hi guys,
The visual explain technology is in the Data Studio product which is also
included in the RDp product. There is an improved version in the Optim
Development Studio, but the base free support will still meet the goals of
finding out how expensive your SQL statement is and why.
Simply go to the Database Development perspective and you will see the
Execution Plan view
See the document below for some instructions
http://publib.boulder.ibm.com/infocenter/idm/v2r2/index.jsp?topic=/com.ibm.datatools.visualexplain.data.doc/topics/tvetop.html

I haven't tried this yet myself, so I hope this works for you.
More of Data Studio was included in RDp 8.0 because the AIX COBOL tooling
is taking advantage of it.
The Optim Development Studio has excellent tooling for tuning SQL queries
but it will cost an additional license. Right now, the Optim tooling is
based on an earlier version of Eclipse so it does not shell share with RDp.
We hope to get better integration with Optim once this hurdle is solved.

Regards



Edmund (E.H.) Reinhardt
Rational Developer for Power
Advisory Development Analyst
COBOL IDE on AIX, System i Application Development, DDS, WebFacing



Phone: 1-905-413-3125 | Tie-Line: 313-3125 | Fax: IBM
1-905-413-4850
E-mail: edmund.reinhardt@xxxxxxxxxx 8200 Warden Ave
AIX COBOL demo: tinyurl.com/62ek2n5 Markham, ON L6G 1C7
Canada





|------------>
| From: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Vern Hamberg<vhamberg@xxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| To: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Rational Developer for IBM i / Websphere Development Studio Client for System i& iSeries<wdsci-l@xxxxxxxxxxxx> |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Date: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|03/17/2011 05:44 PM |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Subject: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|Re: [WDSCI-L] Explain or Show Optimized Indexes |
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|------------>
| Sent by: |
|------------>
>--------------------------------------------------------------------------------------------------------------------------------------------------|
|wdsci-l-bounces@xxxxxxxxxxxx |
>--------------------------------------------------------------------------------------------------------------------------------------------------|





Ah - THAT I do agree with. The Visual Explain and SQL statement
processor of Navigator is really fine, and there's nothing for Eclipse
that can come close.

Vern

On 3/17/2011 3:49 PM, David Gibbs wrote:

Vern Hamberg wrote:

I hope your tongue was firmly planted in your cheek!

Absolutely not.

I rely on Visual Explain to help me get the best performance out of
the SQL we have in our products. I'm glad we DON'T have DBAs - it
lets me get to the bottom of things faster.

That's fine ... you use the right tool for the job.

IMO: Putting a database performance analysis tool in a IDE is putting it

in the wrong place.

david

--
This is the Rational Developer for IBM i / Websphere Development Studio
Client for System i& iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/wdsci-l.