IT43235: INSERT STMT ON VIEW CAN FAIL WITH AF, WHEN RUN AFTER ALTER TABLEON UNDERLYING TABLE DUE TO OLD COLUMN TYPE IN DATA DICTIONARY

APAR status

• Closed as program error.

Error description

• If we have table and have created a view using that table and we
  perform ALTER on the table to modify a column data type. In such
  situation INSERT statement on a view can cause the server to
  crash or can corrupt the memory because data dictionary for the
  view still points to old dd type.
  
  When server crashes, we can see :
  0x00000000018bc80b (oninit) afstack
  0x00000000018b9e6e (oninit) afhandler
  0x00000000018b93eb (oninit) afcrash_interface
  0x0000000001b39ed7 (oninit) ifx_memwrap_af
  0x0000000001b3a69e (oninit) ifx_memmove
  0x000000000101d7fd (oninit) compress_row
  0x000000000101d48a (oninit) rowcompress_to
  0x0000000001283d71 (oninit) wrtrecord
  0x0000000001283651 (oninit) rswrite
  0x00000000019ae878 (oninit) fmwrite
  0x0000000000760e9a (oninit) aud_sqiswrite
  0x00000000009df844 (oninit) chkrowcons
  0x0000000000965027 (oninit) addone
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of Informix Server prior to 14.10.xC11.                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Informix Server 14.10.xC11.                       *
  ****************************************************************
  

Problem conclusion

• Fixed in Informix Server 14.10.xC11.
  

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