Informix Error -23920: Could not create bitmap index due to outstanding in-place alter.
Cause and resolution
Could not create bitmap index due to outstanding in-place alter.
A create index using bitmap statement was specified on a table that has outstanding in-place alters. The in-place alter must complete before such an index can be created. A dummy update of the entire table will cause the in-place alter to complete.
An example of a dummy update is an update that changes all the rows in the table and specifies that a column be set to itself.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-23920 fires when CREATE INDEX ... USING BITMAP is specified on a table with an
outstanding in-place alter — per the official guidance, the in-place alter must
complete first.
- An outstanding in-place alter on the target table, per the official guidance — the direct, only cause.
Solutions / Resolution
- Force the in-place alter to complete with a dummy update of the entire table, per the official guidance — for example, an update that changes every row, setting a column to itself.
Examples
Forcing an in-place alter to complete
UPDATE orders SET order_id = order_id;
Diagnostic Checks
- Check the table for an outstanding in-place alter, and force it to complete before creating the bitmap index.
Related Errors / Related Topics
No closely related error codes are cross-referenced for -23920 in this set yet.
A bitmap index couldn't be created due to an outstanding in-place alter — force it to complete with a dummy full-table update.