Informix Error -26993: Cannot alter the table to shard collection table.
Cause and resolution
Cannot alter the table to shard collection table.
Collection table can only be altered to shard collection table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26993 fires when ALTER TABLE tries to make a non-collection table a shard
collection table — per the official guidance.
- The target table isn't a collection table, per the official guidance — the direct, only cause; only a collection table can be altered into a shard collection table.
Solutions / Resolution
- Only alter collection tables into shard collection tables, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond altering a non-collection table into a shard collection table.
Diagnostic Checks
- Check whether the target table is a collection table, before altering it into a shard collection table.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -26993 in this set yet.
A non-collection table was altered toward becoming a shard collection table, which isn't allowed — only collection tables can be altered this way.