|
What happens when you change access path maintenance from *DLY to *IMMED? Does the entire access path then get rebuilt? Thanks, Mark Good point - for me this is primarily a possible performance improver and, as you say, is not always applicable. At 09:10 AM 4/24/2003 -0500, you wrote: > > From: Vern Hamberg > > > > Rebuilding? Depends on what you mean. An index is maintained every time a > > record is added/removed from the physical file. The tree may need > > balancing > > from time to time. A complete rebuild is probably rare on the 400. > >I'm tired from chasing COBOL issues all night, so I'm picking nits here, but >with MAINT(*DLY/*REBLD), the access paths are not automatically maintained, >and there is a rebuild process. Then again, neither of these options can be >used for unique key access paths. > >Joe
As an Amazon Associate we earn from qualifying purchases.
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.