Re: TRUNCATE Table - DROP STORAGE
Yes, there is, although for a while this might not have
been supported.
set environment variable RASHELP to 1
oncheck -me <TBLspace/partition number> <target number of extents>
So, take a table with 50 extents you can reduce it to 1 if you have
enough contiguous space by setting the target to 1.
There were a couple of threads about this a while back.
I have used it numerous times in dev.
HTH,
Zev Berezin
Subject: TRUNCATE Table - DROP STORAGE
Date sent: Wed, 2 Nov 2005 13:11:06 -0700
From: "Urich Ann" <Uricha@mcao.maricopa.gov>
To: <informix-list@iiug.org>
> 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