× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



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


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.