zOs/SQL/EXCEPSTS

select * from A540769.vExceptions_TS
;
select s.dbName, s.tsname, s.partition, remark, e.*
    from sysibm.sysTablePart s, A540769.vExceptions_TS e
    where (s.dbName like 'MF%' or dbName = 'MC03A1A')
          and s.partition < 20
          and e.key = (select max(key) from A540769.vExceptions_TS f
             where left(f.db, f.dbLen) = left(s.dbName, f.dbLen)
              and  left(f.ts, f.tsLen) = left(s.tsName, f.tsLen)
              and  left(f.part, f.partLen) =
                   left(right('00000' || strip(char(s.partition)), 5)
                              , f.partLen)
              and guVon <= current date
              and guBis >= current date
          )
    order by s.dbName, s.tsName, s.partition, e.key
;
select s.dbName, s.name, remark, e.*
    from sysibm.sysTablespace s, A540769.vExceptions_TS e
    where (s.dbName like 'MF%' or dbName = 'MC03A1A')
          and e.key = (select max(key) from A540769.vExceptions_TS f
             where left(f.db, f.dbLen) = left(s.dbName, f.dbLen)
              and  left(f.ts, f.tsLen) = left(s.Name, f.tsLen)
              and  f.part = '*'
              and guVon <= current date
              and guBis >= current date
          )
    order by s.dbName, s.Name, e.key
;