|
Problem IT38831
|
Status: Closed |
ALTER FRAGMENT ADD OMIT FIRST/NEXT EXTENT SIZE FRAGMENT DEFINITION OF AN INDEX IN AN FRAGMENTED TABLE
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Given a fragmented table was created with
create table "informix".tab
(
id serial8 not null
)
fragment by expression
((id >= 0 ) AND (id < 200000000 ) ) in dbs1,
((id >= 200000000 ) AND (id < 400000000 ) ) in db2,
((id >= 400000000 ) AND (id < 600000000 ) ) in dbs3,
remainder in remdbs
extent size 10000 next size 5000 lock mode row;
create unique index "informix".tab_31 on "informix".tab
(id) using btree FILLFACTOR 100 extent size 4000 next size
4000 ;
the table has an explicit first extend and next extend size
definition for the index and
the data fragments.
subsequent
alter fragment on table tab
add ((id >= 600000000 ) AND (id < 800000000 ) )
in dbs4;
alter fragment on table tab
add ((id >= 800000000 ) AND (id < 1000000000 ) )
in dbs5;
alter fragment on table tab
add ((id >= 1000000000 ) AND (id < 1200000000 ) )
in dbs6;
statements add new index/data fragments but the new index
fragments do not follow the original index definition
oncheck -pt test:tab | grep "First extent"
First extent size 5000
First extent size 5000
First extent size 5000
First extent size 5000
First extent size 5000
First extent size 5000
First extent size 5000
First extent size 2000
First extent size 2000
First extent size 2000
here
First extent size 9500
First extent size 9500
First extent size 9500
First extent size 2000 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC7. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC7. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC7. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC7. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.10.2021
02.11.2021
02.11.2021 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
