|
Problem IT30736
|
Status: Closed |
STORAGE PROVISIONING MIGHT SKIP STORAGE POOL ENTRIES DEPENDING ON SIZES AND VALUE STORED IN SP_THRESHOLD
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
If the value of SP_THRESHOLD is set to a size so the system is
considering sizes in kilobytes then it is possible for a dbspace
/ chunk to fall below this threshold but a significant amount
but the chunks stored in the storage pool might be rejected
because of their size.
Imagine that there are NNN chunks added to the storage pool
which are all 3000 kb in size and SP_THRESHOLD is 10000 kb and
there is chunk which is initially 16000 kb in size.
If a very large table is created in that chunk so that the free
space is very low or approaching zero, then the system ignores
all of the entries in the storage pool (i.e not even one of size
3000 will be added).
The argument is that the processing should have added NNN
storage pool chunks to the dbspace when it fell significantly
below the value of SP_THRESHOLD. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 12.10.xC14 and 14.10.xC4. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Update to Informix Server 12.10.xC14 or 14.10.xC4 (when *
* available). *
**************************************************************** |
| Comment |
Fixed in Informix Server 12.10.xC14 and 14.10.xC4. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 29.10.2019
04.03.2020
04.03.2020 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC14,
14.10.xC4
|
| Problem solved according to the fixlist(s) of the following version(s) |
