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.

Loading LOB data natively

LOADPLUS loads LOB data natively in most cases.

Before you begin

Review Loading-LOB-data-by-invoking-DSNUTILB.

To load LOB data natively

  1. Create your load job as usual, adjusting it if necessary based on the information described in Considerations-when-loading-LOB-data.
  2. Use one of the following options for your field specification:
    • If your input file contains the LOB data, either do not include a field specification for this job, or specify a LOB data type (BLOB, CLOB, or DBCLOB) in your field specification for the LOB column.
    • If your input file references the file that contains your LOB data, specify the appropriate CHAR or VARCHAR subtype (BLOBF, CLOBF, or DBCLOBF).
  3. If you are loading from an input data set that is in spanned-record format:
    1. Ensure that the LOB (and any XML) fields follow all other fields in your field specification.
    2. Specify FORMAT SPANNED YES.For more information about this option, including restrictions, see SPANNED
  4. If you specify COPY YES, ensure that dynamic allocation is enabled for your LOB copy data sets.
  5. (optional) Adjust the value for the LOBAVGPCT option on your LOAD command or the AVGSIZE option on your field specification.For more information about these options, see LOBAVGPCT, or AVGSIZE, AVGSIZE, or AVGSIZE.
  6. Ensure that the SMF MEMLIMIT parameter meets the minimum requirements for loading your LOB data.For more information, see Overriding-the-MEMLIMIT-system-parameter.

Related topics

Considerations-when-loading-LOB-data

Loading-LOB-data

 

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