zOs/SQL/GBGRCLID

select rz, dbSys, loadTs, count(*)
       , sum(case when state='a' then 1 else 0 end) sA
       , sum(case when state='d' then 1 else 0 end) sD
-- gbGr cleanup
    from OA1P.TQZ007GBGRIXSTATS
    where -- rz ='RZ2'
            loadTs between '2015-10-01-00.00.00'
                       and '2015-11-01-00.00.00'
    group by rz,dbSys, loadTs
    order by rz, dbSys, loadTs
;