CA IDMS DLI Transparency Load Utility › Step 1: Preload CALC Processing › Preload Sorting (step 1, part 2)

Preload Sorting (step 1, part 2)

Use Your Own Sort/Merge Utility

To further optimize the CALC-processed data for loading, you can sort it using your own sort/merge facility. As input to the sort/merge facility, supply the DL/I output file produced by the preload CALC processing. The output file will contain the CALC-processed data in sorted form. You can then use the sorted output file as input to the database load (Step 2).

The preload sort is not strictly required, but it should be performed to produce the most effective ordering of the CALC-processed data.

To perform the preload sort, you must use your own sort/merge facility.

What the Preload Sort Does

The preload sort performs the following operations:

1. Accessing the CALC DL/I data produced by the preload CALC processing (Step 1, Part1)
2. Sorting the data so that root segments (CALC records) are in descending database page sequence (the optimum CA IDMS/DB database load order)

To execute the preload sort processing step, use the JCL (Step 1, Part 2) in CA IDMS DLI Transparency JCL.