Start of change

-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

End of change