A. Command Reference : sysmod Command--Modify System Catalogs
 
Share this page                  
sysmod Command--Modify System Catalogs
Permission required: DBA or system administrator.
The sysmod command modifies the system catalogs of a database to their currently defined storage structure. Doing so removes overflow and deleted pages, which results in accelerating query processing. You can run sysmod on all or specified system catalog tables.
The sysmod operation requires exclusive access to the database.
The sysmod command has the following format:
sysmod dbname {tablename} [+w|-w]
dbname
Specifies the name of the database.
tablename
Specifies individual tables to be modified by sysmod. If omitted, all tables in the database are processed.
+w|-w
Directs sysmod to wait (+w) or not wait (-w) until the database is free before executing. The default is ‑w.