IT34414: DURING BIG INSERTS AUTOLOCATE CAN CONTINUE TO CREATE NEW FRAGMENTS, WHEN THE ORIGNAL DBSPACES FOR THE TABLE ARE FULL

APAR status

• Closed as program error.

Error description

• Setting AUTOLOCATE will allow the instance to automatically
  create new fragments for a table, when the original fragments
  are filled up.
  However if you do a massive parallel insert and the dbspaces
  where the original fragments are created in are full, not one
  but multiple fragments are created in lots of dbspaces.
  
  In one example the insert lead from the original 5 fragments to
  113 fragments.
  

Local fix

Problem summary

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

Problem conclusion

• Fixed in Informix Server 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