zOs/SQL/PART

select     char(t.name,20) ,
           t.creator,                                char(' '),
           t.dbname,                                 char(' '),
           t.tsname,                                 char(' '),
           char(coalesce(char(p.partition), '<<null>>') || ' '),
           char(coalesce(char(int(p.limitKey)), '<<null>>'))
  from sysibm.systables t
    left join sysibm.systablepart p
      on t.tsname = p.tsname and t.dbname = p.dbname
  where t.name = 'TID150A1' and t.creator = 'OA1P'
  order by p.partition
;
select     char(tid150md),                           char(' '),
           char(coalesce(sum(cnt), 0)),              char(' '),
           char(count(distinct tid150tst)) ,         char(' '),
           char(coalesce(char(min(tid150tst)), '--') || ' '),
           char(coalesce(char(max(tid150tst)), '--'))
  from
    ( select tid150tst, tid150md, count(*) cnt
          from OA1P.tid150a1
          group by tid150md, tid150tst
    ) g
  group by tid150md
  order by tid150md
;