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: Start of changeoption 19 on panel DSNTIPBEnd of change
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.