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)