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

We're also running SE-Databases and there is only one way to downsize the dat and idx file sizes: unload, drop, load or an dbexport/dbimport. My solution for this problem is to do a weekly dbexport/dbimport in cron. If greater/more lecks in your dat / idx files, this will slow down your performance. In SE 5.xx an alter index xxx to cluster (and back to not cluster) also reduces the file-size. Alter index xxx to cluster copy yourtable into an "temp" table, then drops your "old table" and moves the new temp-table back. All data in this "new table" will be sortet in index-order. After altering to cluster you must alter index to not cluster. If this is also in SE 7.xx must be improved by you. Hope, this helps. Bye Andreas Bettin DBA SE+OL Pneuhage Tires / Germany www.pneu.com In article <353F881E.15476F01@fullcompass.com>, "Alan W. Jurgensen" <alan@fullcompass.com> wrote: > > 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???? > > any other ideas/suggestions? > > thanks in advance!!! > > alan > -- > +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ > Alan W. Jurgensen - Full Compass Systems > phone: (608) 831-7330 - email: alan@fullcompass.com > +=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+=+ > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading