Improving Database Efficiency
Degradation in system performance caused by data files becoming too large or disk fragmentation can be dealt with from the Reality environment using the following:
- SIZE-MONITOR command to check for badly-sized files.
- RESIZE-FILE command to resize the files while enabling continuous access to the files.
- SLS command to remove redundant data from system log files.
- Periodic FILE-SAVE, mkdbase -r, then ACCOUNT-RESTORE * (O to avoid fragmentation.
Caution
The O option should be used with extreme caution. Refer to Reality Save and Restore Facilities.
For a detailed discussion, see the topic Improving Database Efficiency in the section Administration from the Host.