IBM FileNet P8, Version 5.2.1            

Enabling IBM® DB2 index compression

Enabling index compression on indexes that are part of large Content Platform Engine database tables can improve application response times.

Complete the following procedure to enable compression on a DB2® index:
Run the following command:

ALTER INDEX index_name COMPRESS YES;

The ALTER command (as shown) initiates compression of the specified index.
Note: After a large number of random inserts have been performed, run the REORG INDEX command to keep the compressed index organized.


Last updated: March 2016
p8ppt158.htm

© Copyright IBM Corporation 2016.