| |
- Causa
- Índice index-name não pode ser criado ou partilhado porque o número de partes especificadas não é igual ao número de partições.
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.
- Ação do sistema
- The statement cannot be executed.
The specified cluster index was not created.
- Resposta ao Desenvolvedor
- 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.
SQLSTATE: 53036
© Copyright IBM Corp.
|
| |
