IIUG Software Repository Files

README

Allows a DBA to change the dbspace, the initial and next extent sizes
for a table. What it does is unload the data, dump the schema into a
temporary file, edit it using the user supplied parameters for table
dbspace, initial and next extent sizes and the index dbspace, drop the
table and recreate it using the new (edited) schema and the data. It
also allows the DBA to put the indexes into a separate dbspace for
performance reasons. Can be run on a single table or on all tables in
the database. Can also be run with the existing (default) parameters to
eliminate fragmentation in tables with high i/o.