Loading sequential dependent segments

If the order of sequential dependent segments is important, you must consider the way sequential dependents might be loaded in a DEDB.

The two alternatives are:

  • Add a root and its sequential dependents.

    All the sequential dependents of a root are physically written together, but their physical order does not reflect the original data entry sequence. This reflection is not necessarily the way the application needs to view the dependent segments if they are being used primarily as a journal of transactions.

  • Add all roots and then the sequential dependents.

    This technique restores the SDEP segments to their original entry sequence order. However, it requires a longer process, because the addition of each SDEP segment causes the root to be accessed.