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.

Allowed Values

ON, OFF

Default

OFF

Scope

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.

Remarks

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.