Materialized Query Table Queries [DB2 ZOS]

Query The Returned Rows Indicate Resolution

MQT-1

Materialized query table that are defined in Application Designer, but are not found in the database.

Use the Application Designer to build the materialized query table.

MQT-2

Materialized query table that are defined in the database, but are not found in Application Designer.

Drop the materialized query table if it is not valid.

Otherwise, define a new materialized query table in the Application Designer.

MQT-3

Materialized query table that are missing a related language record.

Use the Application Designer to add a related language record for the materialized query tables.

MQT-4

Materialized query tables whose table spaces are not set.

Use the Application Designer to set table space for the materialized query tables.