|
Problem IT34414
|
Status: Closed |
DURING BIG INSERTS AUTOLOCATE CAN CONTINUE TO CREATE NEW FRAGMENTS, WHEN THE ORIGNAL DBSPACES FOR THE TABLE ARE FULL
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem 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. |
| 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. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC5. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 14.10.xC5. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC5. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.10.2020
09.12.2020
09.12.2020 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
