BASE_TABLES_IN_RLV_STORE Option
Registers newly created tables in the RLV store, enabling row-level versioning. RLV-enabled tables are eligible for multiple writer concurrent access. You can override this setting at the table level using the CREATE_TABLE statement.
ON, OFF
OFF
Option can be set at the database (PUBLIC) level only.
Requires the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.
When set to ON, newly created tables are registered in the RLV store. RLV-enabled tables are optimized for real-time updates.
The { ENABLE | DISABLE } RLV STORE clause of the CREATE_TABLE statement always overrides the BASE_TABLES_IN_RLV_STORE option.
Once Base_Tables_in_RLV_STORE option is enabled, any newly created IQ base tables are automatically RLV-enabled. Enabling this option has no impact on existing IQ base tables.