DSNU291I MAXIMUM COMPOSITE UNLOAD RECORD SIZE TOO LARGE FOR SORT. SORTDATA KEYWORD IS IGNORED.

Explanation

The SORTDATA keyword was specified for a REORG utility job. However, the largest possible record in the table space, prefixed by the largest key, produces a composite record that is too large to be processed by the SORT component. The SORTDATA keyword is ignored.

System action

Processing continues normally.

User response

If you must use SORTDATA for the table space, try reducing the size of either the largest record or key field by redefining the table. In some cases, changing a field from LONG VARCHAR to VARCHAR with a specified maximum length might help.

Problem determination

This problem should only occur on a table space with a 32KB page size. Analyze the requirement for maximum data length in VARCHAR and LONG VARCHAR columns to see if a shorter length can be specified. It might be necessary to remove the SORTDATA keyword from the utility statement.

Severity

0