There are many circumstances in which you may benefit from a dump and load, either partial or full. These would include moving from Type I to Type II storage, restructuring Type II storage areas, e.g. to relocate storage objects or change area attributes like records per block or blocks per cluster, addressing issues with record scatter or fragmentation, reclaiming disk space after a large data purge, improving index utilization, etc.
You can get a static analysis of your "dbname" database with the following command (assumes your DLC and PATH environment variables are set correctly):
Code:
proutil dbname -C dbanalys > dbname.dba
The resulting text file (dbname.dba) contains information about your tables, indexes, and DB in general. With a little massaging you can import the RECORD BLOCK SUMMARY section into Excel to get an idea of which are your large/fast-growing tables that should be in their own storage areas.
For a good overview of storage optimization, read Tom Bascom's
Storage Optimization Strategies presentation, or
view it.
Start by posting your DB structure file contents (within CODE tags for readability) and maybe we can make some preliminary suggestions.