zOs/SQL/REOTSHIS

select *
   from s100447.tReoRunPart
   where tst > current timestamp -  90 days
      -- and partition > 240
      and db     = 'VV29A1T' and sp = 'VDPS425'
   order by db, sp, part, tst
;;
   group by dbName, name, partition,
       max(value(reorgLastTime, LoadRLastTime)
          ,value(loadRLastTime, reorgLastTime) )
 )
with r as
(
select dbName, name, partition,
       max(value(reorgLastTime, LoadRLastTime)
          ,value(loadRLastTime, reorgLastTime) ) laBui
   from s100447.tReoRunTsStats
   where tst > current timestamp -  90 days
      -- and partition > 240
   and dbName = 'VV29A1T' and name = 'VDPS425'
   group by dbName, name, partition,
       max(value(reorgLastTime, LoadRLastTime)
          ,value(loadRLastTime, reorgLastTime) )
 )
select *
    from r
    order by dbName, name, partition, laBui
;;
select substr(name, 1, 16), partition, count(*)
    from r
   group by creator, name, partition
   order by creator, name, partition
;