Materialized Query Tables Editor (IBM DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors
The Materialized Query Tables Editor lets you manage the columns, base query and options for a materialized query table, and work with storage and performance settings.
To edit a materialized query table
- Open an editor on the materialized query table. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab | Settings and tasks | |
---|---|---|
Columns |
Displays the currently defined columns for the materialized Query Table. Optionally, you can Add, Insert, or Edit columns for the materialized query table. | |
Definition |
Base Query |
Lets you view the query that this materialized query table is based on. |
Materialized Query Table Options |
Lets you specify an immediate or deferred Refresh, and explicitly set a Materialized Query Table as Enabled or Disabled or go with the Default. This tab also displays whether the Materialized Query Table is maintained by the system or by a user. | |
Performance |
Tablespace Placement |
Displays Table Tablespace, Index Tablespace, and Long Tablespace settings for the materialized query table. |
Log Options |
Lets you select logging options: Logged initially Data Capture - Lets you select none or change to Include Longvar Columns. NOTE: If you select the Data Capture option, the table name / column name cannot be longer than 18 bytes. | |
Options |
Let you set the Percent Free, Locksize, Append, and Volatile settings for the materialized query table. | |
Partition Columns |
Use the Add and Delete buttons to manage the partition columns for the materialized query table. | |
Space |
Page Information |
Lets you view Row Count and Num. of Overflow Rows values. |
Row Information |
Lets you view Num. of Pages with Rows, Num. of Pages, Percent Free values. | |
Comment |
For details on using this tab, see Adding a Comment to an object. | |
Permissions |
For details on using this tab, see Working with Privileges and Permissions. | |
Dependencies |
For details on using this tab, see Working with Object Dependencies. | |
DDL View |
For details on using this tab, see Viewing the SQL/DDL for an Object. |
- 3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.