DB2 Version 9.7 for Linux, UNIX, and Windows

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, or a list of values ]

You can specify a list of values 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. For use with the db2CfgSet and db2CfgGet APIs, the acceptable parameter values are: 8 (ALL), 4 (NONE), 16 (FEDERATED_TOOL), 1 (SYSTEM) and 2 (USER). Multiple values can be specified together 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.