Oninit cdi / Archive
Talk to an expert →

Tablespce Limits

Posted in 1999

Topics: Storage & Space Management, Platform-Specific Issues, Versions, Editions & End-of-Life

Thomas Mieslinger — — source: Informix-list mailing list archive (1991-1998)

Hi *, I read in article by Art S. Kagel that a Tblspace contains the data- and Indexpages of a Table. A Tblspace is limited to 16 Million database pages. That means it can grow up to 32 GB on my System. If I fragment the table, the table will be contained in more than one Tblspace. I´m using IDS 7.31 on Solaris 7 x86. Does the 32 GB Limit still exist? TIA Thomas

↪ replying to Thomas Mieslinger
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)

Yes it does. You can also hold off the limit by detaching indexes so that they get their own tblspace as well. Art S. Kagel Thomas Mieslinger wrote: > > Hi *, > > I read in article by Art S. Kagel that a Tblspace contains > the data- and Indexpages of a Table. A Tblspace is limited to 16 Million > database pages. That means it can grow up to 32 GB on my System. If I > fragment the table, the table will be contained in more than one > Tblspace. > > I´m using IDS 7.31 on Solaris 7 x86. > > Does the 32 GB Limit still exist? > > TIA Thomas

Glossary