In this post, you’ll learn about the error message -628 a segmented tablespace may not be partitioned in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-628 a segmented tablespace may not be partitioned
Reason for the Error
The CREATE TABLESPACE statement contains both the SEGSIZE and NUMPARTS specification, but they are mutually exclusive.
Solution
If the table space has to be partitioned then eliminate the SEGSIZE specification.
