5. Using a Distributed Database : Modifying Catalogs Using sysmod
 
Share this page                  
Modifying Catalogs Using sysmod
The sysmod command is an Ingres utility to modify system catalogs to predetermined storage structures. Running sysmod can improve performance by reducing system catalog overflow pages caused by a lot of DDL activity. Only the DBA or the system administrator can run sysmod.
You can use sysmod on a distributed database. You can specify particular Ingres Star catalogs as sysmod targets, or default to modifying all system catalogs.
For flags and full syntax details of the sysmod command, see the Command Reference Guide.