Workfile Space Allocation

Load Utility Generates Separate Workfiles

The load utility generates four separate workfiles:

The workfile produced by Step 2 (under "The Database Load Process", earlier in this section)
The sorted workfile produced by Step 3
The prefix-resolved workfile produced by Step 4
The hierarchically sorted workfile produced by Step 5

General Considerations for Workfiles

Here are some general considerations for workfiles:

The workfiles can be allocated to either disk or tape.
Each workfile is a sequential fixed-block data set with a logical record size of 288 and a block size of 5760.
If you are using DASD space, you can use the following formula to calculate the number of bytes required for the first workfile produced by Step 2:
```
((# of logical children) + (# of logical parents)) X 288
```
Be sure to include all potential logical parents as well as all existing logical children. (Refer to "Workfile Usage for HISAM Logical Parents," below.) If you do not know the numbers for logical children and logical parents, you can use the preload CALC processing (Step 1) to get a count of all record occurrences that will appear in the logical workfile.
Remember that there will be a separate workfile generated for each DL/I database that you load. (See "Multi-Database Logical Relationships," above).
Space requirements for the second (sorted workfile) are equal to the sum of the space requirements for all the workfiles resulting from the load.
To calculate the space requirements for the third (prefix-resolved) workfile, use the formula shown above for the first workfile, but specify 0 (zero) for # of logical parents. This workfile contains only the logical child records, but with adjusted prefixes (concatenated keys).
Space requirements for the fourth (hierarchically sorted) workfile are the same as for the third workfile.