RE: Efficient Code

>Would you agree, then, on the need for a report the likes of which
>I've described?

YES! I've never been interested enough to write it though. Part of the
problem however is that all the information may not actually be available
(as evidenced by the index issue I pointed out.) But enough is there to make
the tool useful if not perfect.

-Walden


------------
Walden H Leverich III
President & CEO
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 
-----Original Message-----
From: G Armour [mailto:garmour400r@xxxxxxxxx] 
Sent: Wednesday, February 18, 2004 2:57 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: Efficient Code

Eric, don't know if you were responding to my post or both mine and Walden's
but,
with my "would be nice to have" report needing to show the files that could
share
the same access path, the ANZDBF* commands aren't much better than running
the DSPFD
commands.  There'd still be (a lot of?) programming to do to put it
together.  All
the information is available in one form or another, it's just a matter of
piecing
it together.

Walden, I didn't understand your use of indexes vs. logicals.  Thank you for
setting
me straight.  Would you agree, then, on the need for a report the likes of
which
I've described?

GA

--- "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx> wrote:
> Have you tried the ANZDBF and ANZDBFKEY commands?
> 
> Eric DeLong
> Sally Beauty Company
> MIS-Project Manager (BSG)
> 940-898-7863 or ext. 1863
> 
> 
> 
> -----Original Message-----
> From: Walden H. Leverich III [mailto:WaldenL@xxxxxxxxxxxxxxx]
> Sent: Wednesday, February 18, 2004 12:13 PM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Efficient Code
> 
> 
> >Well, DBU has DBUDBR, or F14 from the main DBU screen.
> 
> Nope. DBU shows you logicals, not indexes. Access path sharing causes
these
> to be different. DSPDBR is the same. 
> 
> DSPFD *ACCPTH is close, but as I just showed, an access path can have more
> keys than it's owning logical file.
> 
> AFAIK, there is no display of the actual _access paths_ built over a
> physical.
> 
> -Walden 
> -----Original Message-----
> From: G Armour [mailto:garmour400r@xxxxxxxxx] 
> Sent: Wednesday, February 18, 2004 11:53 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Efficient Code
> 
> > I wonder if there is a way to see the indexes on a system.
> 
> Well, DBU has DBUDBR, or F14 from the main DBU screen.
> 
> On systems without DBU, you have to build your own using DSPDBR & DSPFD
> *ACCPTH & *SELECT.
> 
> IIRC, iSeries Navigator has something related to this.  I'm too low on
> memory to check it out at the moment.  
> 
> What is *really* needed, IMO, is a report you can run to identify the
> logicals that can be "rebuilt" to take advantage of access path sharing.  
> Plug in a physical file name, get back a listing of logicals that can be 
> optimized like this.
> 
> If someone has already created the wheel....   <g>
> 
> GA


__________________________________
Do you Yahoo!?
Yahoo! Mail SpamGuard - Read only the mail you want.
http://antispam.yahoo.com/tools
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.