Oninit cdi / Archive
Talk to an expert →

Maximum Nr. of extents ?

Posted in 2000

Topics: Storage & Space Management

patricia_br@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hi guys, Anyway we can find out the maximum number of extents that a specific table can reach ? Let me know, Pati Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to patricia_br@my-deja.com
Neil Truby — — source: Informix-list mailing list archive (1991-1998)

There is an impenetrable formula in the documentation somwhere. It usually works out at about 240. <patricia_br@my-deja.com> wrote in message news:8uc7rf$2ck$1@nnrp1.deja.com... > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > > Sent via Deja.com http://www.deja.com/ > Before you buy.

↪ replying to patricia_br@my-deja.com
Norman Erickson Lugtu — — source: Informix-list mailing list archive (1991-1998)

On Sun, the maximum number of extents is 233 on a non-fragmented table. You will get error -271 if the server attempts to get a new extent with the said max extent. In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to patricia_br@my-deja.com
neurologic — — source: Informix-list mailing list archive (1991-1998)

There is no solid number for the maximum number of extents that a table can hold. One of my databases had a table run out at 217, a buddy of mine had tables run out at 189 and 180. Do not rely on any formulas or magic numbers for this issue, they are all wrong. Duff In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to patricia_br@my-deja.com
patricia_br@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Thank you guys, I got a gift from a previous DBA: I have a table with 385 extents and over 40 million records. I better do something about it fast. Are you guys hiring ? :-) Patricia In article <8uc7rf$2ck$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Hi guys, > > Anyway we can find out the maximum number of extents that a specific > table can reach ? > > Let me know, > Pati > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

↪ replying to patricia_br@my-deja.com
Norman Erickson Lugtu — — source: Informix-list mailing list archive (1991-1998)

It is possible to have that number of extents if the table is fragmented. Remember that the extent limit of around 200, is per fragment. In article <8ucl1f$f0h$1@nnrp1.deja.com>, patricia_br@my-deja.com wrote: > Thank you guys, > > I got a gift from a previous DBA: I have a table with 385 extents and > over 40 million records. I better do something about it fast. Are you > guys hiring ? :-) > > Patricia > > In article <8uc7rf$2ck$1@nnrp1.deja.com>, > patricia_br@my-deja.com wrote: > > Hi guys, > > > > Anyway we can find out the maximum number of extents that a specific > > table can reach ? > > > > Let me know, > > Pati > > > > Sent via Deja.com http://www.deja.com/ > > Before you buy. > > > > Sent via Deja.com http://www.deja.com/ > Before you buy. > Sent via Deja.com http://www.deja.com/ Before you buy.

Related threads