zOs/SQL/CATTPART

select vCatName, count(*)
        , sum(case when createdTs > current timestamp- 50 days
            then 1 else 0 end)
    from sysibm.sysTablePart
    group by vCatName
;
select vCatName, count(*)
        , sum(case when createdTs > current timestamp- 50 days
            then 1 else 0 end)
    from sysibm.sysIndexPart
    group by vCatName
;