DSNU635I COLGROUP STARTING WITH first-column-name IS TOO LONG
Explanation
Complete statistics cannot be collected, because of one the following situations:
- For a single-column COLGROUP, the length of data exceeds 2000 bytes.
- For a single-column COLGROUP, the HISTOGRAM keyword is specified and the defined maximum length of the COLGROUP exceeds 2000 bytes.
- For a multi-column COLGROUP, the defined maximum length of the COLGROUP exceeds 2000 bytes.
The 2000-byte limits are based on the maximum length of COLVALUE column of the SYSIBM.SYSCOLDIST catalog table.
System action
For a single-column COLGROUP, the job step continues with limited statistics collection for the COLGROUP. If the HISTOGRAM keyword is specified, histogram statistics are not collected. The message is issued with return code 4 (warning).
For multi-column COLGROUP, no statistics are collected, utility processing terminates, and this message is issued with return code 8 (error).
User response
If the limited statistics collection is acceptable for the single-column COLGROUP, no action is required. Otherwise, alter the COLGROUP specification such that the maximum length of the COLGROUP does not exceed 2000 bytes.
Severity
4 (warning) or 8 (error)