reorg question

Posted in 2000

Topics: Storage & Space Management, Platform-Specific Issues

David Kulkarni — Tue, 8 Aug 2000 10:40:22 -0700 (PDT) — source: Informix-list mailing list archive (1991-1998)

Can anybody tell me what is the largest size of extent I can have. On Informix 510uc5, running on hp-ux 10.20. TIA __________________________________________________ Do You Yahoo!? Kick off your party with Yahoo! Invites. http://invites.yahoo.com/

↪ replying to David Kulkarni

Jonathan Leffler — Tue, 08 Aug 2000 14:37:35 -0700 — source: Informix-list mailing list archive (1991-1998)

David Kulkarni wrote: > Can anybody tell me what is the largest size of extent > I can have. On Informix 510uc5, running on hp-ux > 10.20. Two gigabytes, bar a little overhead? -- Yours, Jonathan Leffler (Jonathan.Leffler@Informix.com) #include <disclaimer.h> Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN "I don't suffer from insanity; I enjoy every minute of it!"

↪ replying to David Kulkarni

Art S. Kagel — Thu, 10 Aug 2000 11:35:52 -0400 — source: Informix-list mailing list archive (1991-1998)

Absolute max extent is 2GB but that is because an extent must exist entirely within a single chunk and the max chunk size is 2GB, so if your table is beint created in a dbspace with smaller chunks the largest extent size will be limited by the sizes of those chunks. Art S. Kagel David Kulkarni wrote: > > Can anybody tell me what is the largest size of extent > I can have. On Informix 510uc5, running on hp-ux > 10.20. > > TIA > > __________________________________________________ > Do You Yahoo!? > Kick off your party with Yahoo! Invites. > http://invites.yahoo.com/