Re: How to reduce SE .dat & .idx file sizes?

In article <353F881E.15476F01@fullcompass.com>, Alan W. Jurgensen <alan@fullcompass.com> writes >hiya, > >we're running informix SE version 7.X on AIX RS/6000. I have some >development databases I want to trim the DB file sizes down on... >deleteing old records does nothing to reduce the file sizes... > >I've read in the Faq: >6.8 Space reclamation > >In the good old days of SE, a table with a high level of activity (i.e. >deletions/inserts) became riddled with old data row >slots which were available for re-write, and the index began to look like >swiss cheese. To correct this periodic >unload/loads or cluster manipulation or ALTER TABLE (same as an unload/load >but more user-friendly) were needed >to keep index and data table efficiency at peak. [See section 8.1, part 3] > > >BESIDES doing unload/loads with dbexport/dbschema are there other ways to >reduce file sizes? Tried the "ALTER INDEX idxname TO CLUSTER; " >suggestion in section 8.1, that didn't do it... > >WHAT'S THIS "ALTER TABLE (same as an unload/load but more user-friendly)" >suggestion in the FAQ???? > Ah, the old "magic" trick. Go into isql Table -> Alter Add a column magic char(1) then again go into Alter the Table and drop the column magic. This will cause the table to be rebuilt (twice!) and so reclaim free space. The alter index does also causes the table to be rebuilt. If it makes no difference then yo have no deleted records in the table!! >any other ideas/suggestions? > >thanks in advance!!! > >alan -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care