Loading LOB data natively

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 the 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, 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.