-4701 TABLE SPACE PARTITIONS EXCEED SYSTEM LIMIT (system-limit) REASON reason-code
Explanation
- system-limit
- The system limit which was exceeded. The value can be a size or a number of partitions.
- reason-code
- Identifies the reason the that statement exceeded the system-limit value:
- 1
- An ALTER TABLE statement attempted to add partitions to a partition-by-growth (PBG) table space, but the resulting total number of partitions would exceed the specified MAXPARTITIONS value for the table space.
- 2
- An ALTER TABLE statement attempted to add partitions to a partition-by-range (PBR) or partitioned (non-UTS) table space, but the resulting total number of partitions would exceed the maximum number of supported partitions for a table space of that type.
- 3
- An ALTER TABLE statement attempted to add partitions to an XML table space, but the resulting total number of partitions would exceed the maximum number that is supported.
- 4
- An ALTER TABLE or CREATE INDEX statement attempted to create or change partition limit keys, but the internal storage for the limit keys in the object descriptor (OBD) would exceed the maximum supported size.
System action
The statement cannot be processed.
Programmer response
Correct the problem and reissue the statement. The corrective action to take depends on reason-code value:
- Increase the number of maximum table space partitions by increasing the value of the MAXPARITIONS to satisfy the constraint.
- Increase the number of maximum table space partitions by changing the table space page size and DSSIZE. For more information, see Limits in Db2 for z/OS.
- Increase the number of maximum XML table space partitions by changing the XML table space page size and DSSIZE. For more information, see Limits in Db2 for z/OS.
- The attempted partition design is not supported by the internal storage for the limit keys in the object descriptor (OBD). Try adjusting the design to uses a smaller limit keys, fewer partitions, or both.
SQLSTATE
54054