zOs/SQL/CAT

select distinct        min(char(dbname, 9) || char(creator, 8)),
                       max(char(dbname, 9) || char(creator, 8))
    from sysibm.systables
    where name like 'TWL%' and type = 'T'
          and left(creator, 1) in ('O', 'G')
    group by name
 -- order by name
   ;
select char(creator, 8), char(name, 16), char(dbname, 8)
    from sysibm.systables
    where name like 'TWL%' and type = 'T'
    order by 2, 1
   ;
   x
select * from sysibm.sysviews where name like 'VPV0%';
xelect     c.name, c.creator ,
           c.dbname , c.tsname ,
           c.p_part, c.p_limit,
           count(all tid150tst) tst_all,
           count(distinct tid150tst) tst_dist,
           min(tid150md)  md_min,
           max(tid150md)  md_max,
           min(tid150tst) tst_min,  max(tid150tst) tst_max
  from
    ( select
         t.name, t.creator, t.dbname, t.tsname,
         p.partition p_part, int(p.limitKey) p_limit,
         q.partition q_part, int(q.limitKey) q_limNu,
         case when q.limitKey is null then -9999 else int(q.limitKey)
              end q_limit
      from sysibm.systables t
        join sysibm.systablePart p
          on t.tsname = p.tsname and t.dbname = p.dbname
        left join sysibm.systablePart q
          on p.tsname = q.tsname and p.dbname = q.dbname
             and p.partition - 1 = q.partition
      where t.name = 'TID150A1' and t.creator = 'OA1A' ) c
    left join oa1a.tid150a1 d
      on d.tid150md > c.q_limit and d.tid150md <= c.p_limit
  group by c.name, c.creator, c.dbname, c.tsname, p_part, p_limit
           ;