cancel
Showing results for 
Search instead for 
Did you mean: 

Compress Indexes

Former Member
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

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!

Best Regards,
Gunjan

Answers (0)