-4701 Start of changeTABLE SPACE PARTITIONS EXCEED SYSTEM LIMIT (system-limit) REASON reason-codeEnd of change

Start of change

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.
End of change

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:

  1. Increase the number of maximum table space partitions by increasing the value of the MAXPARITIONS to satisfy the constraint.
  2. 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.
  3. 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.
  4. 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