Progress
Database Administration
Guide and Reference
Analyzing Database Fragmentation
To determine the degree of fragmentation for tables in a database, use PROUTIL with the TABANALYS qualifier:
You can run PROUTIL with the TABANALYS qualifier while the database is in use; however, PROUTIL generates only approximate information.
In the TABANALYS display, check the following fields:
- Count — The total number of record fragments found for each table in the database.
- Fragments Factor — The degree of record fragmentation for each table. If the value is 2.0 or greater, dumping and reloading will improve disk space usage and performance. If the value is less than 1.5, dumping and reloading is unnecessary.
- Scatter Factor — The degree of distance between records in the table. The optimal value for this field varies from database to database. To determine the optimal value for your database, run the TABANALYS qualifier on a freshly loaded database.
The following shows a sample excerpt from a PROUTIL TABANALYS display.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |