How to calculate the limit for extents of a table in Informix?

How to calculate the limit for extents of a table in Informix?

Post by hanna_s.. » Sun, 31 Dec 1899 09:00:00



Hi,

I know the limit of extents in Informix is between 50 to 200(depends on
different table definition). Do you know how to estimate the limit? I
have a table which has 72 extents right now. There are 6 indexes, no
blob, several vchar columns in the table. The table is fragmented in 5
dbspaces.

Thanks.

Sent via Deja.com http://www.deja.com/
Before you buy.

 
 
 

1. How to calculate the limit for extents of a table in Informix

The limit on the number of extents applies to each partition.
Since each of your table fragments has a separate partition number,
your limit for that table will be much higher that 200.

If your indexes are detached from the table, your table has even more
partition numbers.  For more information on this topic, look at:

1) http://www.informix.com/answers/english/docs/92ids/6213.pdf (pg. 6-37)
2) http://www.markscranton.com/informix/monthly_topic.htm#January 15, 1999

Rick

2. SQL Mail and Agent Mail with Lotus Notes

3. calculating extent sizes for existing tables

4. US-PA-CERTIFIED INSTRUCTORS

5. Calculating table sizes, index pages, extents

6. PostgreSQL v7.1.3 bundled and uploaded to central FTP Server

7. Find limited max extents of a table

8. bit field performance

9. Calculating when a segment will need a new extent

10. calculating next extent

11. Algorithm for calculating extent size in LMT

12. Calculating First Extent Size

13. Calculating max extent