logo  
Google
 

DB2 SQL-Error: -662

SQLState: 53037

Short Description: A PARTITIONED INDEX CANNOT BE CREATED ON A NONPARTITIONED TABLE SPACE

The CREATE INDEX statement contains PART specifications, but the specified object table is not partitioned (that is, does not reside in a partitioned table space). System action: The statement cannot be executed. The specified index was not created. Programmer response: Verify that the proper object table was specified in the statement. Refer to Chapter 5 of DB2 SQL Reference for information about the proper usage of PART specifications in CREATE INDEX statements.

 <-  BACK TO INDEX