CURRENT MAINT TYPES field (MAINTYPE subsystem parameter)
The MAINTYPE subsystem parameter specifies the default value for the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. This value is to be used when no value is explicitly set by using the SQL statement SET CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION.
| Acceptable values: | NONE, SYSTEM, USER, ALL |
|---|---|
| Default: | SYSTEM |
| Update: | option 30 on panel DSNTIPB |
| DSNZPxxx: | DSN6SPRM MAINTYPE |
- NONE
- Does not allow query rewrite.
- SYSTEM
- Allows query rewrite by using system-maintained materialized query tables (SYSTEM) when CURRENT REFRESH AGE is set to ANY.
- USER
- Allows query rewrite by using user-maintained materialized query tables when CURRENT REFRESH AGE is set to ANY.
- ALL
- Allows query rewrite by using both system-maintained and user-maintained materialized query tables.