zOs/SQL/MVEXTSEL

 select  rz, dbSys, count(*), max(load), max(tst), min(tst)
     from oa1p.tqz050Cmd
     where load > current date - 5 day
     group by rz, dbSys
     order by rz, dbSys
 ;X;
 select  count(*), count(distinct load), min(load)
     from oa1p.tqz050Cmd
     where load > current date - 1 month
     group by date(load)
     order by 3 desc
 ;X;
select count(*), rz, min(dbMbr), max(dbMbr)
              , min(system), max(system)
              , max(tst), min(tst)
              , max(load), min(load)
               --  ,min(rz), max(rz), min(dbSys),max(dbSys)
    from oa1p.Tqz050cmd
    where load >= current date - 7 days
    group by rz
    order by rz
; x;
select * from oa1p.tqz050cmd
     where rz like '%?%' or dbSys like '%?%'
; x
select count(*), dbMbr, system, year(timestamp)
               , min(timestamp), max(timestamp)
               --  ,min(rz), max(rz), min(dbSys),max(dbSys)
    from oa1p.Tqz050cmd
    where timestamp >= '2013-01-01-00.00.00'
    group by dbMbr, system, year(timestamp)
    order by dbMbr, system, year(timestamp) desc
; x;
 select count(*), rz, dbSys, dbMbr, system, min(tst), max(tst)
     from oa1p.tqz050cmd
     group by rz, dbSys, dbMbr, system
     order by rz, dbSys, dbMbr, system
 ; Y;
    order by rz, dbSys, dbMbr, system
; Y;
update oa1p.tqz050cmd   set dbSys = 'DBOF'
     where rz = 'RZ2' and dbSys = '?' and dbMbr like 'DOF%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DVBP'
     where rz = 'RZ2' and dbSys = '?' and dbMbr like 'DBP%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DP2G'
     where rz = 'RZ2' and dbSys = '?' and dbMbr like 'DP2%'
;
commit;
select *
    from oa1p.tqz050cmd
    where tst = '2012-10-31-16.22.22.74'
    order by tst desc
    fetch first 1000 rows only
;x;
xpdate oa1p.tqz050cmd   set dbSys = 'DC0G'
     where rz = 'RZ8' and dbSys = '?' and dbMbr like 'DC0%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DCVG'
     where rz = 'RZ8' and dbSys = '?' and dbMbr like 'DCV%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DP8G'
     where rz = 'RZ8' and dbSys = '?' and dbMbr like 'DP8%'
;
commit;
commit;
update oa1p.tqz050cmd   set rz    = 'RZ8'
     where rz = 'RZZ' and system like 'S8%'
;
update oa1p.tqz050cmd   set dbSys = 'DE0G'
     where rz = 'RZZ' and dbSys = '?' and dbMbr like 'DE0%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DEVG'
     where rz = 'RZZ' and dbSys = '?' and dbMbr like 'DEV%'
;
commit;
update oa1p.tqz050cmd   set dbSys = 'DBBA'
     where rz = 'RZ1' and dbSys = '?' and dbMbr like 'DBA%'
;
commit;
delete from oa1p.tqz050cmd
     where rz = 'RZ1' -- and dbSys = '?'
;
update oa1p.tqz050cmd   set dbSys = 'DBOL'
     where rz = 'RZ4' and dbSys = '?' and dbMbr like 'DOL%'
;
select *
    from oa1p.tqz050cmd
    order by tst desc
    fetch first 2000 rows  only