Progress
Database Administration
Guide and Reference
Eliminating Database Fragmentation
You can eliminate database fragmentation two ways:
- Dump and reload the database.
Dumping and reloading the database creates a new starting version of the database and loads the table contents into this new database. During the loading stage the Data tool (either the Data Dictionary or the Data Administration tool) or the 4GL procedure repartitions the disk, removing any gaps created when database elements were deleted, thereby more efficiently allocating disk space. For instructions, see Dumping and Loading."
- Move individual tables and indexes.
You can use the PROUTIL utility with the TABLEMOVE and IDXMOVE qualifiers to move tables and indexes from one storage area to another while the database remains online. As a result, disk space is efficiently allocated and gaps are removed. For more information about moving tables and indexes, see Maintaining Database Structure."
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |