I'm interested in data decompression in SAP systems.
Which algorithm is used for compression/decompression in clustered tables? For example, in RFBLG
table. I read something about the LZ algorithm but I'm not sure how it exactly works.
Is there a detailed document describing how it works in SAP?
The compression mechanisms would be highly dependent on the DB backend behind the Netweaver.
You can view compression method in Database Utility (SE14) by Go To->Storage Parameters.
Generally SAP uses three compression types for clustered (as well) data:
However, their implementation by DB vendors may differ significantly.
SAP and MS created MSSCOMPRESS report for performing table compression. Look at these articles too, where MS mentions about UCS-2 compression for SAP systems:
Oracle involves its own compression mechanisms which are described, for example, in note 1436352, called Oracle Database 11g Advanced Compression for SAP Systems (S-LOGIN required).
DB2 uses LZ2 (Lempel-Z) algorithm as your correctly stated. Here is detailed manual.