KFAA31653-E
aa....aa index cannot be defined. (reason = "bb....bb") (M+J+O)
A table for which an index cannot be defined is specified.
-
You cannot define aa....aa for a multi-chunk table. <SQLSTATE: 42IA9>
-
You cannot define aa....aa for a column store table. <SQLSTATE: 42IC1>
- aa....aa: Index type
-
-
A unique: Unique index
-
A text: Text index
-
- bb....bb: Reason why an index cannot be defined
-
-
the table in the CREATE INDEX statement is a multi-chunk table:
An attempt is made to define a unique index for a multi-chunk table.
-
the table in the CREATE INDEX statement is a column store table:
The table for which you are attempting to define a text index is a column store table.
-
- S:
-
Ignores this SQL statement. Alternatively, the system invalidates this transaction.
- Action:
-
Take one of the following corrective actions:
-
If bb....bb is the table in the CREATE INDEX statement is a multi-chunk table
Revise the database design so as not to define a unique index or to remove the chunk specification from the table definition.
-
If bb....bb is the table in the CREATE INDEX statement is a column store table
You cannot define a text index for a column store table. Revise the database design (including the options to be specified for tables, and index design).
-