Re: reg empty records purging

calyanram@hotmail.com wrote: > I am able to purge the empty recs by using alter fragment , while > alter frag is under execution i am able to see the increase in the > number of free pages by using onmonitor, but after completion of alt > fragment again it shows the same thing. > > what is the reason? how can solve this? <lecture mode=on subject="please do not waste people's time"> Please - learn how to ask questions properly. You've asked a number of them recently, and you show a sad unawareness of the guidelines on how to ask smart questions: http://www.catb.org/~esr/faqs/smart-questions.html Please include platform and version information in your question. Please include enough information for those of us seeing your questions to have a chance of providing you with an answer. You're in danger of being ignored because the first response always has to be "what is your real question - and what is your platform". And no, people should not have to go and find your previous questions to find out what platform you are working on. Also, please remember the other instruction - RTF(abulous)M. </lecture> OK - lecture over - normal service will be resumed. What platform are you working on? What is the structure of the table? Here, it would help to know the row size, the number of rows, and the pre-existing fragmentation plan, defined extent sizes, how much data has been removed, etc. You altered the fragmentation - that's good. How did you alter the fragmentation? What was the statement used, or describe the alter. Did you refragment via roundrobin, or change the range partitioning strategy or what? Note that IDS generally assumes that if a tables grows to some size (say 3 GB) and then shrinks, the chances are that it will grow to the original size again, and it will be faster to keep the space allocated. If you don't want the space retained, you have to go to more drastic measures. If you're using 10.00.xC4 or later, you could use TRUNCATE TABLE - though you'd be very careful about doing so. If you prefer, you can transfer the data to be retained out of the original table - into a temp table, for example - and then truncate or drop the table, and reload from the temp table. Or you could alter an index on the empty table to cluster - and then reload it. This rebuilds the (empty) table and that releases the old space. Or ... be inventive. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/