Analyze database fragmentation
- Last Updated: August 18, 2026
- 1 minute read
- OpenEdge
- Version 13.1
- Documentation
To determine the degree of fragmentation for tables in a database, use
PROUTIL TABANALYS as shown:
|
You can run PROUTIL TABANLYS online or offline, and you can analyze all
records or a percentage of them using the sample parameter, but for the most
accurate results, scan all records when the database is offline.
To run diagnostic utilities in read-only mode, append the -RO parameter to the command line, as follows:
|
For more information, see Read-only connections.
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
TABANALYSon a freshly loaded database.
The following sample shows an excerpt from a PROUTIL
TABANALYS display:
|