IT35235: -626/-103 ALTERING A TABLE WHEN COLUMN IS CHANGED TO SERIAL AND PRIMARY KEY CONSTRAINT IS ADDED SAME TIME

APAR status

• Closed as program error.

Error description

• Consider these SQL commands:
  
  drop table t10;
  create table t10 (f1 int, f2 char(10));
  insert into t10 values (1,"eins");
  insert into t10 values (2,"zwei");
  alter table t10 modify f1 serial, add constraint primary key
  (f1);
  
  The last alter statement fails with:
  
  626: Cannot obtain or set serial value.
  103: ISAM error:  illegal key descriptor (too many parts or too
  long).
  

Local fix

• A workaround is:
  
  alter table t10 add constraint primary key (f1), modify f1
  serial;
  
  ...but that is a defect and is fixed where this is fixed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 12.10.xC15 and 14.10.xC4.  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 12.10.xC15 (when available) or    *
  * 14.10.xC4.                                                   *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 12.10.xC15 and 14.10.xC4.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  INFORMIX SERVER

• Fixed component ID

  5725A3900

Applicable component levels