RE: Efficient Code

[G Armour <garmour400r@xxxxxxxxx>]

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