Re: Do any of you have a policy on rebuilding indexes?

In many transaction-oriented applications like order entry, most of the
disk I/O, especially writes and updates, is performed on recently-added
records often in very large files.

Does scatter-loading make a difference? Have the mechanics of IBM's
scatter-loading been published?

On Thu, Mar 30, 2023 at 8:44 AM <stefan@xxxxxxxxxx> wrote:

Disk fragmentation does not exist in IBM i due to single level storage,

so that's not an issue.

I disagree, single level storage will try to spread stuff evenly over the
available volume, however that does not prohibit fragmentation.
Look at help text for cmd STRDSKRGZ.

Best regards

Stefan

--
No trees were killed in the sending of this message, but a large number of
electrons were terribly upset.

Stefan Tageson
+46 732 369934
stefan@xxxxxxxxxx


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.