Database Administrator Guide > Database Administrator Guide > Improving Database and Query Performance > Database Maintenance Issues > System Modification and Performance
Was this helpful?
System Modification and Performance
The system modification feature modifies system catalogs to predetermined storage structures.
• Run system modification on the iistatistics system catalog after optimization.
• Run system modification on ii_rcommands if you create and update a lot of Report-Writer reports.
• Regularly using system modification reduces overflow in your system catalogs. Run it often if catalog changes are frequent due to development or if you use many CREATE or DROP statements in your applications.
To perform system modification, use the sysmod command, the Modify System Tables dialog in Director, or the System Modification dialog in VDBA.
Last modified date: 08/29/2024