In this post, you’ll learn about the error message -653 table table name in partitioned tablespace tspace name is not available because its partitioned index has not been created in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-653 table table name in partitioned tablespace tspace name is not available because its partitioned index has not been created
Reason for the Error
An attempt has been made to insert or manipulate data in or create a view on a partitioned table (that is, a table residing in a partitioned table space) before the partitioned index for that table has been created.A table residing in a partitioned table space cannot be referenced in any SQL manipulative statement or a CREATE VIEW statement before the partitioned index for that table has been created.
Solution
Verify that the correct table was specified in the statement. If so, ensure that the partitioned index for the table has been created successfully before attempting to execute any SQL manipulative statements that reference that table.
