Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Compression for tables and indexes

With version 9.7 its possible to compress both data and indexes.We´ll like to do this during an OTM via db6conv where the normal table compression was also possible in former versions.

Now the quesition is, are the indexes also im compression mode if we activate this for the table or should we use both commands

db2 "alter table compress yes"

before starting OTM?

Is there any command to compress all indexes for one table in one command. Can I use any automtic function to compress the most indexes?

Regards

Olaf

Former Member
Former Member replied

Hello Olaf,

short answer. Yes...

Here are some links for compression with OTM:

https://websmp230.sap-ag.de/sap%28bD1kZSZjPTAwMQ==%29/bc/bsp/spn/sapnotes/index2.htm?numm=1513862

Attached there you will find a PDF document.

New in Version 9.7 of IBM DB2 for Linux, UNIX, and Windows [original link is broken]

Here you will find a document, "Enabling DB2 LUW Version 9.7u2019s Index Compression in an SAP environment"

Best regards,

Joachim

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question