Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see LOADPLUS for DB2 13.1.

LOBAVGPCT

The LOBAVGPCT option provides LOADPLUS with an estimate of the size of your LOB data.

LOBAVGPCT.png

LOADPLUS uses this information to balance the number of tasks needed to load the base table, load the LOB table space, and build the indexes. LOADPLUS also uses this information when allocating LOB copy data sets.

Specify a percentage of the maximum size defined for the LOB that you are loading. Valid values are 1 through 100.

Alternatively, you can specify the AVGSIZE option on the field specification for the particular field that you are loading. The AVGSIZE field specification overrides the LOBAVGPCT option. For more information, see AVGSIZE.

Specifying the default

You can specify the default for the LOBAVGPCT command option in your installation options module by using the LOBAVGPCT installation option. LOADPLUS was shipped with a default value of 50 for this option. The command option overrides the default that is in the installation options module.

Related topic

Basic-LOADPLUS-processing-options

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*