Parallelism and loading
The load utility takes advantage of a hardware configuration in
which multiple processors or multiple storage devices are used, such as in
a symmetric multiprocessor (SMP) environment.
Index creation during load operations
Indexes are built during the build phase of a load operation.
There are four indexing modes that can be specified in the LOAD command:
Compression dictionary creation during load operations LOAD INSERT and LOAD REPLACE operations
that meet certain criteria trigger automatic dictionary creation (ADC).
Once enough data has been processed, ADC occurs if the load is performed
on a table that has the COMPRESS attribute enabled and a compression
dictionary is not present.
Options for improving load performance
There are various command parameters that you can use to
optimize load performance. There are also a number of file type modifiers
unique to load which can, in some cases, significantly improve that
utility's performance.