max size of 9.4 table = dbspace physical limit?

Posted in 2008

Topics: Storage & Space Management, Server Administration

WILL LANDSTROM — Mon, 18 Feb 2008 19:45:51 — source: IIUG Forums & Mailing Lists

Hi everyone. please keep in my I am an oracle/db2 dba new to informix. After poking through my informix books and a few manuals it looks to me that with Informix 9.4 the approximate maximum size limit of a table is roughly equal to the physical size of the freespace in the dbspace it is located in? Is that correct? Unlike oracle and db2 that have specific size restrictions that can ebe placed on individual tables (IE: total # extents) there is NO such restriction on Informix tables. Am I right with my understanding here? Thank you. Will

↪ replying to WILL LANDSTROM

Art S. Kagel — Mon, 18 Feb 2008 20:20:24 — source: IIUG Forums & Mailing Lists

WILL LANDSTROM wrote: > Hi everyone. please keep in my I am an oracle/db2 dba new to informix. After > poking through my informix books and a few manuals it looks to me that with > Informix 9.4 the approximate maximum size limit of a table is roughly equal to > the physical size of the freespace in the dbspace it is located in? Is that > correct? Unlike oracle and db2 that have specific size restrictions that can > ebe placed on individual tables (IE: total # extents) there is NO such > restriction on Informix tables. Am I right with my understanding here? Thank > you. Will > Sort of. An Informix table or index is made up of one or more partitions. A partition lives in a single dbspace (in 10.00 and later multiple partitions for a single table/index can occupy the same dbspace, in 9.40 and earlier versions each dbspace can only contain one partition for any single table or index). Each partition can contain up to 2*10^24 pages or 32GB on systems using a 2K pages size and 64GB on systems using 4K page size (pagesize is configurable for versions 10.00 and later but fixed in 9.40 and earlier). A server instance can have up to 1024 dbspaces in 9.40 and earlier (65534 dbspaces in 10.00 and later) so you can build tables with up to 1024 partitions in 9.40 or 65534 partitions in 10.00 and later (partitions are also unfortunately known as fragments) making the largest table in 9.40 about 32TB and in 10.00 and later about 4PetaBytes. Art S. Kagel Oninit ================================================================================ =========== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.oninit.com/home/disclaimer.php ================================================================================ ===========

↪ replying to Art S. Kagel

WILL — Tue, 19 Feb 2008 14:05:14 — source: IIUG Forums & Mailing Lists

Art. Thanks for the info.

Glossary

dbspace