zOs/SQL/VVROW

select *
    from oa1p.tqz060Timeout
    where rz = 'RR2' and dbSys = 'DBOF'
    and name like '%VV%'
    order by timestamp desc
;x;
select *
    from oa1p.tqz064LockEscal
    where rz = 'RR2' and dbSys = 'DBOF'
    and resource like '%VV%'
    order by timestamp desc
;x;
select count(*), min(timestamp), max(timestamp)
               , min(loadDate ), max(loadDate)
    from oa1p.tqz064LockEscal
    where rz = 'RR2' and dbSys = 'DBOF'
    GROUP  by trunc_timestamp(timestamp, 'mon')
;x;