DB2 SQL-Error: -661
SQLState: 53036
Short Description: CANNOT BE CREATED ON PARTITIONED TABLE SPACE BECAUSE THE NUMBER OF PART SPECIFICATIONS IS NOT EQUAL TO THE NUMBER OF PARTITIONS OF THE TABLE SPACE
The CREATE INDEX statement for the cluster index on a partitioned table (that is, a table residing in a partitioned table space) does not contain the same number of PART specifications as there are partitions in the table space. The definition for the cluster index for a partitioned table must contain exactly as many PART specifications as there are partitions in the table space in which that table resides. Also, the part numbers must be valid and unique. System action: The statement cannot be executed. The specified cluster index was not created. Programmer response: Examine the definition of the partitioned table space to determine how many partitions have been specified, and then correct the syntax of the CREATE INDEX statement to provide the proper number of PART specifications. Refer to Chapter 5 of DB2 SQL Reference for information about the definitions for cluster indexes on partitioned tables.