During loading, the space that a table occupies on a storage device is usually used to about 85% only to allow for subsequent INSERT and UPDATE operations.
If the table will be modified only slightly or not at all, it is convenient to use the storage device to a higher degree. On the other hand, a usage of less than 85% may be preferable if a considerable dynamic expansion of the table is expected.
The USAGE option predefines the desired storage usage. This is specified by a percentage number between 50 and 100 (inclusive) referring to the following load run.
Example:
FASTLOAD WITH 100% USAGE
TABLE PUBLIC.germ_eng
german 01-20
english_1 21-40
english_2 41-60
english_3 61-80
INFILE germeng.data
The USAGE option can only be specified within FASTLOAD statements. Note that it does not guarantee that the specified level of storage usage is actually reached. The current storage usage can be checked for the corresponding table by using CONTROL.