zOs/SQL/CHECKRTZ

select char(reason, 40), char(db, 8), char(ts, 8), partition
    from s100447.vRtsReoTS
    where db like 'CZ%' and ts like 'A202%'
    ;
    x
select *           KS09A1T.IKS835A6
    from s100447.vRtsReoTSSchwelle
    where db = 'CZ03G1T' and ts = 'A324A' and part = 1
    ;
select  DAYS(CURRENT TIMESTAMP) - DAYS(
       max(coalesce(reorgLastTime, createdTS),
           coalesce(loadrLastTime, createdTS))) ,
        DAYS(CURRENT TIMESTAMP) , DAYS(
       max(coalesce(reorgLastTime, createdTS),
           coalesce(loadrLastTime, createdTS))),
        DAYS(CURRENT TIMESTAMP- 5 hour)
    from sysibm.tableSpaceSTats r,
         sysibm.systablePart  p
    where r.dbName = p.dbName and r.name = p.tsname
           and r.partition = p.partition
     and r.dbName = 'CZ03G1T' and r.name = 'A324A' and r.partition = 1
    ;
    CZ03G1T.A364A:5