Symptom
DB2-z/OS v9.1 offers as a new feature index compression. We strongly recommend to not apply this feature generally but to use it selectively for the most beneficial indexes.
Other terms
DB2 z/OS
index compression
Reason and Prerequisites
There are some aspects to consider before you switch on index compression:
1. Index compression may increase the CPU time and elapsed time
2. [...]
Symptom
If a frame on a screen did not contain screen elements, the frame was not removed by the screen compression.
Solution
The problem is solved by a kernel patch.
Symptom
Database is using too much disk space for indexes
Other terms
disk space, performance, compression, disk I/O
Reason and Prerequisites
Index Key Compression is supported in SAP environments from Oracle Release 10.2 on.Index Key Compression is only available for B*Tree indexes and not for Bitmap Indexes.Please make sure that your PSAPTEMP Temporary Tablespace is at least as big [...]
Symptom
You use 11.50.xC4.
You consider whether or not you want to compress the data of some tables.
Other terms
Compression, extents, performance, reorg, reorganization
Reason and Prerequisites
You use 11.50.xC4 or higher.
The table contains data that can be compressed (no cluster or similar).
Solution
11.50.xC4 provides you with the option of controlling the compression of tables using sysadmin functions:
Activate compressionCompress existing [...]