zOs/SQL/SPAHIST

select sum(hi_u_rba), datum
    from OA1Z.TADM09A1
    where datum >= '25.12.2009'
    and db_name like 'NI02%'
    and ts_name like 'A250%'
    group by datum
    order by datum
    with ur
;
x
                                  and partitions_nr = 60
)
select hi_u_rba "bytes used",
       int(100 * hi_u_rba / 4 / 1024 / 1024 / 1024) "% used",
       datum "ab"
with a as
( select hi_u_rba, datum
    from OA1P.TADM09A1
    where db_name = 'NZ06A1P' and ts_name = 'A244A'
                                  and partitions_nr = 60
)
select hi_u_rba "bytes used",
       int(100 * hi_u_rba / 4 / 1024 / 1024 / 1024) "% used",
       datum "ab"
    from a a1
    where not exists (select * from a a2 where a2.datum < a1.datum)
          or a1.hi_u_rba <> (select max(hi_u_rba) from a a3
                            where a3.datum =
                                 (select max(datum) from a a4
                                      where a4.datum < a1.datum))
    order by datum asc
;
xelect hi_u_rba "bytes used",
       int(100 * hi_u_rba / 4 / 1024 / 1024 / 1024) "% used",
       min(datum) "von", max(datum) "bis"
    from OA1P.TADM09A1
    where db_name = 'NZ06A1P' and ts_name = 'A244A'
                                  and partitions_nr = 60
    group by hi_u_rba
    order by min(datum) asc
;
xelect *
    from OA1P.TADM09A1
    where db_name = 'NZ06A1P' and ts_name = 'A244A'
                                  and partitions_nr = 60
    order by datum desc
;   x
select count(*), count(distinct datum), min(datum), max(datum)
    from OA1P.TADM09A1
    where db_name = 'NZ06A1P' and ts_name = 'A244A'
                                  and partitions_nr = 60
;