Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003

    Unanswered: extent size when using "alter fragment"

    We use Informix 7.31. When using the "alter fragment on table ... init in .... " command for reorganizing a table by putting it into a new dbspace, the extent size is not what is expected ! We used the "alter table ..." command to change the next extent size to 204800 Kb. After the fragmentation the first and only extent of the table has a size of 126526 pages (4 KB) so that corresponds to 506104 Kb, which is a lot more than we wanted.
    We have the same problem with other tables and there seems to be no link between the wanted and obtained size !

    How is the extent size chosen ?

    Best regards.
    Last edited by awdba; 06-02-03 at 10:50.

  2. #2
    Join Date
    Aug 2002
    This is called extent concatenation. If two extents for
    the same table are physically contiguous, they will
    be considered as one extent by Informix.

    This is nothing you have to worry about. It is a good
    feature that reduces the number of extents per table.

    Best regards

    IT-Consulting Herber

    Download the IFMX Database-Monitor for free at:

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts