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.
midrange.com
