RE: Visual Explain (VE)

[vhamberg@xxxxxxxxxxx]

If I can find the statements I was comparing, I'll send them to you - my desktop died a week ago, and I'm not even sure I saved them - will see when I recover what I can.

I think the comparison involved using table expressions vs JOINs

Vern
-------------- Original message -------------- 
From: rob@xxxxxxxxx 

> I can accept that, but, how did VE help you tune it? I'd love a real 
> world example. 
>
> Rob Berendt 
> -- 
> Group Dekko Services, LLC 
> Dept 01.073 
> Dock 108 
> 6928N 400E 
> Kendallville, IN 46755 
> http://www.dekko.com 
>
>
>
>
>
>
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 04/21/2008 11:25 AM 
> Please respond to 
> Midrange Systems Technical Discussion 
>
>
> To 
>
> cc 
>
> Subject 
> RE: Visual Explain (VE) 
>
>
>
>
>
>
>
> Rob, 
>
> I don't know that I would call it a problem, but, Visual Explain helps 
> me with SQL performance issues. Any SQL statement that I think will 
> make it to production and run on a regular basis gets examined by 
> explain and tuned the best I can before making the move. 
>
> Rick 
>
> -----Original Message----- 
> From: midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx 
> Sent: Monday, April 21, 2008 9:41 AM 
> To: Midrange Systems Technical Discussion 
> Subject: Visual Explain (VE) 
>
> Vern, 
>
> I went to many of the same sessions as you at COMMON. What problem has 
> VE helped you solve? 
>
> Rob Berendt 
> -- 
> Group Dekko Services, LLC 
> Dept 01.073 
> Dock 108 
> 6928N 400E 
> Kendallville, IN 46755 
> http://www.dekko.com 
>
>
>
>
>
> vhamberg@xxxxxxxxxxx 
> Sent by: midrange-l-bounces@xxxxxxxxxxxx 
> 04/17/2008 07:13 PM 
> Please respond to 
> Midrange Systems Technical Discussion 
>
>
> To 
> Midrange Systems Technical Discussion 
> cc 
>
> Subject 
> RE: URGENT !! Situation critique pour mimoire secondaire. 
>
>
>
>
>
>
> Hi Evan 
>
> I'm with you all the way - navigator is not for me, if I want to get 
> some 
> work done! Except for the stuff you have to do there - and I've been 
> playing with independent ASPs lately - Navigator does really well. And 
> visual Explain - of course - once it gets started! 
>
> Vern 
>
> -------------- Original message -------------- 
> From: "Evan Harris" 
>
> > Hi Vern 
> >
> > That's true - but I bet I could do the F11 and work out the 
> percentages 
> > quicker than navigator would load ! 
> >
> > I did qualify the recommendation as quick and dirty :) 
> >
> > I think Navigator has got a lot better, although I still can't bring 
> myself 
> > to use it regularly. Every time I revisit it I am reminded of how slow 
>
> it is 
> > and how badly it works. 
> >
> > I do however often use it for showing Windows guys stuff on the i. 
> System 
> > Values are a good example. WRKSYSVAL is a fine interface if you are 
> used 
> to 
> > the green screen thing, but the System Values dialogues in navigator 
> work 
> > really well particularly for sysadmins who cut their teeth on windows. 
>
> Same 
> > goes for Ethernet routing and interfaces and as you point out, disk 
> units. 
> > Regards 
> > Evan Harris 
> >
> > -----Original Message----- 
> > From: midrange-l-bounces@xxxxxxxxxxxx 
> > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> vhamberg@xxxxxxxxxxx 
> > Sent: Friday, 18 April 2008 9:10 a.m. 
> > To: Midrange Systems Technical Discussion 
> > Subject: RE: URGENT !! Situation critique pour mimoire secondaire. 
> >
> > Hi Evan 
> >
> > I didn't mention WRKDSKSTS, because you have to work out the real 
> percent 
> > used - unless everything is nicely balanced. And you have to F11 to 
> see 
> > which disk pools the units are in. The Navigator disk units interface 
> is 
>
> > nice, because it summarizes each disk pool. You don't get quite 
> anything 
>
> > like that on the green screen. 
> >
> > But then WRKDSKSTS *PRINT combines both screens. 
> >
> > Did I say I actually liked something in Navigator? Don't tell anyone, 
> > please!!! 
> >
> > Vern 
> >
> > -------------- Original message -------------- 
> > From: "Evan Harris" 
> >
> > > WRKDSKSTS is a quick and dirty way of seeing how much space is 
> available 
> > in 
> > > each AS and IASP. If you have BRMS you can use WRKASPBRM as well 
> (though 
> > > it's slower) 
> > >
> > > Regards 
> > > Evan Harris 
> > >
> > > -----Original Message----- 
> > > From: midrange-l-bounces@xxxxxxxxxxxx 
> > > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> vhamberg@xxxxxxxxxxx 
> > > Sent: Friday, 18 April 2008 6:03 a.m. 
> > > To: Midrange Systems Technical Discussion 
> > > Subject: RE: URGENT !! Situation critique pour mimoire secondaire. 
> > >
> > > David 
> > >
> > > WRKSYSSTS should have how much room is left on the system ASP - you 
> might 
> > > have to go to disk units in iSeries Navigator (does that have a new 
> name 
> > > yet!) which needs a DST user/password - and then you can see free 
> space on 
> > > user ASPs and independent ASPs, I think. Have been playing there a 
> bit 
>
> > > lately. 
> > >
> > > As to how big the contents of the save file is - DSPSAVF will give 
> you 
>
> > sizes 
> > > of each object in there - can't get to sa system - there might be 
> summary 
> > > information - there is at least an object count. Get out your 
> calculator 
> > or 
> > > copy/paste into Excel. 
> > >
> > > HTH 
> > > Vern 
> > > 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. 
> > -- 
> > 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. 
> -- 
> 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. 
>
>
>
> Privileged and Confidential. This e-mail, and any attachments there to, 
> is intended only for use by the addressee(s) named herein and may contain 
> privileged or confidential information. If you have received this e-mail 
> in error, please notify me immediately by a return e-mail and delete this 
> e-mail. You are hereby notified that any dissemination, distribution or 
> copying of this e-mail and/or any attachments thereto, is strictly 
> prohibited. 
> -- 
> 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.