I have using the dba cockpit to enable the compression of the "Biggest table" of the SAP Bank Analyzer ( reducing the table from 360GB to 100GB ). This OFFLINE process took 23 hours.
Please , advise us how to the compress also the INDEXES of the tables.
Hello Mr. Arun,
Thanks for contacting us.
Kindly use the below command to enable the compression on a particular table. But before enabling the compression, make sure that you have executed query given in note 886231 to make sure whether compression is required for this table or not.
ALTER TABLE <tabname> ACTIVATE VALUE COMPRESSION
Kindly refer below note
#1942183 - DB6: When to consider a table or index reorganization
#975352 - DB6: Configuring DB2 Auto Reorg for Space Reclamation and Index Cleanup
Hope the above information helps!