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. |