-20488 SPECIFIED HASH SPACE IS TOO LARGE FOR THE IMPLICITLY CREATED TABLE SPACE. REASON reason-code. (PARTITION partition-number)
Explanation
DB2® attempted to implicitly create a table space, but the specified hash space is too large for the associated table space.
- reason-code
- A numeric value that indicates the type of table space:
- 1
- A range-partitioned universal table space.
- 2
- A partition-by-growth table space.
- partition-number
- For a range-partitioned universal table space, partition-number value indicates the partition for which the HASH SPACE value is too large. For partition-by-growth table spaces, the partition number is not relevant, and is indicated as *N.
System action
The statement cannot be processed.
User response
Take either of the following actions:
- Explicitly create a table space with a larger DSSIZE specification, and specify that table space in the CREATE TABLE statement.
- Reduce the HASH SPACE specification.
SQLSTATE
428HK
