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



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.

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

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.