FW: Defragmenter
} 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
} >