IT32235: WHILE ALTERING AN EXCLUSIVELY LOCKED FILLED COMPRESSED RAW TABLEINTO STANDARD MODE RETURNS SQL 242/ISAM 106 ERROR

APAR status

• Closed as program error.

Error description

• Raw table is created with compression enabled and then after
  setting up exclusive lock it is being filled and then when alter
  is performed on the same table it is throwing error
  
     242: Could not open database table (informix.comptest).
     106: ISAM error:  non-exclusive access.
  

Local fix

Problem summary

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

Problem conclusion

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

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