zOs/SQL/TADMCMD

select count(*), system, dbMbr, min(tst), max(tst)
 -- from oa1p.tadmCmd
    from oa1p.tqz050Cmd
--  where tst between '2014-03-01-00.00.00'
--                and '2014-04-24-00.00.00'
    group by dbMbr, system -- , trunc_timestamp(tst, 'mon')
    order by 2, 3, 4
    with ur
;x;
select count(*), system, dbMbr, min(timestamp), max(timestamp)
    from oa1p.tadmCmd
 -- from oa1p.tqz050Cmd
    where timestamp between '2014-03-01-00.00.00'
                  and '2014-04-24-00.00.00'
    group by dbMbr, system, trunc_timestamp(timestamp, 'mon')
    order by 2, 3, 4
    with ur
;x;
select smallint(row_number() over ()), c.*
    from oa1p.tadmCmd c
    where timestamp between '2014-04-01-00.00.00'
                  and '2014-04-22-22.00.00'
          and system='S21' and dbMbr = 'DOF1'
    order by system,dbMbr, timestamp
    with ur
;;;;;;;;
select count(*), dbMbr, system, min(timestamp), max(timestamp)
    from oa1p.tadmCmd
    where timestamp between '2013-10-01-00.00.00'
                  and '2014-04-22-12.00.00'
    group by dbMbr, system, trunc_timestamp(timestamp, 'mon')
    order by 2, 3, 4
    with ur
;;;;;;;;