RE: TRUNCATE Table - DROP STORAGE

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