dft_schemas_rmt - Default schema RMT configuration parameter
The dft_schemas_rmt configuration parameter enables row modification tracking (RMT) for all newly created schemas.
- Configuration type
- Database
- Parameter type
- Configurable online
- Propagation class
- Immediate
- Default [range]
- No [Yes; No ]
- Usage notes
-
As an alternative to setting the ENABLE ROW MODIFICATION TRACKING parameter in a CREATE SCHEMA statement, you can set the
DFT_SCHEMAS_RMTdatabase config parameter to enable row modification tracking (RMT) for all schemas implicitly by default. This parameter takes either a YES or NO value, with NO being the default. If set to YES, then the call to 'create schema schema-name' creates the schema implicitly as RMT. If set to NO, then 'create schema schema-name' creates the schema as non-RMT.The DFT_SCHEMAS_RMT configuration parameter only affects a CREATE SCHEMA statement that does not make explicit use of ENABLE ROW MODIFICATION TRACKING option. The parameter has no impact on a CREATE SCHEMA statement that specifies the ROW MODIFICATION TRACKING option.Note: Schemas that are created before the setting of the DFT_SCHEMAS_RMT configuration parameter do not have RMT enabled by default.