The minimum extent size is 4 times the disk-page size.
For example, on a system with 2-kilobyte pages, the minimum length
is 8 kilobytes. The maximum length is the chunk size. The following
example specifies an extent size of 32 kilobytes:
ALTERTABLE customer MODIFY NEXTSIZE32;
This clause cannot change the size of existing extents.
You cannot change the size of existing extents without unloading all
of the data.
To
change the size of existing extents, you must unload all the data,
drop the table, modify the first-extent and next-extent sizes
in the CREATE TABLE definition in the database schema, re-create the
table, and reload the data. For information about how to optimize
extent sizes, see your HCL OneDB™ Performance
Guide.