zOs/SQL/CATIP

select compress, count(*)
    from sysibm.sysIndexes
    where dbName like 'SU%'
    group by compress