INFORMIX SERVER / 5725A3900 / B70 - IDS 11.70

When I have a table with at least 2 indexes where one index is
disabled
and I attempt to add crcols by alter table, the statement will
fail with -597.

CREATE TABLE tab1 (
  c1 LVARCHAR(1),
  c2 CHAR(1)
);

CREATE INDEX idx_c1 ON tab1 (c1);
CREATE INDEX idx_c2 ON tab1 (c2) DISABLED;

-- with index in state  DISABLED => ERROR
ALTER TABLE tab1 ADD crcols;

The error is generated in the update statistics code.

****************************************************************
* USERS AFFECTED:                                              *
* All users                                                    *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Update to IBM Informix Server 11.70.xC9                      *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

14.12.2016
09.06.2017
09.06.2017

11.70.xC9