I am new to iSeries, so I apologize if these question are trivial.
I have read that data is written to physical files in arrival sequence order, even if it is a keyed PF. My question is does new data continue to be added to the end of the file in arrival sequence order even after the file has compressed been reorganized on the key or based on a keyed LF?
I have read that the idea of data ordered by a 'clustering' index/key isn't necessary on iseries because the data is spread across many disks. I believe data is read and written in pages, so this doesn't make sense to me. If 95% of the access to the PF is through one keyed logical file, it would seem the data should be organized by the key. The next row to be returned by the index should be on the same page, or next page whichever disk it may be on. Is my thinking wrong here?
I appreciate your insight, and thank you in advance!!
Scott
I have read that data is written to physical files in arrival sequence order, even if it is a keyed PF. My question is does new data continue to be added to the end of the file in arrival sequence order even after the file has compressed been reorganized on the key or based on a keyed LF?
I have read that the idea of data ordered by a 'clustering' index/key isn't necessary on iseries because the data is spread across many disks. I believe data is read and written in pages, so this doesn't make sense to me. If 95% of the access to the PF is through one keyed logical file, it would seem the data should be organized by the key. The next row to be returned by the index should be on the same page, or next page whichever disk it may be on. Is my thinking wrong here?
I appreciate your insight, and thank you in advance!!
Scott
Comment