Check the compression ratio or percentage achieved for the database

[Former Member]

Hi there,

Is there a report or utility I can either at sap level or DB2 level to check the compression ratio or percentage achieved after activating compression on DB2?

I am aware of the utility /ISIS/ZCOMP but not sure if this can help in achieving my request.

Regards,

Venkatesh.K

[malte_schuenemann]

Use the ADMIN_GET_TAB_COMPRESS_INFO, and on 9.7 also the ADMIN_GET_INDEX_COMPRESS_INFO table function.

Malte