在DB2v9.7上面测试Index压缩功能

bpmfhu · 发表于 2009-6-19 16:50

简单的测试了一下索引压缩的功能，同时Monitor测试系统WorkLoad。简单步骤如下:

db2 => select INDNAME,COMPRESS_ATTR, INDEX_COMPRESSED, INDEX_OBJECT_L_SIZE, INDEX_OBJECT_P_SIZE from table (admin_get_index_info ('T', 'SAPR3', 'SOC3')) as t

INDNAME COMPRESS_ATTR INDEX_COMPRESSED INDEX_OBJECT_L_SIZE INDEX_OBJECT_P_SIZE
-------------------------------- ------------- ---------------- -------------------- --------------------
SOC3~0 N N 610473 610473

1 record(s) selected.

db2 => alter index "SAPR3"."SOC~0" compress yes
DB20000I The SQL command completed successfully.

db2 => reorg indexes all for table SAPR3.SOC3
DB20000I The REORG command completed successfully.

db2 => select INDNAME,COMPRESS_ATTR, INDEX_COMPRESSED, INDEX_OBJECT_L_SIZE, INDEX_OBJECT_P_SIZE from table (admin_get_index_info ('T', 'SAPR3', 'SOC3')) as t

INDNAME COMPRESS_ATTR INDEX_COMPRESSED INDEX_OBJECT_L_SIZE INDEX_OBJECT_P_SIZE
-------------------------------- ------------- ---------------- -------------------- --------------------
SOC3~0 Y Y 258896 258896

1 record(s) selected.

从Nmon收集的数据来看，峰值也就比Normal的时候多2%-3%,基本在可接受范围内。只是一个简单功能测试，对于Update和Insert的并发影响测试留待以后进行

[ 本帖最后由 bpmfhu 于 2009-6-19 17:22 编辑 ]