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

Rob

One was to help choose alternative ways to accomplish the same thing. Like whether to use nested or common table expressions, or some other method. I forget details now, but Dan Kimmel and I were having our own contest.

VE also was helpful in identifying a really bad statement I wrote - along with some of the analytical reports from a DBMON run over a customer implementation, where I saw run times for various statements.

Vern

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

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.