HomeDB2DB2 Error Code – -653 table table name in partitioned tablespace tspace name is not available because its partitioned index has not been created

DB2 Error Code – -653 table table name in partitioned tablespace tspace name is not available because its partitioned index has not been created

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.

Share:

Leave a Reply

You May Also Like

In this post, you’ll learn about the error message -952 processing was interrupted by a cancel request from a client...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -927 the langrage interface was called when the connecting environment was...
  • DB2
  • November 21, 2022
In this post, you’ll learn about the error message -926 rollback not valid in ims/vs or cics environment in the...
  • DB2
  • November 21, 2022