dft_mttb_types - Default maintained table types for optimization configuration parameter
This parameter specifies the default value for the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. The value of this register determines what types of refresh deferred materialized query tables will be used during query optimization.
- Configuration type
- Database
- Parameter type
- Configurable
- Default [range]
- SYSTEM [ALL, NONE, FEDERATED_TOOL, SYSTEM, USER, REPLICATION, or a list of values ]
You can specify a list of values that are separated
by commas, for example, 'USER,FEDERATED_TOOL'. ALL
or NONE cannot be listed with other values, and you cannot specify
the same value more than once.
When you set the dft_mttb_types configuration parameter, if the value includes anything other than REPLICATION or NONE, then the dft_refresh_age must have a value of either 0 or 99999999999999 (ANY).
For use with the db2CfgSet and db2CfgGet APIs,
the acceptable parameter values are: 8 (ALL), 4 (NONE),
16 (FEDERATED_TOOL), 32 (REPLICATION),
1 (SYSTEM) and 2 (USER). Multiple
values can be specified together by using bitwise OR; for example,
18 would be the equivalent of USER,FEDERATED_TOOL.
As before, the values 4 and 8 cannot be used with other values.