Re: Problem creating an index using large extent s
HI Again,
Forget abut my post. It was my mistake. There was no large DBSPACETEMP
and the rootdbs was only 2 GB in size.
It works fine.
Cordialement, Regards,
Khaled Bentebal
Directeur Général - ConsultiX
Président UGIF - User Group Informix France
IIUG - Board of Directors
Tél: 33 (0) 1 39 12 18 00
Fax: 33 (0) 1 39 12 18 18
Mobile: 33 (0) 6 07 78 41 97
Email: khaled.bentebal@consult-ix.fr
Site Web: www.consult-ix.fr
Le 28/11/12 13:20, Khaled Bentebal a écrit :
> HI,
>
> Did anybody have any problem creating an index using the new extent
> size clause ?
>
> Product version: INFORMIX IDS 11.70.FC6GE on Linux
>
> Here is my SQL create index statement:
>
> *create unique index "informix".fuel_stat_jour1 on
> "informix".fuel_stat_jour
> (scenario_id,date,emet,dest,emetphysique) using btree
> in idxdbs3 extent size 4000000 next size 400000;*
>
> My dbspace idxdbs is 22 GB in size and is empty; so only the first 53
> pages are used.
>
>
> When I do an oncheck -pe while the create index is running, I get the
> following:
>
--------------------------------------------------------------------------------
----------------
> Chunk Pathname Pagesize(k) Size(p)
> Used(p) Free(p)
> 11 /hdrd/idxdbs3 2 11000000
> 2000053 8999947
>
> Description
> Offset(p) Size(p)
> -------------------------------------------------------------
> -------- --------
> RESERVED PAGES
> 0 2
> CHUNK FREELIST PAGE
> 2 1
> idxdbs3:'informix'.TBLSpace
> 3 50
> edilectre:'informix'.fuel_stat_jour1
> 53 2000000
> FREE
> 2000053 8999947
>
> Total Used: 2000053
> Total Free: 8999947
>
--------------------------------------------------------------------------------
----------------
>
> I get the following error messages after few seconds:
>
> I get the following error:
> 212: Cannot add index.> 28: No space left on device
>
>
> Any ideas are welcome.
> --
> Cordialement, Regards,
>
> Khaled Bentebal
> Directeur Général - ConsultiX
> Président UGIF - User Group Informix France
> IIUG - Board of Directors
> Tél: 33 (0) 1 39 12 18 00
> Fax: 33 (0) 1 39 12 18 18
> Mobile: 33 (0) 6 07 78 41 97
> Email:khaled.bentebal@consult-ix.fr
> Site Web:www.consult-ix.fr
>