IBM Support

Can I use the cross-loader function with LOB columns?

Technote (FAQ)


Question

Can I use the cross-loader function with LOB columns?

Answer

Yes, you can use the cross-loader function to load LOB columns.
IMPROVED LOB HANDLING FOR CROSSLOADER was provided by PQ90263.

An architectural limit in the LOAD utility precludes processing
of input records where the sum of the column lengths exceeds
32767. When this condition is detected message DSNU1178I is
issued.

For the CrossLoad function of the LOAD utility, the processing
of LOB columns is changed to use a separate buffer to bypass the
architectural limit of 32767 bytes. Now, LOAD with INCURSOR will
store only 8 bytes per LOB column within the 32767 byte buffer.
As long as the sum of the lengths of the non-LOB columns plus
the sum of 8 bytes per LOB column does not exceed 32767, the
CrossLoading of tables with LOB columns will only be limited by
memory available above the 16MB line. The explanation text in
the DSNU1178I message is changed to reflect this. If the user
receives this message, then increasing the region size will
likely result in successful execution of the LOAD utility.

Until the batch address space piece of this fix is made
available to the library search of DSNUTILB and DB2 is stopped
and started with the DB2 system piece available to the library
search of the DBM1 address space, the LOAD utility will
operate as before.

Document information

More support for: DB2 for z/OS
Utilities

Software version: 7.0, 8.0

Operating system(s): z/OS

Reference #: 1163210

Modified date: 17 December 2016


Translate this page: