RE: Visual Explain (VE) -- MIDRANGE-L

Rob,

Like Vern, I'm not sure if I have anything saved either. I doubt it.
For me, it's kind of like trial and error. I will put together a
statement the way I think it will work best then have VE explain it.
This does two things for me. First it gives me insight into how the
optimizer is working out the query. Not much use other than just for
education. Occasionally I'll see something that looks odd and try to
'fix' it. The other thing is does if suggest any index paths that might
help. I'm sure you have seen the posts about that aspect. I'll just
keep tweaking the statement and rerunning VE until I find the 'optimum'
solution.

One caveat, for me at least, is that we have different systems for
development and production. As of now, we haven't been able to convince
our operations staff to let us run VE against the production database.
They are concerned about the database monitoring job consuming too much
in the way or resources and slowing down the system. The point is that
even with my tuning I can put the statement on our production box and
get different results due to the size difference between the two
databases. It's not Vet's fault though. It's only as good as the
information it has to work with.

Does this help?

Rick

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Monday, April 21, 2008 10:44 AM
To: Midrange Systems Technical Discussion
Subject: RE: Visual Explain (VE)

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

<Rick.Chevalier@xxxxxxxxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/21/2008 11:25 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

To
<midrange-l@xxxxxxxxxxxx>
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 <midrange-l@xxxxxxxxxxxx>

To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
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" <spanner@xxxxxxxxxx>

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

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.