DB2 SQL-Error: -4701
SQLState: 54054
Short Description: 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
When ALTER TABLE or CREATE INDEX is used to change or create limit keys, the length of the partitioning limit key exceeds the allowed maximum. The combination of the number of table space partitions and the corresponding limit key size are subject to the following limit: A * (106 + B) < 65394 Where A = Number of partitions, and B = Limit key size (in bytes) The intended operation would exceed this limit. When an ALTER TABLE statement is used to add partitions, the maximum number of partitions already exist. For non-LARGE table spaces, the limit is 8, 16, 32, or 64, depending on the initial definition. For LARGE table spaces, see DB2 SQL Reference for more information on the limits. System action: The statement cannot be executed. Programmer response: Decrease the size of limit key or the number of table space partitions to satisfy the constraint.