Show TOC

Materialized Query Tables (DB2)Locate this document in the navigation structure

Materialized query tables are supported for IBM DB2 for z/OS 10 and higher. PowerDesigner models materialized query tables as views with a stereotype of <<Materialized query table>>.

Creating a Materialized Query Table

You can create a materialized query table in any of the following ways:

  • Select Start of the navigation path Model Next navigation step Materialized Query Tables End of the navigation path to access the List of Materialized Query Tables, and click the Add a Row tool.

  • Right-click the model (or a package) in the Browser, and select Start of the navigation path New Next navigation step Materialized Query Table End of the navigation path.

Materialized Query Table Properties

You can modify an object's properties from its property sheet. To open a materialized query table property sheet, double-click its diagram symbol or its Browser entry in the Materialized Query Tables folder.

The following extensions are available on the General tab:

Name

Description

Result table

Specifies whether the materialized view is a query table or result table.

Scripting name: WithNoData

Maintained by

[Query table] Specifies how the data in the materialized query table is maintained.

Scripting name: MaintainedBy

Query optimization

[Query table] Specifies whether this materialized query table can be used for optimization.

Scripting name: QueryOptimization

Column default

[Result table] Specifies whether or not to copy column defaults.

Scripting name: ColumnDefault

Identity

[Result table] Specifies whether or not to copy identity column attributes.

Scripting name: Identity

The following tabs are also available:

  • Partitions - lists the partitions contained within the materialized query table