DBUTLTY Configuration › Always Specify SORT= in DBUTLTY LOAD and RETIX Functions

Always Specify SORT= in DBUTLTY LOAD and RETIX Functions

Many DBUTLTY functions, such as RETIX at the database level, require the SORT option to be specified. However, there are many older area level LOAD or RETIX jobs that are still running at user sites that do not have the SORT= parameter specified.

Running the functions without the SORT option can greatly reduce the performance of the utility and in some cases can create index areas that are not as efficient as they could be.

Business Value

Using the SORT= parameter on LOAD and RETIX functions improves the performance of the job execution and provides the most efficient Index Area possible.

Additional Considerations

SORT=0 is the same as not specifying the SORT parameter. Specify a sort value that is near the amount of key values (that is, keys per table times rows per table) that are processed.

If you do not know the amount of key-values specify a reasonably high number such as 999999 for small to medium tables and 999999999 for large tables.