1.Create an RLV dbspace dbsp1 with the db file file1.
CREATE DBSPACE dbsp1
USING FILE file1 'file1.iqrlv'
SIZE 1000
IQ RLV STORE
2.Create an RLV enabled table in the dbspace or RLV enable an existing table.
Enable new table:
CREATE TABLE test1
(rowid INT NOT NULL,
col1 char(25) NOT NULL,
col2 char(25) NULL,
col3 varchar(25) NOT NULL,
col4 varchar(25) NULL)
ENABLE RLV STORE
Enable existing table:
ALTER TABLE test1
ENABLE RLV STORE
3.Verify the table is RLV enabled.
SELECT is_rlv FROM sysiqtab
WHERE table_id = (SELECT table_id FROM systab WHERE table_name = 'test1')
4.Set the snapshot versioning option to "row-level".
SET TEMPORARY OPTION snapshot_versioning = 'Row-level'
5.Check RLV memory usage prior to inserting data into RLV enabled table.
SELECT TOTAL FROM sp_iqrlvmemory('test1', 'DBA')
6.Insert data into the table.
INSERT INTO test1 VALUES (1, 'char25', NULL, 'varchar25', NULL)
INSERT INTO test1 VALUES (2, 'char25', NULL, 'varchar25', NULL)
INSERT INTO test1 VALUES (3, 'char25', NULL, 'varchar25', NULL)
7.Check RLV memory usage after inserting data to RLV enabled table.
SELECT TOTAL FROM sp_iqrlvmemory('test1', 'DBA')
8.Manually merge the data to main Blocking merge.
sp_iqmergerlvstore 'BLOCKING', 'test1','DBA'
9.Check RLV memory usage after merging data to main.
SELECT TOTAL FROM sp_iqrlvmemory('test1', 'DBA')