PDA

View Full Version : defrag an Informix database


missy2001
02-27-02, 09:18
As far as I know you can use the onunload/onload routines to get rid of tables that spread over more then one extends.

To check if you got more then one extends use the oncheck -pe |more

townscream
03-14-02, 08:05
if you use dbexport (-ss option) you can then drop
your database and then import .
If you have sufficient contiguous space
all tables will have exactly one extent allocated for them
Surely , new inserts will allocate another extent just immediatelly
If you dont want it to happen
youŽll have to modify the "next extent size" in your <database>.sql
as well as first extent size to give room for the table to grow
without allocating new extents
Tables that have more than 6 extents will cause a lower
performance in your apliccation