zOs/SQL/CATINDEX

select count(*), space, nactive, totalentries
    from sysIbm.indexSpaceSTats
    where totalentries < 10
    group by space, nactive, totalentries
    order by 2, 3, 4
;
x
select count(*), year(createdts), min(createdts)
    from sysibm.sysIndexes
    group by year(createdts)
    order by 2 desc