DSNU297I csect-name COMPOSITE RECORD SIZE TOO LARGE FOR table-name

Explanation

The size of the record that would be unloaded for REORG DISCARD or REORG UNLOAD EXTERNAL is greater than the largest allowed data set logical record length (32760 bytes).

System action

The utility will terminate with a return code of 8.

User response

If you are attempting to discard records during REORG, you will have to use SQL to DELETE the records prior to the REORG. If you are attempting to unload records in an external format, you must use an application instead. If you are using the SORTDATA option with REORG UNLOAD EXTERNAL or REORG DISCARD, try removing the SORTDATA keyword.

Problem determination

This problem will most likely occur only on a table with BLOB, CLOB, or DBCLOB columns.

Severity

8 (error)