Start of change

-4701   THE NUMBER OF PARTITIONS, OR THE COMBINATION OF THE NUMBER OF TABLE SPACE PARTITIONS AND THE CORRESPONDING LENGTH OF THE PARTITIONING LIMIT KEY EXCEEDS THE SYSTEM LIMIT; OR THE COMBINATION OF THE NUMBER OF TABLE SPACE PARTITIONS EXCEEDS THE MAXPARTITIONS FOR PARTITION BY GROWTH TABLE SPACE.

Explanation

The intended operation would exceed permitted limits.

  • If an ALTER TABLE or CREATE INDEX statement was used to change or create limit keys, the length of the partitioning limit key exceeds the allowed maximum.
  • If an ALTER TABLE statement was used to add partitions, the maximum number of partitions already exist.
  • If an ALTER TABLE statement was used to add partitions to the table space, the total number of table space partitions exceeded the number of partitions that are specified on the MAXPARTITIONS clause for partition-by-growth table spaces.

System action

The statement cannot be processed.

Programmer response

Correct the problem and reissue the statement.

Adding or changing limit keys

Decrease the size of limit key or the number of table space partitions to satisfy the constraint.

Adding partitions

For non-large table spaces, the limit is 8, 16, 32, or 64, depending on the initial definition. For large table spaces, see the information about limits in DB2® for z/OS®.

Adding partitions to a partition-by-growth table space

Increase the number of table space partitions by increasing the value of MAXPARTITIONS to satisfy the constraint.

SQLSTATE

54054

End of change