DSNU1232I csect-name - COMPRESSED ROW IS IGNORED BECAUSE THE DICTIONARY IS NOT AVAILABLE FOR TABLE table-name
Explanation
The UNLOAD utility encountered a compressed row when unloading the data from an image copy data set, but the dictionary for decompression has not been loaded for the table space.
- csect-name
- The name of the control section that issued the message.
- table-name
- The name of the table.
This message is issued when:
- A copy of pieces (not the first piece) of a compressed table space is specified in the FROMCOPY or FROMCOPYDDN option of the UNLOAD utility.
- The image copy data set in the FROMCOPY or FROMCOPYDDN option of the UNLOAD utility was built either by the COPY utility with the SYSTEMPAGES NO option or by the DSN1COPY utility, and the original compressed table space was filled by INSERT statements and never reorganized.
System action
The record in error is not unloaded to the output data set. The UNLOAD utility continues to unload records until the total number of records in error reaches the value specified by the MAXERR option. (The default value of this option is 1.) If the total number of records reaches the MAXERR value, the UNLOAD utility issues message DSNU1219I and terminates with return code 8.
User response
To unload compressed rows from the copy of pieces, use the FROMCOPYDDN option to specify a DD name under which the first copy of pieces that contains the compression dictionary is concatenated.
If the problem persists, it is likely that the image copy data set was built in such a way that the data in the image copy data set cannot be unloaded. (Either the COPY utility was used with the SYSTEMPAGES NO option or the DSN1COPY utility was used, and the original compressed table space was filled by INSERT statements and never reorganized.)
This copy is not suitable for use with the UNLOAD utility. Create a new copy with the SYSTEMPAGES YES option and unload data from the new copy.
Severity
4 (warning)