Lukas Beeler wrote:
On Tue, Mar 11, 2008 at 12:46 PM, Mike Cunningham <mcunning@xxxxxxx> wrote:
Isn't there also some implications for backups? If the PF is keyed you can't backup the data without also backing up the index since it is all in one object. If the PF is un-keyed you can choose to backup the key if you think that is in your own best interest, by backup up the logical files.

Isn't this about SAVLIB ACCPTH(*NO) and QSAVACCPTH? I think this
controls if you save access paths (which i believe is the IBMism for
indexes).

Yes, it is. But the system *always* saves PF access paths, no matter
what ACCPTH and QSAVACCPTH are. So putting the access path in a LF
instead of the PF gives you the option to control whether or not it's saved.

--Dave

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 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].