2. Using Ingres Commands : sysmod Command--Modify System Catalogs to Current Storage Structure
 
Share this page                  
sysmod Command--Modify System Catalogs to Current Storage Structure
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 [/server_class] {tablename} [-f product {product}]
[-page_size=n][+w|-w]
dbname
Specifies the name of the database, and if required, the server_class, as described in Standard Flags and Parameters. Do not specify the server_class as /star if the database is an Ingres Star distributed database.
tablename
Specifies individual tables to be modified by sysmod. The tables can be Ingres Star standard catalogs or Ingres Star-specific system catalogs. If omitted, all tables in the database are processed.
-f product
Specifies the user interface products for which you want to modify system tables. Allowable product names are ingres, ingres/dbd, vision, and windows_4gl, as described in Standard Flags and Parameters. If you omit this parameter, all user interfaces are processed.
Note:  You cannot specify individual user interface catalogs; when you specify the product parameter, all catalogs are processed for that user interface product.
-page_size=n
Permits modifying the existing system catalogs with a different page size: Specify page_size=n, where n is one of 2048, 4096, 8192, 16384, 32768, 65536.
Example: SYSMOD test –page_size=4096
+w|-w
Directs sysmod to wait (+w) or not wait (-w) until the database is free before executing. The default is ‑w.
On VMS, this flag is not valid in batch mode.