2162312 - How to use RLV store in SAP IQ 16.0 - 开启IQ行锁 - 2

           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')
请使用浏览器的分享功能分享到微信等