Re: FW: Defragmenter
If you are on a SMP box, (and have the space), it is faster
to defrag by creating a copy of the table, drop the original,
rename the copy and re-apply the indices/constraints.
-d
At 01:39 PM 9/8/97 -0500, London, Johnny wrote:
}
}} The only way I'm aware of to defragment a table is to unload, drop,
}} create and reload the offending table. The so-called "Defragmenters"
}} on the market that I have looked at simply provide a front end for
}} this task.
}}
}} As far as as determining which tables have too many extents, this
}} script will do it:
}}
}} dbaccess sysmaster <<EOF
}} select dbsname,tabname,count(*) from sysextents
}} group by 1,2
}} having count(*) > 8
}} order by 3 desc
}} EOF
}}
}} Again, there are tools that will provide prettier output, if you like
}} that kind of thing.
}} Of course, you can tweak the SQL to be more selective.
}}
}} If there is some "in-place" DOS-Like defragmenter available I would
}} also like
}} to know about it.
}}
}} -Johnny
}}
}} ~
}} ~
}} ~
}}
}} -----Original Message-----
}} From: Paul Card [SMTP:pscard@global.co.za]
}} Sent: Sunday, September 07, 1997 10:45 PM
}} To: informix-list@rmy.emory.edu
}} Subject: Re: Defragmenter
}}
}}
}} Try
}} Platinum
}} http://www.platinum.com/products/dba/tsrei_ps.htm
}}
}} Valiry Fouques <valery.fouques@wanadoo.fr> wrote in article
}} <341037AC.C22FBA84@wanadoo.fr>...
}} >
}} > Hi,
}} > I'm looking for a "page level database defragmenter". I know such a
}} > product exists, is not supported by Informix, and it must be VERY
}} hard
}} > to get it.
}} >
}} > If someone can help...
}} >
}} > --
}} > Valery Fouques Valery.Fouques@wanadoo.fr
}} > SYSADM GOSPORT-FRANCE /\\oO/\\
}} >
}} > _ __/|
}} > \\`O.o' "355/113 -- Not the famous irrational
}} > =(_ _)= number PI, but an incredible simulation!"
}} > U
}} >
}
}