RE: Access Path Maintenance Was RE: access path

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

With CPW to spare in the newest iSeries boxes, does access path maintenance
really cost so much to system performance?  I think most of what I once knew
about performance on the as400 has been made obsolete (or insignificant) by
fast CPU cycles and cheap memory.  

Eric DeLong
Sally Beauty Company
MIS-Project Manager (BSG)
940-898-7863 or ext. 1863



-----Original Message-----
From: jt@xxxxxx [mailto:jt@xxxxxx]
Sent: Thursday, April 24, 2003 12:12 PM
To: Midrange Systems Technical Discussion
Subject: RE: Access Path Maintenance Was RE: access path


(Oooops, I "lied"...  THIS is last post fer a bit...  Hope-ta mebbe get
back, especially on discussion of S/38 and Gigabyte RAM, mebbe later?...;-)
I looked into this too long ago to recall fer certain, but I suspect that
only the portion that is pending-to-be-applied is built.

You can watch long-running rebuilds by looking at EDTRBDAP (Edit Rebuild
Access Path).  Iirc, it shows percentage complete?

Btw, in addition to HUGE performance impacts, *delay also saves disk.  LF
with a lotta keys take up some fair bit-a space, especially in humongous ERP
packages.  (Why keep a LF around for a once-a-week/month/year usage pattern,
anyway?)


| -----Original Message-----
| [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
| mgarton@xxxxxxxxxxxxxxx

| What happens when you change access path maintenance from *DLY to *IMMED?
| Does the entire access path then get rebuilt?


_______________________________________________
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.cgi/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.