zOs/SQL/PDBPKGA1

select count(*), sum(occurrences), max(Timestamp),
              strip(plan_name) || '.'
              || strip(PCK_COLLECTION_ID) || '.'
              || strip(PCK_ID) || ' ' group_name
    from rz1dd.tacct_program
    where timestamp > current timestamp - 3 DAY
        and ( PCK_COLLECTION_ID like 'A1%'
           or PCK_COLLECTION_ID like 'A2%'
           or PCK_COLLECTION_ID like 'YY%'
           or PCK_COLLECTION_ID like 'NTA%'
           )
    group by plan_name, PCK_COLLECTION_ID, pck_id, group_name
    with ur
;x