All DB2 for z/OS and OS/390 Utility Users
Release 710   : UK03226 available 05/05/25 (1000)
Release 810   : UK03227 available 05/05/25 (1000)

            MSGDSNU1178I in LOAD utility with
                       INCURSOR where LOB column values cause
                       total input record length to exceed  32767

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

P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software GroupTechnical Sales DB2