Re: initial extent is LESS THAN first extent size :WHY??

ssoman@omm.com wrote: > Hi all, > I had a table with 32 extents ( about 5GB in total size ), I re-organized > this table by creating a copy of it in a seperate new dbspace with the first > extent size calculated to be 10% more than the current size, and the next extent > being 20% more for growth. I ran an "insert into newtab select * from oldtab", > and guess what, I end up with 2 extents, not one as I expected. Each extent is > in a different chunk. ( the first one filled up an entire chunk ) and the next > one a part of the next If Informix cannot allocate an extent of the specified size it will used the largest available contiguous space - in this case 2Gb and likewise for the next extent. BTW you will not have reserved as much room for growth as you originally planned for. > I have a few questions on this scenario > > 1. Can I have ONE extent spanning over multiple chunks, or does multiple no, an extent cannot span chunks > chunks mean multiple extents ( assuming there is nothing but that table on those > specified chunk(s) ) > If the latter is true, does that mean that any table > 2GB CAN NEVER have > only ONE extent. yes, I think the 2Gb is a unix partition limit > 2. I re-organized two tables in the same method, and ran the "insert > into..." parallelly. Would this interfere with space allocation, or does > INFORMIX pre-allocate space, and when ? it could intefere if both tables have small next extent sizes and you are allocating next extents during the data loads ( or when creating the indexes ). > 3. When I create the indexes on this table ( which takes up more than 2.5 > times the data space ), will that be treated the same way as the data pages ? unless you are able to use the IN DBspace clause when creating an index then they are treated in exactly the same way. > 4. How do I find out where the indexes of a table are located ( physical > disk/chunk ) oncheck -pT ? > > > As usual, thanks for your responses > > Sujata > > ***************************************** > Sujata Soman > > > E-Mail: ssoman@omm.com > > O'Melveny & Myers, Los Angeles > > ****************************************** Hope this helpsPete