zOs/SQL/CATIXPA

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
    ;