zOs/SQL/CATDSSZ

select count(*), min(name),
     case when unique_count = 0 then '0'
          when unique_count = colCount then '='
          when unique_count < colCount then '<'
                                       else '>'
     end
from sysibm.sysindexes
     group by
     case when unique_count = 0 then '0'
          when unique_count = colCount then '='
          when unique_count < colCount then '<'
                                       else '>'
     end     ;X;
with x as
(
select i.indexType
    ,  (select min(ip.partition) from sysibm.sysIndexPart ip
            where ip.ixCreator = i.creator and ip.ixName = i.name) minPa
    ,  case when ts.partitions = 0   then 'tsNotPar'
            when t.partKeyColNum > 0 then 'tbPart'
                                     else 'ixPart' end tsPa
    from sysibm.sysindexes i
    join sysibm.sysTables t
      on t.creator = i.tbCreator and t.name = i.tbName
    join sysibm.sysTableSpace ts
      on ts.dbName = t.dbName and ts.name = t.tsName
)
select x.*, count(*) cnt
    from x
    group by indexType, minPa, tsPa
    ;
select value(max(clustering), 'YNJUL') from sysibm.sysIndexes
    where creator = '?540769'