Oninit
Talk to an expert →

Informix Error -26482: Cannot alter a replicated table in a grid outside of the same grid context

Cause and resolution

Cannot alter a replicated table in a grid outside of the same grid context

The ALTER TABLE statement on a replicated table that was created through a grid must be executed within the same grid context and with replication enabled by setting the ER_enable argument to 1.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-26482 fires when ALTER TABLE on a grid-created replicated table isn't run within the same grid context with replication enabled — per the official guidance.

  1. The ALTER TABLE wasn't run within the same grid context, per the official guidance — the first named case.
  2. ER_enable wasn't set to 1, per the official guidance — the second named case.
Solutions / Resolution
  1. Run the ALTER TABLE within the same grid context, per the official guidance, with ER_enable set to 1.
Examples
N/A

No specific triggering statement is documented beyond an out-of-grid-context ALTER TABLE.

Diagnostic Checks
  1. Check whether the ALTER TABLE was issued within the same grid context, with ER_enable=1, and correct as needed.
Related Errors / Related Topics
  • -26481 — "Cannot perform this operation through a grid" A related grid restriction, on a database rename requiring the grid context's absence rather than its presence.

ALTER TABLE on a grid-replicated table wasn't run within the same grid context with replication enabled — set ER_enable=1 and run it in-grid.