-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