Modifying System Tables (Catalogs)
You may modify system tables (catalogs) of user databases to the most appropriate predetermined storage structures to accelerate query processing. Regularly modifying system tables will reduce overflow in your system catalogs. Perform this operation often if catalog changes are frequent because of development or if you use many CREATE or DROP statements in your applications.
The following conditions must be met before you can modify system tables:
• A user database node must be selected in the Instance Explorer.
For more information about the sysmod command, see the Ingres Command Reference Guide.
Modify System Tables Dialog
The Modify System Tables dialog lets you set options for modifying system catalogs of a database to its currently defined storage structure. This dialog contains the following pages:
• General
• Options
• Output Log
Many of the options on this dialog are mutually exclusive, meaning you may choose only one.
For more information, see
Modify System Tables.
General Page
This page contains the following options:
All System Tables
Specifies that all system tables in the database be modified to their defined storage structure
Specify Tables
Lets you choose which system tables to modify to their defined storage structure. Click the Tables button to select the system tables to modify.
Include Frontend Product Catalogs
Specifies that frontend catalogs be included in the modification
Exclude Frontend Product Catalogs
Specifies that frontend catalogs be excluded from the modification
Modify Frontend Product Catalogs Only
Specifies that only the selected product catalogs be included in the modification. You may select one or more of the following products to include:
• Ingres Character-Based Tools
• Ingres Data Modeling
• Vision
• OpenROAD
Options Page
This page contains the following options:
Wait for Database
Specifies whether to wait until the database is free before starting the modification
Default: Don’t Wait
Page Size
Lets you modify the existing system catalogs with a different page size
Output Log
This page displays the progress and output of the modification command when you click OK on the Modify System Tables dialog.
Modify System Tables
To modify system tables (catalogs) to the most appropriate predetermined storage structures, the Instance Explorer must be
connected to the installation that contains the database (see
Connect to an Actian Database Instance).
You modify system tables using the
Modify System Tables dialog (see
Modify System Tables Dialog). You can open this dialog the following ways:
• From the context menu of a user database node: DBA Utilities, Modify System Tables
• On the main menu ribbon when a user database node is selected in the Instance Explorer:
Database, Database, Modify System Tables (see
Database Tab)
To modify system tables
1. Open the Modify System Tables dialog in one of the ways explained previously.
2. On the General page, specify whether you want to modify all system catalogs for the database or specific tables. If you choose to specify particular system tables, click Tables to select them.
3. Choose whether you want to include or exclude frontend product catalogs in the modification.
4. Specify any particular products you want to include or exclude in the system tables modification.
5. Click the Options link in the “Select a page” portlet to display the Options page.
6. Choose whether you want the database to be inactive before running sysmod.
7. Select a different page size, if desired.
8. Click OK.
The Output Log page is displayed, and output is displayed on the text page. The final line of output should be:
Sysmod of database 'database_name' completed successfully.
9. Click Close to close the dialog.