Don't forget if the 2nd extent is allocated next to the 1st, IDS will
'merge' the two extents so you will still only have one extent.
I have 'updated' systables to change a 1st extent value before performing an
ALTER FRAGMENT, it worked but is NOT a recommended practice and Tech Support
will have a good laugh if it went wrong and you called them
Regards
Colin
There are 10 types of people in the world, those that understand binary and
those that don't
>From: "Urich Ann" <Uricha@mcao.maricopa.gov>
>To: <informix-list@iiug.org>
>Subject: TRUNCATE Table - DROP STORAGE
>Date: Wed, 2 Nov 2005 13:11:06 -0700
>
>When IDS 10.00.UC4 is available...
>
>My understanding is....
> "TRUNCATE my_table DROP STORAGE" ....
>... All the data is removed. And keeps only the "First extent" size and
>location....
>
>What is the best process to "alter" the "First extent" size as well as
>all data dropped?
>
>In the future, will it be possible to alter (increase/decrease) the
>First extent size with the TRUNCATE utility?
> (example: "TRUNCATE... DROP STORAGE and FIRST EXTENT
>sizehere"?)
>
>My goal is to "Resize" the table so that newly loaded data all fits in
>the First extent.
>
>Is there a way to alter the primary quantity (the First extent size) of
>a table without Deleting the table?
>
> DB2 has:
> (ALTER tablespacehere PRIQTY sizehere;)
> Then, size is allocated with a reorg or load.
> And, if an empty table with a new first extent size is
>desired...
> ...the table gets loaded with a null file (LOAD REPLACE
>nullfilename INTO tablenamehere;).
>sending to informix-list
sending to informix-list