|
Problem IT44815
|
Status: Closed |
CREATING AN INDEX USING UDT COLUMNS LIMITS THE SIZE OF THE INDEXTO 16,775,134 DATA PAGES PER FRAGMENT
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Creating an index using UDT columns limits the size of the index
to 16,775,134 data pages per fragment because a data page is
created no matter it is a detach index.
It means index can not grow until "Maximum number of pages per
index fragment" that is 2,147,483,647.
For example the following index was created on a LVARCHAR column
using "create unique index my_index on mytab (col_lvarchar)
using btree in idxdbs1;"
The 'oncheck -pt' of the index shows :
Index my_index fragment partition idxdbs1 in
DBspace idxdbs1
Physical Address 11:40
Creation date 10/24/2023 12:59:26
TBLspace Flags 802 Row Locking
TBLspace use 4 bit
bit-maps
Maximum row size 1254
Number of special columns 0
Number of keys 1
Number of extents 1
Current serial value 1
Current SERIAL8 value 1
Current BIGSERIAL value 1
Current REFID value 1
Pagesize (k) 16
First extent size 4
Next extent size 4
Number of pages allocated 4
Number of pages used 3
Number of data pages 1 |
| 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. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 24.10.2023
07.06.2024
07.06.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
