zOs/SQL/CATPKLIS

select collid, count(*)
    from sysibm.syspacklist
    where collid like 'NTA%'
    group by collid
    order by collid
; x;
select max(seqno), count(*), count(distinct planName)
    from sysibm.syspacklist
    with ur