CurrentMaintainedTableTypesForOpt CLI/ODBC and IBM data server driver configuration keyword
Sets the value of the CURRENT MAINTAINED TABLE TYPES FOR OPTIMIZATION special register.
- db2cli.ini keyword syntax:
- CurrentMaintainedTableTypesForOpt = ALL | FEDERATED_TOOL | NONE | SYSTEM | USER | <list>
- IBM data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name="CurrentMaintainedTableTypesForOpt" value="ALL | FEDERATED_TOOL | NONE | SYSTEM | USER | list"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- System-maintained refresh-deferred materialized query tables are considered in the optimization of a query.
- Usage notes:
This keyword defines the default value for the CURRENT
MAINTAINED TABLE TYPES FOR OPTIMIZATION special register. The value
of the special register affects the types of tables which are considered
in the optimization of a query. Refer to the SET CURRENT MAINTAINED
TABLE TYPES FOR OPTIMIZATION SQL statement for details on the supported
settings of ALL, FEDERATED_TOOL, NONE, SYSTEM, or USER. The <list> option represents a combination of the supported
settings, however, ALL and NONE cannot be specified with any other
value, and the same value cannot be specified more than once. Separate
each value in the list with a comma, for example:
CurrentMaintainedTableTypesForOpt = SYSTEM,USER