Enhancing performance of the RELOAD function

• Output caching

• Input thread processing

• Using the SORT keyword

• Using the SORT_OPTION keyword with the SORT keyword

RELOAD function output caching

Output caching with the OCACHE keyword during the RELOAD function can reduce elapsed time for the function, at the cost of increased CPU utilization.

A dataspace is used to implement the cache. The function has the same considerations as output caching for the change function.

RELOAD function thread processing

Thread processing with the INPUT_THREADS keyword during the RELOAD function can significantly speed processing.

The function has the same considerations as thread processing for the unload function.

Using SORT keyword with reload

You can use the SORT keyword to further improve performance of the reload process.

This is beneficial for user-created load files or unload files that are in largely re-randomized sequence because of database changes.

• SORT=NO (the default) specifies that the load file is not to be sorted. The sequence of the records largely corresponds to the order in which the data will appear in the output area (UOW sequence).

• SORT=AUTO enables the RELOAD function to determine whether sorting the sequential file will improve performance before execution of the RELOAD command. If it is determined that sorting the file will be beneficial, specifying AUTO causes a sort to be performed before the reload.

Using the file sort utility

For specific application processing needs, you can use the Fast Path/EP File Sort Utility to sort the unload file prior to application program execution.

This command-driven utility provides a method for invoking your installation’s sort utility to perform a customized sort of the unload input file. In addition to providing other sorting alternatives, the File Sort utility provides a method of pre-sorting a file in RAP or load sequence.

For detailed information on using the File Sort Utility, see Fast Path/EP Series Reference Manual documentation .

Using SORT_OPTION keyword with reload

The SORT_OPTION keyword provides a convenient method for supplying optional sort tuning parameters to your site’s Sort utility.

SORT_OPTION=DYNALLOC (the default) specifies that sort work space will be dynamically allocated according to your Sort utility’s installation defaults.

For more information, see the reference manual for the sort product that is used at your site.