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?